PHP mysqli: store_result() function

mysqli_store_result function / mysqli::store_result

The mysqli_store_result function / mysqli::store_result — transfers a result set from the last query.


Object oriented style

mysqli_result mysqli::store_result ([ int $option ] )

Procedural style

mysqli_result mysqli_store_result ( mysqli $link [, int $option ] )


Name Description Required/Optional
link A link identifier returned by mysqli_connect() or mysqli_init() Required for procedural style only and Optional for Object oriented style
option The option that you want to set. It can be one of the following values: Required for procedural style only and Optional for Object oriented style
  Valid options  
  Name Description
MYSQLI_STORE_RESULT_COPY_DATA Copy results from the internal mysqlnd buffer into the PHP variables fetched. By default, mysqlnd will use a reference logic to avoid copying and duplicating results held in memory. For certain result sets, for example, result sets with many small rows, the copy approach can reduce the overall memory usage because PHP variables holding results may be released earlier (available with mysqlnd only, since PHP 5.6.0)

Usage: Procedural style



Name Description Required/Optional
connection Specifies the MySQL connection to use Required

Return value:

Returns a buffered result object or FALSE if an error occurred..

Version: PHP 5, PHP 7


// Check connection
if (mysqli_connect_errno())
  echo "Failed to connect to MySQL: " . mysqli_connect_error();


// Create a prepared statement

if (mysqli_stmt_prepare($stmt,"SELECT District FROM city WHERE Name=?"))

  // Bind parameters

  // Execute query

  // Bind result variables

  // Fetch value

  printf("%s is in district %s",$city,$district);

  // Close statement


See also

PHP Function Reference

Previous: stmt_init
Next: thread_id

Follow us on Facebook and Twitter for latest update.