warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given

The solution for “warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given” can be found here. The following code will assist you in solving the problem.

// warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in,
//this error will get mostly when query not giving any return value or having some error in query
$con=mysqli_connect(“localhost”,”root”,””,”employeeDB”);
$sql=”select * from employee where id = 1″;

if ($result=mysqli_query($con,$sql)){
// this will return the number of rows in result set
$numRos=mysqli_num_rows($result);
if($numRos > 0){
$data = mysqli_fetch_array($result);
print_r($data);
}else{
print “No data found”;
}
}

mysqli_close($con);// set a veariable to get your query like
$query = mysqli_query($connection-name,$sql-statment-name);

//then use an if statement to get the rows something like this
if($query){
$result = mysqli_num_rows($query);
if($result > 0){
// write a code for what you want to happen if the data exists in the databse
}else{
// write a code for what you want to happen if the data dosen’t exist
//in the databse
}
}
else{
return “query failed”;
}
//and thats all $query = mysqli_query($connection-name,$sql-statment-name);

//then use an if statement to get the rows something like this
if($query){
$result = mysqli_num_rows($query);
if($result > 0){
// write a code for what you want to happen if the data exists in the databse
}else{
// write a code for what you want to happen if the data dosen’t exist
//in the databse
}
}
else{
return “query failed”;
}
//and thats all

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

0
inline scripts encapsulated in