mysql_real_escape_string error

Question

I'm getting Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'username'@'localhost' (using password: NO)

Here's my code..

<?php
include 'config.php';
$email = mysql_real_escape_string($_GET['email']);

$validation = filter_var($email, FILTER_VALIDATE_EMAIL);
if ( $validation ) {
    // Make a MySQL Connection
    mysql_connect($Host,$Username,$Password) or die(mysql_error());
    mysql_select_db($Database) or die(mysql_error());

    // Insert rows
    mysql_query("INSERT INTO formusers
    (formemail) VALUES('$email') ") 
    or die(mysql_error()); 
}
?>

It does work if I move the lines to make a database connection up. Is it necessary to make a database connection before using mysql_real_escape_string or am I just doing it wrong?

Rene Pot · Accepted Answer · 2012-05-10 14:14:44Z

3

Yes, you do need an open mysql connection in order to do that.

I recommend you put the mysql_connect() on top of the script to make sure this error will never occur. (of course, it can still happen if you connect wrongly to the database)

answered May 10, 2012 at 14:14

Rene Pot

24.8k7 gold badges70 silver badges92 bronze badges

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

Comments

Andy · Accepted Answer · 2012-05-10 14:18:02Z

1

Yes it is required.

Note:

A MySQL connection is required before using mysql_real_escape_string() otherwise an error of level E_WARNING is generated, and FALSE is returned. If link_identifier isn't defined, the last MySQL connection is used.

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

answered May 10, 2012 at 14:18

Andy♦

50.8k62 gold badges181 silver badges240 bronze badges

Comments

blang · Accepted Answer · 2012-05-10 14:19:59Z

1

If you can't establish a mysql connection you can use:

mysql_escape_string

BUT: It's DEPRECATED as of PHP 5.3.0!

Always use mysql_real_escape_string if possible!

answered May 10, 2012 at 14:19

blang

2,1202 gold badges19 silver badges17 bronze badges

Collectives™ on Stack Overflow

mysql_real_escape_string error

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related