PHP 5.4.36 Released

db2_result

(PECL ibm_db2 >= 1.0.0)

db2_result Returns a single column from a row in the result set

Beschreibung

mixed db2_result ( resource $stmt , mixed $column )

Use db2_result() to return the value of a specified column in the current row of a result set. You must call db2_fetch_row() before calling db2_result() to set the location of the result set pointer.

Parameter-Liste

stmt

A valid stmt resource.

column

Either an integer mapping to the 0-indexed field in the result set, or a string matching the name of the column.

R├╝ckgabewerte

Returns the value of the requested field if the field exists in the result set. Returns NULL if the field does not exist, and issues a warning.

Beispiele

Beispiel #1 A db2_result() example

The following example demonstrates how to iterate through a result set with db2_fetch_row() and retrieve columns from the result set with db2_result().

<?php
$sql 
'SELECT name, breed FROM animals WHERE weight < ?';
$stmt db2_prepare($conn$sql);
db2_execute($stmt, array(10));
while (
db2_fetch_row($stmt)) {
    
$name db2_result($stmt0);
    
$breed db2_result($stmt'BREED');
    print 
"$name $breed";
}
?>

Das oben gezeigte Beispiel erzeugt folgende Ausgabe:

cat Pook
gold fish Bubbles
budgerigar Gizmo
goat Rickety Ride

Siehe auch

  • db2_fetch_array() - Returns an array, indexed by column position, representing a row in a result set
  • db2_fetch_assoc() - Returns an array, indexed by column name, representing a row in a result set
  • db2_fetch_both() - Returns an array, indexed by both column name and position, representing a row in a result set
  • db2_fetch_object() - Returns an object with properties representing columns in the fetched row
  • db2_fetch_row() - Sets the result set pointer to the next row or requested row

add a note add a note

User Contributed Notes 1 note

up
1
jay+nospam at toxicedge dot com
14 days ago
It's worth noting that this function consumes the value (the first call will return a result, and any subsequent calls will return NULL).
To Top