Javascript debugger
Website design
↑
sesam_fetch_row
Fetch one row as an array
()
array sesam_fetch_row ( string result_id [, int whence [, int offset]] )
Fetches one row of data from the result associated with the specified
result identifier. The row is returned as an array (indexed by values
between 0 and $array["count"]-1).
Fields may be empty, so you must check for the existence of a field by
using the isset() function. The type of the returned
fields depend on the respective SQL type declared for its column (see
SESAM overview for the conversions
applied). SESAM "multiple fields" are "inlined" and treated like a
sequence of columns.
The number of columns in the result set is returned in an associative array element $array["count"]. Because some of the result columns may be empty, the count() function can not be used on the result row returned by sesam_fetch_row().
Subsequent calls to sesam_fetch_row() would return the
next (or prior, or n'th next/prior, depending on the scroll attributes)
row in the result set, or FALSE if there are no more rows.
Parameters
- result_id
A valid result id returned by sesam_query().
- whence
whence is an optional parameter for a fetch operation on "scrollable" cursors, which can be set to the following predefined constants:
Table 286. Valid values for "whence" parameter
Value Constant Meaning 0 SESAM_SEEK_NEXTread sequentially (after fetch, the internal default is set to SESAM_SEEK_NEXT)1 SESAM_SEEK_PRIORread sequentially backwards (after fetch, the internal default is set to SESAM_SEEK_PRIOR)2 SESAM_SEEK_FIRSTrewind to first row (after fetch, the default is set to SESAM_SEEK_NEXT)3 SESAM_SEEK_LASTseek to last row (after fetch, the default is set to SESAM_SEEK_PRIOR)4 SESAM_SEEK_ABSOLUTEseek to absolute row number given as offset (Zero-based. After fetch, the internal default is set to SESAM_SEEK_ABSOLUTE, and the internal offset value is auto-incremented)5 SESAM_SEEK_RELATIVEseek relative to current scroll position, where offset can be a positive or negative offset value.
This parameter is only valid for "scrollable" cursors.When using "scrollable" cursors, the cursor can be freely positioned on the result set. If the whence parameter is omitted, the global default values for the scrolling type (initialized to:
SESAM_SEEK_NEXT, and settable by sesam_seek_row()) are used. If whence is supplied, its value replaces the global default.- offset
Only evaluated (and required) if whence is either
SESAM_SEEK_RELATIVEorSESAM_SEEK_ABSOLUTE. This parameter is only valid for "scrollable" cursors.
Return Values
Returns an array that corresponds to the fetched row, or
FALSE if there are no more rows.
Examples
Example 2215. SESAM fetch rows
<?php
$result = sesam_query("SELECT * FROM phone\n" .
" WHERE LASTNAME='" . strtoupper($name) . "'\n" .
" ORDER BY FIRSTNAME", 1);
if (!$result) {
/* ... error ... */
}
// print the table in backward order
echo "<table border=\"1\">\n";
$row = sesam_fetch_row($result, SESAM_SEEK_LAST);
while (is_array($row)) {
echo "<tr>\n";
for ($col = 0; $col < $row["count"]; ++$col) {
echo "<td>" . htmlspecialchars($row[$col]) . "</td>\n";
}
echo "</tr>\n";
// use implied SESAM_SEEK_PRIOR
$row = sesam_fetch_row($result);
}
echo "</table>\n";
sesam_free_result($result);
?>