UC知道PHP MYSQL修改的问题
来源：百度知道 编辑：UC知道 时间：2024/05/23 10:51:52
我想把表单传递过来的用户名和密码修改,但程序虽然运行成功,却一直修改不了.哪位PHP高手帮我看一下.万分感谢!代码如下:
<?php
include('file.php');
$u = new file;
$u->conn();
$u->db();//以上为连接数据库
$sql = 'select * from pass';//数据库为PASS
$query = mysql_query($sql);
$id = $_POST['id'];
$a = $_POST['name'];
$b = $_POST['password'];
$sql1 = "update `pass` set `name` = '$a',`password`= '$b' where id= '$id' ";
while($r=mysql_fetch_array($query))
{
if($id == $r->id)
{
mysql_query($sql1);
}
}
?>
<?php
include('file.php');
$u = new file;
$u->conn();
$u->db();//以上为连接数据库
$sql = 'select * from pass';//数据库为PASS
$query = mysql_query($sql);
$id = $_POST['id'];
$a = $_POST['name'];
$b = $_POST['password'];
$sql1 = "update `pass` set `name` = '$a',`password`= '$b' where id= '$id' ";
while($r=mysql_fetch_array($query))
{
if($id == $r->id)
{
mysql_query($sql1);
}
}
?>
改成这样试试
$sql1 = "update `pass` set `name` = '".$a."',`password`= '".$b."' where id= '".$id."' ";
下面是我自己写的updata过程，你自己对比下看看
$sql="UPDATE `baseinfo` SET `No` = '$No',
`sex` = '$sex',
`born` = '$born',
`minzu` = '$minzu',
`jiehun` = '$jiehun',
`phone` = '$phone',
`worktime` = '$worktime',
`adress` = '$adress',
`class` = '$class',
`mianmao` = '$mianmao',
`zhiwu` = '$zhiwu' WHERE `name` = '$name' ";
注意：`是键盘上1左边的符号 '是单引号