problem with mysql_real_escape_string()
| From: | afan at afan dot net | Date: | Thu, 28 Dec 2006 14:11:12 +0000 |
| Subject: | problem with mysql_real_escape_string() | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-246257@lists.php.net to get a copy of this message | ||
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