SQL运行也成功了,但会在页面顶部显示以下信息:SQL语句错误: Resource id #14
错误信息: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Resource id #14' at line 1
我的程序是:
$SiteInfo = array(
"SiteName" => ChangeStr($_POST['SiteName']),
"SiteSubName" => ChangeStr($_POST['SiteSubName']),
"SiteUrl" => ChangeStr($_POST['SiteUrl']),
"MasterName" => ChangeStr($_POST['MasterName']),
"MasterEmail" => ChangeStr($_POST['MasterEmail']),
"SiteICP" => ChangeStr($_POST['SiteICP']),
);
foreach($SiteInfo as $k=>$v){
$SQLconn = "INSERT INTO asc_setting(sname,svalue) VALUES('".$k."','".$v."')";
$db->query($SQLconn);
}alert("保存成功!!",2,"setting.php");
程序结果实现了,但就是会在页面顶部报那个错误。
错误信息: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Resource id #14' at line 1
我的程序是:
$SiteInfo = array(
"SiteName" => ChangeStr($_POST['SiteName']),
"SiteSubName" => ChangeStr($_POST['SiteSubName']),
"SiteUrl" => ChangeStr($_POST['SiteUrl']),
"MasterName" => ChangeStr($_POST['MasterName']),
"MasterEmail" => ChangeStr($_POST['MasterEmail']),
"SiteICP" => ChangeStr($_POST['SiteICP']),
);
foreach($SiteInfo as $k=>$v){
$SQLconn = "INSERT INTO asc_setting(sname,svalue) VALUES('".$k."','".$v."')";
$db->query($SQLconn);
}alert("保存成功!!",2,"setting.php");
程序结果实现了,但就是会在页面顶部报那个错误。
请到my.ini中
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"中的‘STRICT_TRANS_TABLES’去掉就回到以前的模式了,或者干脆注销这一行。
试试!
$SQLconn = "INSERT INTO asc_setting(sname,svalue) VALUES('".$k."','".$v."')";
echo $SQLconn;//将得到的结果在MYSQL数据库了执行,看报的是什么错误。