Search
 
SCRIPT & CODE EXAMPLE
 

PHP

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

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

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

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

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

$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 
Comment

PREVIOUS NEXT
Code Example
Php :: woocommerce get user id by email 
Php :: Allowed memory size of 1610612736 bytes exhausted (tried to allocate 67108872 bytes) in phar:///usr/local/bin/composer1.phar/src/Composer/DependencyResolver/RuleSet.php on line 8 
Php :: laravel migration add date of birth column 
Php :: php timestamp format 
Php :: overwrite file php 
Php :: laravel auth ui command 
Php :: floor ceil php 
Php :: upload file laravel 
Php :: Laravel Validation check array size min and max 
Php :: laravel validation allow empty array 
Php :: How to insert time in table using CodeIgniter 
Php :: Install the php_mysql extensions 
Php :: laravel return data from model to another controller 
Php :: laravel migration change default value 
Php :: phpunit repeat 
Php :: get categories wordpress query 
Php :: print url in view yii2 
Php :: how to install multiple php versions ubuntu 
Php :: sha256 in php 
Php :: General error: 1709 Index column size too large. The maximum column size is 767 bytes. 
Php :: php object foreach 
Php :: $_GET["name"] 
Php :: install phpUnit in php by composer 
Php :: php instance class from string 
Php :: where_in codeigniter 
Php :: get first day of current month php 
Php :: php array size 
Php :: assign php array into javascript 
Php :: convert date php 
Php :: php ternary operator 
ADD CONTENT
Topic
Content
Source link
Name
3+4 =