Javascript debugger
Website design
↑
sesam_fetch_array
Fetch one row as an associative array
()
array sesam_fetch_array ( string result_id [, int whence [, int offset]] )
sesam_fetch_array() is an alternative version of sesam_fetch_row(). Instead of storing the data in the numeric indices of the result array, it stores the data in associative indices, using the field names as keys.
sesam_fetch_array() fetches one row of data from the result associated with the specified result identifier. The row is returned as an associative array. Each result column is stored with an associative index equal to its column (aka. field) name. The column names are converted to lower case.
Columns without a field name (e.g., results of arithmetic operations) and empty fields are not stored in the array. Also, if two or more columns of the result have the same column names, the later column will take precedence. In this situation, either call sesam_fetch_row() or make an alias for the column.
SELECT TBL1.COL AS FOO, TBL2.COL AS BAR FROM TBL1, TBL2A special handling allows fetching "multiple field" columns (which would otherwise all have the same column names). For each column of a "multiple field", the index name is constructed by appending the string "(n)" where n is the sub-index of the multiple field column, ranging from 1 to its declared repetition factor. The indices are NOT zero based, in order to match the nomenclature used in the respective query syntax. For a column declared as:
CREATE TABLE ... ( ... MULTI(3) INT )
the associative indices used for the individual "multiple field"
columns would be "multi(1)",
"multi(2)", and "multi(3)"
respectively.
Subsequent calls to sesam_fetch_array() 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 284. 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 2214. SESAM fetch array
<?php
$result = sesam_query("SELECT * FROM phone\n" .
" WHERE LASTNAME='" . strtoupper($name) . "'\n".
" ORDER BY FIRSTNAME", 1);
if (!$result) {
/* ... error ... */
}
// print the table:
echo "<table border=\"1\">\n";
while (($row = sesam_fetch_array($result)) && count($row) > 0) {
echo "<tr>\n";
echo "<td>" . htmlspecialchars($row["firstname"]) . "</td>\n";
echo "<td>" . htmlspecialchars($row["lastname"]) . "</td>\n";
echo "<td>" . htmlspecialchars($row["phoneno"]) . "</td>\n";
echo "</tr>\n";
}
echo "</table>\n";
sesam_free_result($result);
?>
| sesam_fetch_row() |