error in php when connecting to database

Question

I am trying to run this code to create a simple login form and connect to database my code is

<?php
$avaialableuser=$_POST["username"];
$avaialablepass=$_POST["password"];
$login = mysql_connect("localhost","ahmed","");
if (!$login)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("login module",$login);
$result= mysql_query("SELECT * FROM people"); 
while($row = mysql_fetch_array($result))
  {
  if(($row['username']==$avaialableuser) && ($row['password']==$avaialablepass)){
echo "WELCOME";
}

else
echo "sorry your username or password entered is incorrect please try again";
}
mysql_close($login);
?>
>

I keep on getting this error [9:03:25 PM] ahmed atwa: Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\example\login.php on line 11

can anyone please tell me what am I doing wrong?? Thank you

your query is failing for some reason, which means that $result is not a resource. good practice would be to check if your mysql_query was successful or not. — Julien, Nov 28 '11 at 19:18
u can use this code... $result= mysql_query("SELECT * FROM people") or die(mysql_error()); — misima, Nov 28 '11 at 19:20

score 1 · Answer 1 · answered Nov 28 '11 at 19:19

1

Your connection to the MySQL server was unsuccessful. Since you checked the value of $login, we can assume the the mysql_select_db() statement failed or the query did not work. Please check your database name and try again.

To avoid such problems in the future, check the return value of mysql_select_db() and mysql_query().

answered Nov 28 '11 at 19:19

George Cummins

27,682
8
67
90

Or the query failed for some other reason (i.e. the table doesn't exist) – nickb Nov 28 '11 at 19:21
@nickb: Yes, that is possible, and I updated my answer to reflect it. However, the database name ("login module") is likely the problem in this case. – George Cummins Nov 28 '11 at 19:23

Marcus · Answer 2 · 2011-11-28T19:31:45.950

According to the manual will mysql_query return false if the query fails for some reason.

The two most common reasons are:

The query itself is incorrect
You don't have permission to perform the query.

To narrow it down you should introduce error-checking wherever possible and abort if needed. In your example you have two possible situations were the error can emerge:

mysql_select_db("login module",$login);
$result= mysql_query("SELECT * FROM people");

Both of these two situations return false if failed.

Edit:
In this case the problem is that you're using a space in your database name. To make it work you have to enclose the name using brackets []:

mysql_select_db("[login module]",$login);

score 1 · Answer 3 · answered Nov 28 '11 at 19:34

1

I don't know if this is true, but I think, you mustn't use Spaces in DB-Names: Couldn't your DB-Name be "login_module"?

mysql_select_db("login module",$login);

€dit: You have to cover your DB-Name in [ brackets ]:

mysql_select_db("[login module]",$login);

answered Nov 28 '11 at 19:34

ninov

629
1
6
17

You can use spaces in the name, but you have to enclose them. See my answer. – Marcus Nov 28 '11 at 19:34
Oh, thats right :) thanks ... – ninov Nov 28 '11 at 19:35

error in php when connecting to database

3 Answers3