db2_fetch_assoc

$sql = "SELECT id, name, breed, weight FROM animals ORDER BY breed";
$stmt = db2_prepare($conn, $sql);
$result = db2_execute($stmt);
while ($row = db2_fetch_assoc($stmt)) {
    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.

$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

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

• db2_fetch_array() - Returns an array, indexed by column position, 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
• db2_result() - Returns a single column from a row in the result set

add a note

User Contributed Notes

There are no user contributed notes for this page.