PHP: sesam_fetch_row - Manual

downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

sesam_field_array sesam_fetch_result

Last updated: Sat, 27 Jan 2007

view this page in

# sesam_fetch_row

(PHP 3 CVS only)

sesam_fetch_row -- Fetch one row as an array

## Description

array 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:

Таблица 1. Valid values for `"whence"` parameter

Value | Constant | Meaning
--- | --- | ---
0 | `SESAM_SEEK_NEXT` | read sequentially (after fetch, the internal default is set to `SESAM_SEEK_NEXT`)
1 | `SESAM_SEEK_PRIOR` | read sequentially backwards (after fetch, the internal default is set to `SESAM_SEEK_PRIOR`)
2 | `SESAM_SEEK_FIRST` | rewind to first row (after fetch, the default is set to `SESAM_SEEK_NEXT`)
3 | `SESAM_SEEK_LAST` | seek to last row (after fetch, the default is set to `SESAM_SEEK_PRIOR`)
4 | `SESAM_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)
5 | `SESAM_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 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.

Пример 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
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);
?>`

See also: sesam_fetch_array() which returns an associative array, and sesam_fetch_result() which returns many rows per invocation.

add a note User Contributed Notes
sesam_fetch_row
There are no user contributed notes for this page.
sesam_field_array sesam_fetch_result

Last updated: Sat, 27 Jan 2007
show source | credits | stats | sitemap | contact | advertising | mirror sites
Copyright © 2001-2007 The PHP Group
All rights reserved.
This mirror generously provided by: Yahoo! Inc.
Last updated: Sat Mar 10 10:36:09 2007 PST