Call to undefined method DB::escape_string()

Question

Here is simplified version of my code:

$db = new mysqli('localhost', 'user', 'pass', 'database') or die(mysqli_error());    

$gender = $db->escape_string($_GET['gender']);
$city = $db->escape_string($_GET['city']);

Here is the error I get:

Call to undefined method DB::escape_string() in /blablabla/bla/file.php on line 2

Why am I getting an error?

If you use prepared statements, theres no need for real_escape_string — Nick
– Nick, Commented Feb 21, 2013 at 22:03
Yes, I am going to learn how to do prepared statements for this. It would be nice to know what is causing that error though. — TJE
– TJE, Commented Feb 21, 2013 at 22:31
Okay, I had another variable named $db deep inside my files. I feel stupid now. — TJE
– TJE, Commented Feb 21, 2013 at 23:07

gen_Eric · Accepted Answer · 2013-02-21 22:02:02Z

2

I think what you're looking for is mysqli::real_escape_string()

$gender = $db->real_escape_string($_GET['gender']);
$city = $db->real_escape_string($_GET['city']);

edited Feb 21, 2013 at 22:02

gen_Eric

228k42 gold badges304 silver badges343 bronze badges

answered Feb 21, 2013 at 21:58

John Conde

220k100 gold badges464 silver badges504 bronze badges

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

10 Comments

TJE Over a year ago

Already tried that... Call to undefined method DB::real_escape_string(). Aren't they the same thing anyways.

John Conde Over a year ago

Nope. MySQLi doesn't have a escape_string() method. Plus, in the mysql_* functions they work very differently.

Nick Over a year ago

@JohnConde actually i does... php.net/manual/en/mysqli.real-escape-string.php

John Conde Over a year ago

real_escape_string() != escape_string()

TJE Over a year ago

That still didn't fix the problem though. How is real_escape_string() undefined?

|

echo_Me · Accepted Answer · 2013-02-21 21:59:18Z

0

escape_string is an alias to real_escape_string, so they're identical.

here's a link for documentation:

http://php.net/manual/en/mysqli.real-escape-string.php

try this

 $city = $mysqli->real_escape_string($_GET['city']);

answered Feb 21, 2013 at 21:59

echo_Me

37.2k5 gold badges62 silver badges81 bronze badges

Collectives™ on Stack Overflow

Call to undefined method DB::escape_string()

2 Answers 2

10 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

10 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related