MySQL 更新:数据库查询中出现意外的输入字段参数 [英] MySQL Update: Unexpected input field parameter in database query

问题描述

这段代码有什么问题?

$SQL1 = "UPDATE table SET status='".$status."' WHERE email='".$client['email']."'";

我收到错误:数据库查询中出现意外的输入字段参数.

I am getting error: Unexpected input field parameter in database query.

这是完整的代码

$server1 = "localhost";
$user_name1 = "DBUSER";
$passworda2 = "2HGfn5D480#";
$database2 = "DBNAME";
$db_handle1 = mysql_connect($server1, $user_name1, $passworda2);
$db_found = mysql_select_db($database2, $db_handle1);
if ($db_found) {
$status = "6";

$SQL1 = "UPDATE table SET status=".$status." WHERE email='".$client['email']."'";

$result = mysql_query($SQL1);
mysql_close($db_handle1);
}
else {
print "Database NOT Found ";
mysql_close($db_handle1);
}

推荐答案

似乎错误的原因是

mysql_close($db_handle1);

我花了 4 个小时才弄明白！:D

took me 4 hours to figure that out ! :D

这篇关于MySQL 更新:数据库查询中出现意外的输入字段参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！