php修改表单数据思路 php修改表单数据思路怎么写
php中的一个表单提交修改数据库中两个表的部分数据要怎么实现~连接mysql语句不会
写2条sql语句啊!
创新互联专注为客户提供全方位的互联网综合服务,包含不限于做网站、网站建设、鲅鱼圈网络推广、小程序开发、鲅鱼圈网络营销、鲅鱼圈企业策划、鲅鱼圈品牌公关、搜索引擎seo、人物专访、企业宣传片、企业代运营等,从售前售中售后,我们都将竭诚为您服务,您的肯定,是我们最大的嘉奖;创新互联为所有大学生创业者提供鲅鱼圈建站搭建服务,24小时服务热线:18980820575,官方网址:www.cdcxhl.com
执行两次修改啊!
当然,如果表有关系的话,也可以在mysql中建立一个触发器
当一个表有变化的时候,会触发例外一个表也进行变化!
不过这个比写php更难弄些!
特别是你刚接触php!
你可以百度一下mysql触发器
我想用php 修改表单数据,要求在单独的修改页面执行
1、新建一个edit.php
2、在edit.php里调用要修改的记录,如果不会再问。
3、将调用的记录数据填充到 edit.php的form里去。
4、将form的action改为action="edit_save.php"
5、把?php
$con=mysql_connect("localhost","root","");
if(!$con)
{
die('Coudl not connet:'.mysql_error());
}
mysql_select_db("my_db", $con);
mysql_query("UPDATE Persons SET Firstname='".$_POST["firstname"]."',
Lastname='".$_POST["lastname"]."',Password='".$_POST["password"]."',Age='".$_POST["age"]."'");
mysql_close($con);
echo "scriptwindow.location.href='1.php';/script ";
?保存为edit_save.php
PHP表单怎样去修改数据库表里的所有内容 - 技术问答
首先要用$_POST接收表单传过来的数据然后用SQL写到库里update table set ........where id=\".$_REQUEST[id]
怎么在php中用表单修改指定数据库表中指定ID的数据
html
headtitle/title/head
body
?php
//数据库查询,得出下面表单id与name的值。
?
form name="form1" action="" method="post"
input type="hidden" name="userid" value="?php echo $id ?" /
input type="text" name="username" value="?php echo $name ?" /
input type="submit" name="submit" /
/form
/body/html
?php
if(isset($_POST['submit'])){
$link = mysql_connect('localhost','root','123456') or die(‘连接失败!’);
mysql_select_db('mydb',$link)or die(‘数据库链接失败!’);
$sql = "update users set user_name='$name' where id='$id'";
$res = mysql_query($sql);
if($res)
echo '修改成功';
else
echo '修改失败';
}
一个复杂的PHP表单处理方案
JS 实现BASE64_ENCODE 和 BASE64_DECODE
script language='javascript'
/* utf.js - UTF-8 = UTF-16 convertion
*
* Copyright (C) 1999 Masanao Izumo iz@onicos.co.jp
* Version: 1.0
* LastModified: Dec 25 1999
* This library is free. You can redistribute it and/or modify it.
*/
/*
* Interfaces:
* utf8 = utf16to8(utf16);
* utf16 = utf16to8(utf8);
*/
function utf16to8(str) {
var out, i, len, c;
out = "";
len = str.length;
for(i = 0; i len; i++) {
c = str.charCodeAt(i);
if ((c = 0x0001) (c = 0x007F)) {
out += str.charAt(i);
} else if (c 0x07FF) {
out += String.fromCharCode(0xE0 | ((c 12) 0x0F));
out += String.fromCharCode(0x80 | ((c 6) 0x3F));
out += String.fromCharCode(0x80 | ((c 0) 0x3F));
} else {
out += String.fromCharCode(0xC0 | ((c 6) 0x1F));
out += String.fromCharCode(0x80 | ((c 0) 0x3F));
}
}
return out;
}
function utf8to16(str) {
var out, i, len, c;
var char2, char3;
out = "";
len = str.length;
i = 0;
while(i len) {
c = str.charCodeAt(i++);
switch(c 4)
{
case 0: case 1: case 2: case 3: case 4: case 5: case 6: case 7:
// 0xxxxxxx
out += str.charAt(i-1);
break;
case 12: case 13:
// 110x xxxx 10xx xxxx
char2 = str.charCodeAt(i++);
out += String.fromCharCode(((c 0x1F) 6) | (char2 0x3F));
break;
case 14:
// 1110 xxxx 10xx xxxx 10xx xxxx
char2 = str.charCodeAt(i++);
char3 = str.charCodeAt(i++);
out += String.fromCharCode(((c 0x0F) 12) |
((char2 0x3F) 6) |
((char3 0x3F) 0));
break;
}
}
return out;
}
/* Copyright (C) 1999 Masanao Izumo iz@onicos.co.jp
* Version: 1.0
* LastModified: Dec 25 1999
* This library is free. You can redistribute it and/or modify it.
*/
/*
* Interfaces:
* b64 = base64encode(data);
* data = base64decode(b64);
*/
var base64EncodeChars = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/";
var base64DecodeChars = new Array(
-1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1,
-1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1,
-1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, 62, -1, -1, -1, 63,
52, 53, 54, 55, 56, 57, 58, 59, 60, 61, -1, -1, -1, -1, -1, -1,
-1, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14,
15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, -1, -1, -1, -1, -1,
-1, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40,
41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, -1, -1, -1, -1, -1);
function base64encode(str) {
var out, i, len;
var c1, c2, c3;
len = str.length;
i = 0;
out = "";
while(i len) {
c1 = str.charCodeAt(i++) 0xff;
if(i == len)
{
out += base64EncodeChars.charAt(c1 2);
out += base64EncodeChars.charAt((c1 0x3) 4);
out += "==";
break;
}
c2 = str.charCodeAt(i++);
if(i == len)
{
out += base64EncodeChars.charAt(c1 2);
out += base64EncodeChars.charAt(((c1 0x3) 4) | ((c2 0xF0) 4));
out += base64EncodeChars.charAt((c2 0xF) 2);
out += "=";
break;
}
c3 = str.charCodeAt(i++);
out += base64EncodeChars.charAt(c1 2);
out += base64EncodeChars.charAt(((c1 0x3) 4) | ((c2 0xF0) 4));
out += base64EncodeChars.charAt(((c2 0xF) 2) | ((c3 0xC0) 6));
out += base64EncodeChars.charAt(c3 0x3F);
}
return out;
}
function base64decode(str) {
var c1, c2, c3, c4;
var i, len, out;
len = str.length;
i = 0;
out = "";
while(i len) {
/* c1 */
do {
c1 = base64DecodeChars[str.charCodeAt(i++) 0xff];
} while(i len c1 == -1);
if(c1 == -1)
break;
/* c2 */
do {
c2 = base64DecodeChars[str.charCodeAt(i++) 0xff];
} while(i len c2 == -1);
if(c2 == -1)
break;
out += String.fromCharCode((c1 2) | ((c2 0x30) 4));
/* c3 */
do {
c3 = str.charCodeAt(i++) 0xff;
if(c3 == 61)
return out;
c3 = base64DecodeChars[c3];
} while(i len c3 == -1);
if(c3 == -1)
break;
out += String.fromCharCode(((c2 0XF) 4) | ((c3 0x3C) 2));
/* c4 */
do {
c4 = str.charCodeAt(i++) 0xff;
if(c4 == 61)
return out;
c4 = base64DecodeChars[c4];
} while(i len c4 == -1);
if(c4 == -1)
break;
out += String.fromCharCode(((c3 0x03) 6) | c4);
}
return out;
}
//input base64 encode
function strdecode(str){
return utf8to16(base64decode(str));
}
document.write(strdecode('5L2g5aW9Iee+juWlsyE='));
/script
首先直接做成一页,中间步骤的数据处理用JS,然后就可以正常提交,交给原系统的注册处理页面
网站栏目:php修改表单数据思路 php修改表单数据思路怎么写
标题网址:http://cdiso.cn/article/dooddss.html