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