PHP: db2_result - Manual

downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

db2_rollback db2_procedures

Last updated: Sat, 27 Jan 2007

view this page in

# db2_result

(PECL)

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

## Описание

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.

## Список параметров

`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.

## Возвращаемые значения

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.

## Примеры

Пример 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($stmt, 0);
$breed = db2_result($stmt, 'BREED');
print "$name $breed";
}
?>`

Результат выполнения данного примера:

    cat Pook
    gold fish Bubbles
    budgerigar Gizmo
    goat Rickety Ride

## Смотрите также

db2_fetch_array()
db2_fetch_assoc()
db2_fetch_both()
db2_fetch_object()
db2_fetch_row()

add a note User Contributed Notes
db2_result
There are no user contributed notes for this page.
db2_rollback db2_procedures

Last updated: Sat, 27 Jan 2007
show source | credits | stats | sitemap | contact | advertising | mirror sites
Copyright © 2001-2007 The PHP Group
All rights reserved.
This mirror generously provided by: Yahoo! Inc.
Last updated: Sat Mar 10 09:32:46 2007 PST