PHP store_result() and mysqli_stmt_store_result()

This article is created to cover the two functions of PHP, that are:

• store_result()
• mysqli_stmt_store_result()

Both the functions are used to store result set, in an internal buffer. The only difference is, the store_result() is used with PHP MySQLi object-oriented script, whereas the mysqli_stmt_store_result() is used with PHP MySQLi procedural script.

PHP store_result()

The PHP store_result() is used to store result set in an internal buffer of the memory, in PHP MySQLi object-oriented style. For example:

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

The output produced by above PHP example on store_result() function, is shown in the snapshot given below:

Since, there are total 5 records available in the customer table, therefore we are seeing this output.

Note - The mysqli() 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/return the error code (if any) from last connect call, in object-oriented style.

Note - The prepare() 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() is used to execute a prepared statement on the MySQL database, in object-oriented style.

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

Note - The num_rows is used to get the number of rows available in the result set, in object-oriented style.

Note - The close() is used to close an opened connection, in object-oriented style.

PHP store_result() Syntax

The syntax of store_result() function in PHP, is:

$mysqli_stmt -> store_result()

PHP mysqli_stmt_store_result()

The PHP mysqli_stmt_store_result() is used to store result set in an internal buffer of the memory, in PHP MySQLi procedural style. For example:

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

Note - The mysqli_connect() is used to open a connection to the MySQL database server, in procedural style.

Note - The mysqli_connect_errno() is used to get/return the error code (if any) from last connect call, in procedural style.

Note - The mysqli_prepare() 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() is used to execute a prepared statement on the MySQL database, in procedural style.

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

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

PHP mysqli_stmt_store_result() Syntax

The syntax of mysqli_stmt_store_result() function in PHP, is:

mysqli_stmt_store_result($mysqli_stmt)

PHP Online Test