Deprecated: mysql_escape_string()

[Sigoles]

mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead.

help?

<?PHP
$idas = mysql_escape_string($_GET['idas']);

 

[Raggaer]

mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead.

However if you use PHP 7 both of these wont work as mysql driver is ded

 

[Sigoles]

mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead.

However if you use PHP 7 both of these wont work as mysql driver is ded

php 5, how fix it? I tested use mysql real escape

 

[Raggaer]

php 5, how fix it? I tested use mysql real escape

Did real not work? what was the error

 

[Sigoles]

Did real not work? what was the error

Deprecated: mysql_real_escape_string(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead

Warning: mysql_real_escape_string(): Access denied for user ''@'localhost' (using password: NO)

Warning: mysql_real_escape_string(): A link to the server could not be established

 

[Raggaer]

Your database connection is wrong

 

[Sigoles]

Your database connection is wrong

not wrong, wtf ^^
any other idea?

 

[LordVissie]

Why not use mysqli? PHP mysqli_real_escape_string() Function

 

[Sigoles]

Why not use mysqli? PHP mysqli_real_escape_string() Function

Warning: mysqli_real_escape_string() expects exactly 2 parameters

this need 2 parameters to work and I'm using only one:

<?PHP
$idas = mysql_escape_string($_GET['idas']);

 

[Raggaer]

Okey so mysql_real_escape_string expects your mysql connection as the second parammetter, try doing that

However it loads the last connection open if its null so it should work. Are you sure your database connection is ok?

 

[Sigoles]

Okey so mysql_real_escape_string expects your mysql connection as the second parammetter, try doing that

However it loads the last connection open if its null so it should work. Are you sure your database connection is ok?

How I can do it? connection in second parammetter

db connection is ok

 

[LordVissie]

The link I posted shows exactly what you need.

 

[Sigoles]

The link I posted shows exactly what you need.

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) in /var/www/html/pages/bans.php on line 9
Failed to connect to MySQL: Access denied for user 'root'@'localhost' (using password: YES)
Deprecated: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in /var/www/html/pages/bans.php on line 17

 

[LordVissie]

Your database connection is wrong as raggaer said and you are still using the old function.

 

[Sigoles]

Your database connection is wrong as raggaer said and you are still using the old function.

my db is correctly 100%, I was using old/new versions mentioned above.. complicated

 

[LordVissie]

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) in /var/www/html/pages/bans.php on line 9
Failed to connect to MySQL: Access denied for user 'root'@'localhost' (using password: YES)

This says it isnt correct.

 

[messenoire]

First of all, create a user for your server in your database. Don't just use root.
1. open MySQL CLI
2. create user 'forgottenserver'@'localhost' identified by 'passw0rd';
3. grant all privileges on forgottenserver.* to 'forgottenserver'@'localhost';
4. flush privileges;

Then try again but using the user you just created.
Typed from head so look up if the syntax checks out.

Second, use PDO.

 

[Sigoles]

First of all, create a user for your server in your database. Don't just use root.
1. open MySQL CLI
2. create user 'forgottenserver'@'localhost' identified by 'passw0rd';
3. grant all privileges on forgottenserver.* to 'forgottenserver'@'localhost';
4. flush privileges;

Then try again but using the user you just created.
Typed from head so look up if the syntax checks out.

Second, use PDO.

This has already been solved, but thank you