|
db2_fetch_bothReturns an array, indexed by both column name and position, representing a row in a result set Description
array db2_fetch_both
( resource
$stmt
[, int $row_number = -1
] )Returns an array, indexed by both column name and position, representing a row in a result set. Note that the row returned by db2_fetch_both requires more memory than the single-indexed arrays returned by db2_fetch_assoc or db2_fetch_array. Parameters
Return Values
Returns an associative array with column values indexed by both the column
name and 0-indexed column number. The array represents the next or
requested row in the result set. Returns Examples
Example #1 Iterating through a forward-only cursor If you call db2_fetch_both without a specific row number, it automatically retrieves the next row in the result set. The following example accesses columns in the returned array by both column name and by numeric index.
<?php The above example will output: 0 Pook cat 3.20 5 Rickety Ride goat 9.70 2 Smarty horse 350.00 Example #2 Retrieving specific rows with db2_fetch_both from a scrollable cursor If your result set uses a scrollable cursor, you can call db2_fetch_both with a specific row number. The following example retrieves every other row in the result set, starting with the second row.
<?php The above example will output: 0 Pook cat 3.20 5 Rickety Ride goat 9.70 2 Smarty horse 350.00 See Also
|