PHP mysqli: store_result() function

Last update on August 19 2022 21:51:15 (UTC/GMT +8 hours)

mysqli_store_result function / mysqli::store_result

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

Syntax:

Object oriented style

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

Procedural style

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

Parameter:

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

mysqli_stmt_init(connection);

Parameter:

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

Example:

<?php
$con=mysqli_connect("localhost","user1","datasoft123","hr");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$city="Paris";

// Create a prepared statement
$stmt=mysqli_stmt_init($con);

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

  // Bind parameters
  mysqli_stmt_bind_param($stmt,"s",$city);

  // Execute query
  mysqli_stmt_execute($stmt);

  // Bind result variables
  mysqli_stmt_bind_result($stmt,$district);

  // Fetch value
  mysqli_stmt_fetch($stmt);

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

  // Close statement
  mysqli_stmt_close($stmt);
  }

mysqli_close($con);
?>

See also

PHP Function Reference

Previous: stmt_init
Next: thread_id