PHP Dokumentation: Function maxdb-stmt-bind-result
12. Januar 2010 von werner
maxdb_stmt_bind_result
stmt->bind_result
(PECL maxdb >= 1.0)
maxdb_stmt_bind_result — stmt->bind_result — Binds variables to a prepared statement for result storage
Beschreibung
Procedural style:
Object oriented style (method):
maxdb_stmt_bind_result() is used to associate (bind) columns in the result set to variables. When maxdb_stmt_fetch() is called to fetch data, the MaxDB client/server protocol places the data for the bound columns into the specified variables var1, ....
Hinweis: Note that all columns must be bound prior to calling maxdb_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 maxdb_stmt_fetch() is called.
Rückgabewerte
Gibt bei Erfolg TRUE zurück. Im Fehlerfall wird FALSE zurückgegeben.
Beispiele
Beispiel #1 Object oriented style
<?php
$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");if (
maxdb_connect_errno()) {
printf("Connect failed: %s\n", maxdb_connect_error());
exit();
}/* prepare statement */
if ($stmt = $maxdb->prepare("SELECT zip, name FROM hotel.city ORDER BY name")) {
$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 */
$maxdb->close();?>Beispiel #2 Procedural style
<?php
$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");/* check connection */
if (!$link) {
printf("Connect failed: %s\n", maxdb_connect_error());
exit();
}/* prepare statement */
if ($stmt = maxdb_prepare($link, "SELECT zip, name FROM hotel.city ORDER BY name")) {
maxdb_stmt_execute($stmt);
/* bind variables to prepared statement */
maxdb_stmt_bind_result($stmt, $col1, $col2);
/* fetch values */
while (maxdb_stmt_fetch($stmt)) {
printf("%s %s\n", $col1, $col2);
}
/* close statement */
maxdb_stmt_close($stmt);
}/* close connection */
maxdb_close($link);
?>Das oben gezeigte Beispiel erzeugteine ähnliche Ausgabe wie:
12203 Albany60601 Chicago60615 Chicago45211 Cincinnati33575 Clearwater75243 Dallas32018 Daytona Beach33441 Deerfield Beach48226 Detroit90029 Hollywood92714 Irvine90804 Long Beach11788 Long Island90018 Los Angeles70112 New Orleans10019 New York10580 New York92262 Palm Springs97213 Portland60018 Rosemont95054 Santa Clara20903 Silver Spring20005 Washington20019 Washington20037 Washington
Siehe auch
- maxdb_stmt_bind_param() – Binds variables to a prepared statement as parameters
- maxdb_stmt_execute() – Executes a prepared Query
- maxdb_stmt_fetch() – Fetch results from a prepared statement into the bound variables
- maxdb_prepare() – Prepare a SQL statement for execution
- maxdb_stmt_prepare() – Prepare a SQL statement for execution
- maxdb_stmt_init() – Initializes a statement and returns an resource for use with maxdb_stmt_prepare
- maxdb_stmt_errno() – Returns the error code for the most recent statement call
- maxdb_stmt_error() – Returns a string description for last statement error
Loading ...