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
PHP: Tips of the Day
var_export(): var_export() dumps a PHP parseable representation of the item.
You can pass true as the second parameter to return the contents into a variable.
Example:
<?php $myarray = [ "PHP", "Tips" ]; $mystring = "PHP Tips"; $myint = 28; var_export($myarray); var_export($mystring); var_export($myint); ?>
Output:
array ( 0 => 'PHP', 1 => 'Tips', )'PHP Tips'28
To put the content into a variable, you can do this:
$array_export = var_export($myarray, true); $string_export = var_export($mystring, true); $int_export = var_export($myint, 1); // any `Truthy` value
After that, you can output it like this:
printf('$myarray = %s; %s', $array_export, PHP_EOL); printf('$mystring = %s; %s', $string_export, PHP_EOL); printf('$myint = %s; %s', $int_export, PHP_EOL);
Example:
<?php $myarray = [ "PHP", "Tips" ]; $mystring = "PHP Tips"; $myint = 28; $array_export = var_export($myarray, true); $string_export = var_export($mystring, true); $int_export = var_export($myint, 1); printf('$myarray = %s; %s', $array_export, PHP_EOL); printf('$mystring = %s; %s', $string_export, PHP_EOL); printf('$myint = %s; %s', $int_export, PHP_EOL); ?>
This will produce the following output:
Output:
$myarray = array ( 0 => 'PHP', 1 => 'Tips', ); $mystring = 'PHP Tips'; $myint = 28;
- New Content published on w3resource:
- HTML-CSS Practical: Exercises, Practice, Solution
- Java Regular Expression: Exercises, Practice, Solution
- Scala Programming Exercises, Practice, Solution
- Python Itertools exercises
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework
- Angular - JavaScript Framework
- Vue - JavaScript Framework
- Jest - JavaScript Testing Framework