<?Php
require "config.php";// Database connection file.
$query="select * from student ";
if ($result_set = $connection->query($query)) {
echo "Total No. of records :".$result_set->num_rows;
$result_set->close();
}?>
Total No. of records :35
$result_set->num_rows;
mysqli_num_rows($result_set)
The input parameter $result_set is the output of result set identifier of mysqli_query(), mysqli_store_result() or mysqli_use_result().
MySQLI database connection file
Example : Object Oriented Style<?Php
require "config.php";// Database connection file.
$query="select * from student ";
if ($result_set = $connection->query($query)) {
echo "Total No. of records :".$result_set->num_rows;
$result_set->close();
}?>
Total No. of records :35Procedural style
<?Php require "config.php";// Database connection file. $query="select * from student "; if ($result_set = mysqli_query($connection,$query)) { echo "Total No. of records :".mysqli_num_rows($result_set); mysqli_free_result($result_set); } ?>
Total No. of records :35With bind_param & using variables
$class='Three';
$query="select * from student WHERE class=? ";
$stmt=$connection->prepare($query);
$stmt->bind_param('s', $class);
$stmt->execute();
$stmt->store_result();
echo "Total No. of records :".$stmt->num_rows;
$t="SELECT * FROM istudent where mark >90";
$check=$connection->query($t);
if(mysqli_num_rows($check)>0){
// record found
}else{
// No record found
}
MYSQLI Functionsmysqli_fetch_array()