/* 修改信息的页面 */
if(isset($_GET['id'])){
$id = $_GET['id'];
@mysql_connect("localhost","admin","admin")
or die("数据库连接失败!");
@mysql_select_db("test")
or die("选择的数据库不存在或不可用!");
mysql_query("set names utf8");
$sql = "select * from userinfo where userid = '$id'";
$myquery = @mysql_query($sql)
or die("SQL 语句执行失败!");
$row = mysql_fetch_array($myquery,MYSQL_BOTH);
echo "html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'>";
echo "";
echo "
";echo "";
echo "
修改数据";echo "";
echo "
";echo "
echo "
";echo "
ID:$row[0]";echo "
";echo "
";echo "
姓名:";echo "
";echo "
";echo "
";echo "
性别:";echo "
";echo "
";echo "
";echo "
地址:";echo "
";echo "
";echo "
";echo "
邮件:";echo "
";echo "
";echo "
";echo "
";echo "
";echo "
";echo "
";echo "
";echo "
";echo "";
echo "";
mysql_close();
}else{
echo "ID 号错误,请浏览";
}
?>
/* 更改信息后提交的处理页 */
$userid = $_POST['userid'];
$username = $_POST['username'];
$sex = $_POST['sex'];
$address = $_POST['address'];
$email = $_POST['email'];
$upd_sql = "update userinfo set username = '$username',sex = '$sex',address = '$address',
email = '$email' where userid = '$userid'";
//$upd_sql = "delete from userinfo where userid = '$userid'";
@mysql_connect("localhost","admin","admin")
or die("数据库连接失败!");
@mysql_select_db("test")
or die("选择的数据库不存在或不可用!");
mysql_query("set names utf8");
$myquery = mysql_query($upd_sql);
if($myquery){
echo "更新数据成功!";
}else{
echo "更新数据失败!";
}
echo "浏览";
?>
数据库连接成功,查询可以成功,唯独 updata delete insert 这些操作不起作用,浏览器输出结果是“更新数据成功!”。
但数据库中的信息并没有更改,直接在数据库中执行 "update userinfo set username = '$username',sex = '$sex',
address = '$address',email = '$email' where userid = '$userid'" 可以成功。到底是哪里出了问题啊?