问题描述
我的代码-
require 'database.php';
$title = mysql_real_escape_string($_POST['title']); //line 48
$cat = $_POST['cat'];
$txtart = mysql_real_escape_string($_POST['artbody']); //line 50
$date = date("d-m-y");
$q = "INSERT INTO tblarticle (art_title, art_cat, art_des, art_date) VALUES ('$title', '$cat', '$txtart', '$date')";
错误->
警告:mysql_real_escape_string()[function.mysql-real-escape-string]:在C:\ xampp \ htdocs \ shizin \ admin \ newArticle.php中拒绝对用户'ODBC'@'localhost'(使用密码:NO)的访问第48行
ERROR-->
Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampp\htdocs\shizin\admin\newArticle.php on line 48
警告:mysql_real_escape_string()[function.mysql-real-escape-string]:无法在第48行的C:\ xampp \ htdocs \ shizin \ admin \ newArticle.php中建立到服务器的链接
Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\xampp\htdocs\shizin\admin\newArticle.php on line 48
警告:mysql_real_escape_string()[function.mysql-real-escape-string]:在C:\ xampp \ htdocs \ shizin \ admin \ newArticle中拒绝访问用户'ODBC'@'localhost'(使用密码:NO) .php在第50行
Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampp\htdocs\shizin\admin\newArticle.php on line 50
警告:mysql_real_escape_string()[function.mysql-real-escape-string]:无法在第50行的C:\ xampp \ htdocs \ shizin \ admin \ newArticle.php中建立到服务器的链接
Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\xampp\htdocs\shizin\admin\newArticle.php on line 50
但是数据已保存在数据库中,但标题和artbody字段为空
推荐答案
mysql_real_escape_string
尝试连接到本地数据库,因此它可以获取为该系统正确地转义字符串所需的设置.
mysql_real_escape_string
tries to connect to the local database, so it can fetch the settings it needs to escape the string correctly for that system.
您可以通过传入链接标识符作为第二个参数来告诉函数使用哪个连接:
You can tell the function which connection to use by passing in a link identifier as a second argument:
mysql_real_escape_string($string, $link)
这篇关于使用mysql_real_escape_string()时出错的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!