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