PHP num_rows and mysqli_stmt_num_rows()

This article is created to cover the two topics of PHP, namely:

• num_rows
• mysqli_stmt_num_rows()

Both are used to get the number of rows available in the result set. The only difference is that num_rows is used with PHP mysqli object-oriented script, whereas mysqli_stmt_num_rows() is used with PHP mysqli procedural script.

PHP num_rows

The PHP num_rows returns the number of rows from the result set in PHP mysqli object-oriented style. For example:

<?php
   $conn = new mysqli("localhost", "root", "", "codescracker");
   
   if(!$conn->connect_errno)
   {
      $stmt = $conn->prepare("SELECT * FROM customer");
      $stmt->execute();
      $stmt->store_result();
      echo "Total Number of Rows = ", $stmt->num_rows;
   }
   $conn->close();
?>

The output produced by the above PHP example on num_rows is shown in the snapshot given below:

Note: The mysqli() function is used to open a connection to the MySQL database server in object-oriented style.

Note: The new keyword is used to create a new object.

Note: The connect_errno is used to get or return the error code (if any) from the last connect call in object-oriented style.

Note: The prepare() function is used to prepare an SQL statement before its execution on the MySQL database in object-oriented style, to avoid SQL injection.

Note: The execute() function is used to execute a prepared statement on the MySQL database in object-oriented style.

Note: The store_result() function is used to store a result set in an internal buffer in object-oriented style.

Note: The close() function is used to close an opened connection to the MySQL database in object-oriented style.

PHP num_rows Syntax

The syntax of num_rows in PHP is:

$mysqli_result -> num_rows

PHP mysqli_stmt_num_rows()

The PHP mysqli_stmt_num_rows() returns the number of rows from the result set in PHP mysqli procedural style. For example:

<?php
   $conn = mysqli_connect("localhost", "root", "", "codescracker");
   
   if(!mysqli_connect_errno())
   {
      $stmt = mysqli_prepare($conn, "SELECT * FROM customer");
      mysqli_stmt_execute($stmt);
      mysqli_stmt_store_result($stmt);
      echo "Total Number of Rows = ", mysqli_stmt_num_rows($stmt);
   }
   mysqli_close($conn);
?>

Note: The mysqli_connect_errno() function is used to get or return the error code (if any) from the last connect call in procedural style.

Note: The mysqli_prepare() function is used to prepare an SQL statement before its execution on the MySQL database in procedural style, to avoid SQL injection.

Note: The mysqli_stmt_execute() function is used to execute a prepared statement on the MySQL database in procedural style.

Note: The mysqli_stmt_store_result() function is used to store a result set in an internal buffer in procedural style.

Note: The mysqli_stmt_num_rows() function is used to get the number of rows available in the result set in procedural style.

Note: The mysqli_close() function is used to close an opened connection to the MySQL database in procedural style.

PHP mysqli_stmt_num_rows() Syntax

The syntax of the mysqli_stmt_num_rows() function in PHP is:

mysqli_stmt_num_rows($mysqli_result)

PHP Online Test