使用mysql_real_escape_string()时出错 [英] error while using mysql_real_escape_string()

问题描述

我的代码-

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()时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！