error while using mysql_real_escape_string()

Question

my code-

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')";

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

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

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

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

But data is getting saved in DB but null titile and artbody fields

You will need to escape $_POST['cat'] as well.

user254875486
– user254875486

2010-08-19 09:01:16 +00:00
Commented Aug 19, 2010 at 9:01 — user254875486
– user254875486, Commented Aug 19, 2010 at 9:01

Adam Hopkinson · Accepted Answer · 2010-08-19 08:49:53Z

6

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)

answered Aug 19, 2010 at 8:49

Adam Hopkinson

28.9k9 gold badges74 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Delan Azabani · Accepted Answer · 2010-08-19 08:49:09Z

3

Please check your MySQL username and password and make sure you're entering them properly in mysql_connect. According to the error you didn't run mysql_connect with a password, which may be causing these problems.

answered Aug 19, 2010 at 8:49

Delan Azabani

81.7k30 gold badges174 silver badges214 bronze badges

Comments

Richard Harrison · Accepted Answer · 2010-08-19 08:49:25Z

0

Check database.php connection strings, and the MySQL server is running as mysql_real_escape_string needs a valid open database connection to work.

answered Aug 19, 2010 at 8:49

Richard Harrison

19.5k4 gold badges43 silver badges67 bronze badges

Collectives™ on Stack Overflow

error while using mysql_real_escape_string()

3 Answers 3

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Linked

Related