note 94049 added to function.mysql-real-escape-string
| From: | ben_johnson1991athotmaildotcodotuk at osu1 dot php dot net | Date: | Tue, 13 Oct 2009 21:25:30 +0000 |
| Subject: | note 94049 added to function.mysql-real-escape-string | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-161704@lists.php.net to get a copy of this message | ||
Hey, I'm reasonbly new to using this function.
I have scripted it as so
// Connect to database
include_once "scripts/connect_to_mysql.php";
$emailCHecker = mysql_real_escape_string($email1);
$emailCHecker = eregi_replace("`", "", $emailCHecker);
// Database duplicate e-mail check setup for use below in the error handling if else
conditionals
$sql_email_check = mysql_query("SELECT email FROM myMembers WHERE
email='$emailCHecker'");
$email_check = mysql_num_rows($sql_email_check);
however, when i run this form the following error messages appear in the browser.
Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user
'bensbox'@'lotus.x10hosting.com' (using password: NO) in
/home/bensbox/public_html/socialnetwork_root_directory/register.php on line 72
Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could
not be established in /home/bensbox/public_html/socialnetwork_root_directory/register.php on line 72
Warning: mysql_query() [function.mysql-query]: Access denied for user
'bensbox'@'lotus.x10hosting.com' (using password: NO) in
/home/bensbox/public_html/socialnetwork_root_directory/register.php on line 75
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in
/home/bensbox/public_html/socialnetwork_root_directory/register.php on line 75
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in
/home/bensbox/public_html/socialnetwork_root_directory/register.php on line 76
I thought it would simply because me connect_to_mysql.php was incorrect, but that is not the case.
I have about 20 of this same error.
could anyone help?
Cheers :)
----
Server IP: 208.69.120.35
Probable Submitter: 86.159.24.242
----
Manual Page -- http://www.php.net/manual/en/function.mysql-real-escape-string.php
Edit -- https://master.php.net/note/edit/94049
Del: integrated -- https://master.php.net/note/delete/94049/integrated
Del: useless -- https://master.php.net/note/delete/94049/useless
Del: bad code -- https://master.php.net/note/delete/94049/bad+code
Del: spam -- https://master.php.net/note/delete/94049/spam
Del: non-english -- https://master.php.net/note/delete/94049/non-english
Del: in docs -- https://master.php.net/note/delete/94049/in+docs
Del: other reasons-- https://master.php.net/note/delete/94049
Reject -- https://master.php.net/note/reject/94049
Search -- https://master.php.net/manage/user-notes.php