mySql real escape string returning blank

Question

I have a php program that uses cookies to store data across pages and redirects. I want to use mysql_real_escape_string() before sending them to my server, so far my code looks like this

$master_string = $_COOKIE["master_string"];
$order_name = mysqli_real_escape_string($_COOKIE["name"]);
$order_mail = $_COOKIE["mail"];

echo $order_name;

I have already checked that my sqli connection has been made, the resulting data inserted to my table is blank and so is the echo.

Rejaul · Accepted Answer · 2015-11-03 04:07:03Z

1

You have missed the connection parameter in mysqli_real_escape_string($_COOKIE["name"]);

Correct syntax: mysqli_real_escape_string($connection, $_COOKIE["name"]);

answered Nov 3, 2015 at 4:07

Rejaul

9802 gold badges16 silver badges43 bronze badges

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

4 Comments

trecoolable Over a year ago

I've tried that, yet it is only returning a string without escaping any slashes or \n from it

Rejaul Over a year ago

Please, store this returned data to database table and you will see the changes. mysqli_real_escape_string does not remove the special characters instead converts to htmlentities. When you echo htmlentities, it will display the character.

trecoolable Over a year ago

I did use the correct syntax and inserted the variable into my database and was still coming up with //'s

trecoolable Over a year ago

$master_string = mysqli_real_escape_string($conn,$_COOKIE["master_string"]); I feel as though it may be the fact that I am using cookies

Siddhartha esunuri · Accepted Answer · 2015-11-03 04:35:52Z

0

First Check cookies working or not than

You need enable Mysqli_connect

$connection = mysqli_connect;
$order_name  = mysqli_real_escape_string($connection , trim($_COOKIE['name']));

answered Nov 3, 2015 at 4:35

Siddhartha esunuri

1,1542 gold badges17 silver badges29 bronze badges

Collectives™ on Stack Overflow

mySql real escape string returning blank

2 Answers 2

4 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Related