|
|
 |
db2_fetch_assoc (no version information, might be only in CVS) db2_fetch_assoc --
Returns an array, indexed by column name, representing a row in a result set
説明array db2_fetch_assoc ( resource stmt [, int row_number] ) | 警告 | この関数は、
実験的なステータスにあります。これは、この関数の
動作、関数名、ここで書かれていること全てがPHPの将来のバージョンで予告
なく変更される可能性があることを意味します。注意を喚起するとともに自分
のリスクでこの関数を使用してください。 |
Returns an array, indexed by column name, representing a row in a result
set.
パラメータ
- stmt
A valid stmt resource containing a result set.
- row_number
Requests a specific 1-indexed row from the result set. Passing this
parameter results in a PHP warning if the result set uses a
forward-only cursor.
戻り値
Returns an associative array with column values indexed by the column name
representing the next or requested row in the result set. Returns FALSE if
there are no rows left in the result set, or if the row requested by
row_number does not exist in the result set.
例
例 1. Iterating through a forward-only cursor
If you call db2_fetch_assoc() without a specific row
number, it automatically retrieves the next row in the result set.
|
<?php
$sql = "SELECT id, name, breed, weight FROM animals ORDER BY breed";
$stmt = db2_prepare($conn, $sql);
$result = db2_execute($stmt, $sql);
while ($row = db2_fetch_assoc($result)) {
printf ("%-5d %-16s %-32s %10s\n",
$row['ID'], $row['NAME'], $row['BREED'], $row['WEIGHT']);
}
?>
|
上の例の出力は以下となります: 0 Pook cat 3.20
5 Rickety Ride goat 9.70
2 Smarty horse 350.00 |
|
例 2. Retrieving specific rows with db2_fetch_assoc()
from a scrollable cursor
If your result set uses a scrollable cursor, you can call
db2_fetch_assoc() with a specific row number. The
following example retrieves every other row in the result set, starting
with the second row.
|
<?php
$sql = "SELECT id, name, breed, weight FROM animals ORDER BY breed";
$result = db2_exec($stmt, $sql, array('cursor' => DB2_SCROLLABLE));
$i=2;
while ($row = db2_fetch_assoc($result, $i)) {
printf ("%-5d %-16s %-32s %10s\n",
$row['ID'], $row['NAME'], $row['BREED'], $row['WEIGHT']);
$i = $i + 2;
}
?>
|
上の例の出力は以下となります: 0 Pook cat 3.20
5 Rickety Ride goat 9.70
2 Smarty horse 350.00 |
|
There are no user contributed notes for this page.
| |