Breaking News: Grepper is joining You.com. Read the official announcement!

mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given

Add Answer

Amused Alligator answered on March 1, 2022 Popularity 9/10 Helpfulness 3/10

answer mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given

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

related mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given

mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given

Comment

// 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

Popularity 9/10 Helpfulness 3/10 Language php

Source: Grepper

Tags: boolean php

Link to this answer
Share Copy Link

Contributed on Mar 01 2022

Amused Alligator

0 Answers Avg Quality 2/10

Closely Related Answers

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

Comment

// 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);

Popularity 10/10 Helpfulness 6/10 Language php

Source: Grepper

Tags: php

Link to this answer
Share Copy Link

Contributed on May 05 2022

@CodeGrepperManu

0 Answers Avg Quality 2/10

mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given

Comment

$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

Popularity 9/10 Helpfulness 2/10 Language typescript

Source: Grepper

Tags: typescript t

Link to this answer
Share Copy Link

Contributed on May 02 2022

Test Demo

0 Answers Avg Quality 2/10

mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given

Contents

More Related Answers

mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given

Closely Related Answers

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

mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.