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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
