mysqli_num_rows(): Count Rows in a Result Set

<?php
$result = $connection->query('SELECT id FROM student');
echo 'Rows: ' . $result->num_rows;
?>

SQL concepts: SELECT

<?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)

MySQLI database connection file

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

MySQL SELECT Query

<?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 :35

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

Checking if matching record is available

$t="SELECT * FROM student WHERE mark > 90";

$check=$connection->query($t);
if(mysqli_num_rows($check)>0){
// record found 	
}else{
// No record found 	
}

MySQL DUMP of student table

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author   Watch on YouTube

Connect: