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

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