MYSQLI_STMT_FETCH(3) 1 MYSQLI_STMT_FETCH(3)
mysqli_stmt::fetch - Fetch results from a prepared statement into the bound variables
Object oriented style
SYNOPSIS
bool mysqli_stmt::fetch (void )
DESCRIPTION
Procedural style
bool mysqli_stmt_fetch (mysqli_stmt $stmt)
Fetch the result from a prepared statement into the variables bound by mysqli_stmt_bind_result(3).
Note
Note that all columns must be bound by the application before calling mysqli_stmt_fetch(3).
Note
Data are transferred unbuffered without calling mysqli_stmt_store_result(3) which can decrease performance (but reduces memory
cost).
PARAMETERS
o $
stmt -Procedural style only: A statement identifier returned by mysqli_stmt_init(3).
RETURN VALUES
Return Values
+------+---------------------------------------------------+
|Value | |
| | |
| | Description |
| | |
+------+---------------------------------------------------+
| | |
|TRUE | |
| | |
| | Success. Data has been fetched |
| | |
| | |
|FALSE | |
| | |
| | Error occurred |
| | |
| | |
|NULL | |
| | |
| | No more rows/data exists or data truncation |
| | occurred |
| | |
+------+---------------------------------------------------+
EXAMPLES
Example #1
Object oriented style
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
$query = "SELECT Name, CountryCode FROM City ORDER by ID DESC LIMIT 150,5";
if ($stmt = $mysqli->prepare($query)) {
/* execute statement */
$stmt->execute();
/* bind result variables */
$stmt->bind_result($name, $code);
/* fetch values */
while ($stmt->fetch()) {
printf ("%s (%s)
", $name, $code);
}
/* close statement */
$stmt->close();
}
/* close connection */
$mysqli->close();
?>
Example #2
Procedural style
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
$query = "SELECT Name, CountryCode FROM City ORDER by ID DESC LIMIT 150,5";
if ($stmt = mysqli_prepare($link, $query)) {
/* execute statement */
mysqli_stmt_execute($stmt);
/* bind result variables */
mysqli_stmt_bind_result($stmt, $name, $code);
/* fetch values */
while (mysqli_stmt_fetch($stmt)) {
printf ("%s (%s)
", $name, $code);
}
/* close statement */
mysqli_stmt_close($stmt);
}
/* close connection */
mysqli_close($link);
?>
The above examples will output:
Rockford (USA)
Tallahassee (USA)
Salinas (USA)
Santa Clarita (USA)
Springfield (USA)
SEE ALSO
mysqli_prepare(3), mysqli_stmt_errno(3), mysqli_stmt_error(3), mysqli_stmt_bind_result(3).
PHP Documentation Group MYSQLI_STMT_FETCH(3)