Re: [PHP] problem with mysql_real_escape_string()
- From: afan@xxxxxxxx
- Date: Thu, 28 Dec 2006 16:01:28 +0100 (CET)
A little bit "lower" on php.net/manual I found explanation too.
I'm sorry for bothering - wasn't check whole page before posting. The
Warning was strange for me because never got it before
:)
Thanks for your help.
-afan
afan@xxxxxxxx wrote:.
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.
Check the archives - this was asked a few days ago. The
mysql_real_escape_string function requires a connection to the database
to be open. If one isn't open it will try to open one with the defaults.
All you need to do is make sure you connect to the mysql database before
using mysql_real_escape_string.
-Stut
- References:
- problem with mysql_real_escape_string()
- From: afan
- Re: [PHP] problem with mysql_real_escape_string()
- From: Stut
- problem with mysql_real_escape_string()
- Prev by Date: Re: [PHP] problem with mysql_real_escape_string()
- Next by Date: Reverse Engineering PHP into UML
- Previous by thread: Re: [PHP] problem with mysql_real_escape_string()
- Next by thread: Reverse Engineering PHP into UML
- Index(es):
Relevant Pages
|
