Re: mysql_real_escape_string() question

On Thu, 28 Sep 2006 11:06:45 -0400, tedd wrote:

Hi gang:

In one of my snip-its, namely:

http://xn--ovg.com/pdf

I was generating a pdf document after the user filled in a form. I
had been cleaning the user input by using --

$name = mysql_real_escape_string($name);

-- even though I wasn't using MySQL (the code was a cut-paste from
some other code I had).

However, everything worked!

But, a couple of days ago it suddenly stopped working. Now, I get the
following error:

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

When I comment-out the offending statement, it runs. I replaced the
statement, but wonder what happened -- when did using
mysql_real_escape_string() require a password?

What's up with that? Any ideas as to what happened?

tedd

Hi Tedd,

According to
http://nl3.php.net/mysql_real_escape_string

The function requires a MySQL connection. If there is none, it
will try and create one. That fails now. Possibly you could use addslashes()?

Regards,

Ivo
.

Relevant Pages

  • mysql_real_escape_string() question
    ... I was generating a pdf document after the user filled in a form. ... I had been cleaning the user input by using -- ... When I comment-out the offending statement, ...
    (php.general)
  • Re: [PHP] Re: mysql_real_escape_string() question
    ... The function requires a MySQL connection. ... That fails now. ... He's not actually *putting* it in a database, so isn't it useless to use a ... cleaning input... ...
    (php.general)