mysqli_real_escape_string mysqli link?

Question

I get "Notice: Undefined variable: con in C:\wamp\www\Game\functions.php on line 8" when trying to use the function, here's the code.

function protect($string) {
return mysqli_real_escape_string($con,strip_tags(addslashes($string)));
}

I use the $con for my queries and it's fine so I thought that was what was for this mysqli part?

This is for registration, I have some registration that is working but I can't use that, here's a confirmed working line

$res=mysqli_query($con,$sql);

Any ideas?

mysqli_real_escape_string needs a connection BEFORE it can function,use global $con; as the first line in your function. — Mihai
– Mihai, Commented Sep 16, 2014 at 17:34
Post it as your own answer and accept it after a couple of days. — Mihai
– Mihai, Commented Sep 16, 2014 at 17:48

Jonan · Accepted Answer · 2014-09-16 17:35:51Z

2

$con doesn't exist in the function protect(), so you either need to make $con global:

global $con = mysqli_connect();

or you need to pass $con as an argument:

function protect($string, $con) {
    return mysqli_real_escape_string($con,strip_tags(addslashes($string)));
}

answered Sep 16, 2014 at 17:35

Jonan

2,5363 gold badges27 silver badges45 bronze badges

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

1 Comment

I have "$con=mysqli_connect("localhost","root","");" in a connect.php file with "Include('connect.php');" but still doesn't work :(

Ryan McKenna · Accepted Answer · 2014-09-16 17:49:56Z

2

ANSWER FROM MIHAI

mysqli_real_escape_string needs a connection BEFORE it can function,use global $con; as the first line in your function. – Mihai

answered Sep 16, 2014 at 17:49

Ryan McKenna

838 bronze badges