sesam_fetch_rowPodręcznik PHPPoprzedniNastępnysesam_fetch_row (PHP 3 CVS only)sesam_fetch_row -- Fetch one row as an arrayDescriptionarray sesam_fetch_row ( string result_id [, int whence [, int offset]])
Returns an array that corresponds to the fetched row, or
FALSE if there are no more rows.
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().
result_id is a valid result id returned by
sesam_query() (select type queries only!).
whence is an optional
parameter for a fetch operation on "scrollable" cursors, which
can be set to the following predefined constants:
Tabela 1. Valid values for "whence" parameterValueConstantMeaning0SESAM_SEEK_NEXT
read sequentially (after fetch, the internal default is set
to SESAM_SEEK_NEXT)
1SESAM_SEEK_PRIOR
read sequentially backwards (after fetch, the internal
default is set to SESAM_SEEK_PRIOR)
2SESAM_SEEK_FIRST
rewind to first row (after fetch, the default is set to
SESAM_SEEK_NEXT)
3SESAM_SEEK_LAST
seek to last row (after fetch, the default is set to
SESAM_SEEK_PRIOR)
4SESAM_SEEK_ABSOLUTE
seek 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)
5SESAM_SEEK_RELATIVE
seek 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 is an optional
parameter which is only evaluated (and required) if
whence is either
SESAM_SEEK_RELATIVE or
SESAM_SEEK_ABSOLUTE. This parameter is only
valid for "scrollable" cursors.
sesam_fetch_row() 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 php 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.
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.
Przykład 1. 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
print "<TABLE BORDER>\n";
$row = sesam_fetch_row ($result, SESAM_SEEK_LAST);
while (is_array ($row)) {
print " <TR>\n";
for ($col = 0; $col < $row["count"]; ++$col) {
print " <TD>".htmlspecialchars ($row[$col])."</TD>\n";
}
print " </TR>\n";
// use implied SESAM_SEEK_PRIOR
$row = sesam_fetch_row ($result);
}
print "</TABLE>\n";
sesam_free_result ($result);
?>
See also: sesam_fetch_array() which returns an
associative array, and sesam_fetch_result()
which returns many rows per invocation.
PoprzedniSpis treściNastępnysesam_fetch_resultPoczątek rozdziałusesam_field_array
Wyszukiwarka
Podobne podstrony:
function sybase fetch rowfunction mysql fetch rowfunction pg fetch rowfunction sesam fetch arrayfunction pg fetch rowfunction sybase fetch rowfunction msql fetch rowfunction odbc fetch rowfunction mssql fetch rowfunction ibase fetch rowfunction ovrimos fetch rowwięcej podobnych podstron