Re: problem with mysql_real_escape_string()
| From: | Chris | Date: | Thu, 28 Dec 2006 14:45:06 +0000 |
| Subject: | Re: problem with mysql_real_escape_string() | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-246258@lists.php.net to get a copy of this message | ||
You need to have established a database connection before using that
function, see manual.
<afan@afan.net> wrote in message
news:4453.69.66.68.21.1167315072.squirrel@afan.net...
> Hi to all!
>
> I moved my website from one php4/mysql4 based server to new hosting
> company and php5/mysq5 based server.
> Everything worked fine on old server, though now, on one page after I
> submit new record, I'll get this error:
>
> Warning: mysql_real_escape_string() [function.mysql-real-escape-string
>
> <https://www.mydomain.com/function.mysql-real-escape-string>
> ]: Access denied for user 'daemon'@'localhost' (using password: NO) in
> /srv/www/mydomain/add_record.php on line 30
>
> Warning: mysql_real_escape_string() [function.mysql-real-escape-string
>
> <https://www.mydomain.com/function.mysql-real-escape-string>
> ]: A link to the server could not be established in
> /srv/www/mydomain.com/add_record.php on line 30
>
> and this is a code:
>
> 26 if(isset($_POST['SubmitNewRecord']))
> 27 {
> 28 foreach($_POST as $key => $value)
> 29 {
> 30 ${$key} = mysql_real_escape_string($value);
> 31 }
> 32 }
>
> Never got such a error message before.
>
> Any thoughts?
>
> Thanks.
>
> -afan