PHP Dokumentation: Mysqli-stmt bind-result
12. Januar 2010 von werner
mysqli_stmt::bind_result
mysqli_stmt_bind_result
(PHP 5)
mysqli_stmt::bind_result — mysqli_stmt_bind_result — Binds variables to a prepared statement for result storage
Beschreibung
Object oriented style (method):
Procedural style:
Binds columns in the result set to variables.
When mysqli_stmt_fetch() is called to fetch data, the MySQL client/server protocol places the data for the bound columns into the specified variables var1, ....
Hinweis: Note that all columns must be bound after mysqli_stmt_execute() and prior to calling mysqli_stmt_fetch(). Depending on column types bound variables can silently change to the corresponding PHP type.
A column can be bound or rebound at any time, even after a result set has been partially retrieved. The new binding takes effect the next time mysqli_stmt_fetch() is called.
Parameter-Liste
- stmt
Nur bei prozeduralem Aufruf: ein vonmysqli_stmt_init() zurückgegebensStatementobjekt.
- var1
The variable to be bound.
Rückgabewerte
Gibt bei Erfolg TRUE zurück. Im Fehlerfall wird FALSE zurückgegeben.
Beispiele
Beispiel #1 Object oriented style
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");if (
mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}/* prepare statement */
if ($stmt = $mysqli->prepare("SELECT Code, Name FROM Country ORDER BY Name LIMIT 5")) {
$stmt->execute();
/* bind variables to prepared statement */
$stmt->bind_result($col1, $col2);
/* fetch values */
while ($stmt->fetch()) {
printf("%s %s\n", $col1, $col2);
}
/* close statement */
$stmt->close();
}
/* close connection */
$mysqli->close();?>Beispiel #2 Procedural style
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");/* check connection */
if (!$link) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}/* prepare statement */
if ($stmt = mysqli_prepare($link, "SELECT Code, Name FROM Country ORDER BY Name LIMIT 5")) {
mysqli_stmt_execute($stmt);
/* bind variables to prepared statement */
mysqli_stmt_bind_result($stmt, $col1, $col2);
/* fetch values */
while (mysqli_stmt_fetch($stmt)) {
printf("%s %s\n", $col1, $col2);
}
/* close statement */
mysqli_stmt_close($stmt);
}/* close connection */
mysqli_close($link);
?>Das oben gezeigte Beispiel erzeugt folgendeAusgabe:
AFG AfghanistanALB AlbaniaDZA AlgeriaASM American SamoaAND Andorra
Siehe auch
- mysqli_stmt_bind_param() – Binds variables to a prepared statement as parameters
- mysqli_stmt_execute() – Executes a prepared Query
- mysqli_stmt_fetch() – Fetch results from a prepared statement into the bound variables
- mysqli_prepare() – Prepare a SQL statement for execution
- mysqli_stmt_prepare() – Prepare a SQL statement for execution
- mysqli_stmt_init() – Initializes a statement and returns an object for use with mysqli_stmt_prepare
- mysqli_stmt_errno() – Returns the error code for the most recent statement call
- mysqli_stmt_error() – Returns a string description for last statement error
Loading ...