解决Php mysql中的布尔错误[重复]

Question

This question already has an answer here:

• mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in [duplicate] 1 answer

Im finding a way to resolve the boolean error it seems that I cannot fix the error, I dont know what does the error mean, I've asked for help but it seems like it doesn't work properly, Please help.

Php code:

$dbcon=mysqli_connect("localhost","root","","admin");

if(mysqli_connect_errno()){

echo "Error".mysqli_connect_error();
}

$username = mysqli_real_escape_string($dbcon,$_POST['username']); /* prevents a bit of SQL injection */
$password = mysqli_real_escape_string($dbcon,$_POST['password']); /* prevents a bit of SQL injection */
$username1 = mysqli_real_escape_string($dbcon,$_POST['username1']); /* prevents a bit of SQL injection */
$password1 = mysqli_real_escape_string($dbcon,$_POST['password1']); /* prevents a bit of SQL injection */



$qry=mysqli_query($dbcon,"SELECT * FROM admininfo WHERE username='$username' AND password='$password' AND type1='customer'");
$qryadmin=mysqli_query($dbcon,"SELECT * FROM customerinfo WHERE username1='$username1' AND password1='$password1' AND type='admin'");

if(mysqli_num_rows($qry)==1){
header("LOCATION:menu1.php");
}

else if(mysqli_num_rows($qryadmin)==1){
header("LOCATION:menu.php");
}

else {
echo "Error! No user found.";
}  

Error is:(between the if else statement, First error:if(mysqli_num_rows($qry)==1) Second error: else if(mysqli_num_rows($qryadmin)==1) Error description below )

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\addeditdelete1\loginExec.php on line 34

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\addeditdelete1\loginExec.php on line 38

</div>

Answer 1

Upon failure, mysqli_query returns false, so you should probably check if it is false or not before supplying it as a parameter to mysqli_num_rows().