Database Abstraction Layer for PHP http://adodb.org/dokuwiki/ 2026-05-16T19:43:33+00:00 http://adodb.org/dokuwiki/ http://adodb.org/dokuwiki/lib/exe/fetch.php?media=logo.png text/html 2016-08-13T17:03:36+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:reference:recordset:absolutepage&rev=1471107816&do=diff absolutePage See Also pageExecute() cachePageExecute() Syntax int absolutePage( optional int $pageNo = -1 ) Description Used in conjunction with pageExecute, absolutePage() returns the current page number in a paged recordset. If the optional parameter is set to a value different from -1, it forces the current page number to be the value set. text/html 2022-06-25T09:25:01+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:reference:recordset:atfirstpage&rev=1656149101&do=diff atFirstPage Syntax bool atFirstPage( optional bool $status=false ) See Also * pageExecute() * cachePageExecute() * atLastPage() Description Used in conjunction with pageExecute, atFirstPage() returns true if at the first page set in a group. If the optional parameter is set true, it forces the current page to be the first text/html 2022-06-25T09:24:05+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:reference:recordset:atlastpage&rev=1656149045&do=diff atLastPage Syntax bool atLastPage( optional bool $status=false ) See Also * pageExecute() * cachePageExecute() * atFirstPage() Description Used in conjunction with pageExecute, atLastPage() returns true if at the last page set in a group. If the optional parameter is set true, it forces the current page to be the last. Any subsequent calls to last page will return this page. text/html 2021-05-05T01:42:28+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:reference:recordset:fetchfield&rev=1620178948&do=diff fetchField See Also fieldTypesArray() Syntax mixed fetchField() { optional integer $fieldNumber } Description fetchField() returns database specific information about nth column in a row of a recordset. Column offsets start at zero. If no field number is provided, the first column is returned. text/html 2025-06-01T11:21:22+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:reference:recordset:fetchnextobj&rev=1748776882&do=diff fetchNextObj obj fetchNextObj( optional bool $upperCaseKeys=false )obj fetchNextObject( optional bool $upperCaseKeys=true ) fetchNextObject Description The fetchNextObj() / fetchNextObject() functions return the current record from a recordset as an object or text/html 2025-06-01T11:21:22+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:reference:recordset:fetchobj&rev=1748776882&do=diff fetchObj obj fetchObj()obj fetchObject( optional bool $upperCaseKeys=true ) fetchObject Description The fetchObj() / fetchObject() functions return the current row of a RecordSet as an ADOFetchObj object. They can be considered as aliases, except for the fact that text/html 2025-06-01T11:21:23+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:reference:recordset:fetchrow&rev=1748776883&do=diff fetchRow Syntax mixed fetchRow() Description The function fetchRow() returns the current row of a recordset as an array or false if past end-of-file and advances the pointer of the result. If the end-of-file is reached, the EOF attribute is set text/html 2021-05-05T01:33:04+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:reference:recordset:fieldcount&rev=1620178384&do=diff fieldCount Syntax int fieldCount() Description The function fieldCount() returns the number of columns in a row of a recordset. Usage $SQL = "SELECT * FROM emp"; $recordSet = $conn->Execute($SQL); $cols = $recordSet->fieldCount(); for($i=0;$i<$cols;$i++){ $fld = $f->FetchField($i); print_r($fld); $t = $f->MetaType($fld->type); print_r($t); } text/html 2018-06-11T08:16:25+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:reference:recordset:fields&rev=1528704985&do=diff fields mixed fields( optional int $offset=1 ) Description The function fields() returns the value of the column at the specified offset. The offset is always an integer number, beginning at 1. If the offset is negative, or greater than the number of columns obtained through text/html 2021-05-05T01:31:57+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:reference:recordset:fieldtypesarray&rev=1620178317&do=diff fieldTypesArray See Also fetchField() fieldCount() Syntax mixed fieldTypesArray() Description The method returns an array of ADOFieldObjects representing all of the objects returned in a result set. It is the equivalent of looping from 1 to fieldCount , calling the fetchField method. The method returns text/html 2019-11-23T23:16:44+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:reference:recordset:getmenu&rev=1574551004&do=diff getMenu See Also getMenu2() getMenu3() Syntax string getMenu( string $selectName, optional mixed $defaultValue=false, optional mixed $blankFirstItem=true, optional bool $multiple=false, optional int $numberOfRows=0, optional string $optionalAttributes='', optional bool $compareAgainstFirstCol=true ) text/html 2019-11-23T23:12:05+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:reference:recordset:getmenu2&rev=1574550725&do=diff getMenu2 This method is deprecated and will be removed in a later release. Use getMenu() with $compareFirstCol = false instead. See Also getMenu() getMenu3() Syntax string getMenu2( optional string $selectName='', optional mixed $defaultValue=false, optional bool $blankFirstItem=true, optional bool $multiple=fale, optional int $numberOfRows=0, optional string $optionalAttributes='', ) text/html 2019-01-01T22:50:41+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:reference:recordset:getmenu3&rev=1546383041&do=diff getMenu3 This method requires that ADODB_FETCH_MODE be set to ADODB_FETCH_NUM prior to execution of the SQL statement that will provide the recordset. See Also getMenu() getMenu2() Syntax string getMenu3( optional string $selectName='', optional mixed $defaultValue=false, optional mixed $blankFirstItem=true, optional bool $multiple=false, optional int $numberOfRows=0, optional string $optionalAttributes='' ) text/html 2016-01-16T21:14:23+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:reference:recordset:index&rev=1452978863&do=diff Recordset Methods Reference Manual Pages in this namespace: * absolutePage * atFirstPage * atLastPage * fetchField * fetchNextObj * fetchObj * fetchRow * fieldCount * fields * fieldTypesArray * getMenu * getMenu2 * getMenu3 * maxRecordCount * move * moveFirst * moveLast * moveNext * nextRecordSet * numCols * numRows text/html 2016-01-17T01:42:40+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:reference:recordset:maxrecordcount&rev=1452994960&do=diff maxRecordCount Syntax int maxRecordCount() ---------- Description The method maxRecordCount() returns the maximum number of records that can be returned in a paged record set. Usage $p = $db->maxRecordCount(); text/html 2026-02-08T10:04:02+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:reference:recordset:move&rev=1770545042&do=diff move Syntax bool move( int $cursorPosition ) Description The function move() moves the cursor to the nth record in a recordset. Offsets are zero-based. If the cursor is successfully moved then the function returns true. If the move fails (negative offset, passed text/html 2020-01-02T15:50:20+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:reference:recordset:movefirst&rev=1577980220&do=diff moveFirst Syntax bool moveFirst() Description The function moveFirst() moves the cursor to the first record in a recordset. The only time that the function returns false is if the recordset is empty. ---------- Usage /* * Connection to DB2 sample database */ $sql = "SELECT * FROM act ORDER BY ACTNO ASC"; $recordset = $db->execute($sql); /* * Go to the 10th record */ $recordset->move(9); $record = $recordset->fetchObj(); print_r($record); $recordset->moveFirst(); $record = $recordse… text/html 2020-01-02T15:53:32+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:reference:recordset:movelast&rev=1577980412&do=diff moveLast Syntax bool moveLast() Description The function moveLast() moves the cursor to the last record in a recordset. The only time that the function returns false is if the recordset is empty. ---------- Usage /* * Connection to DB2 sample database */ $sql = "SELECT * FROM act"; $recordset = $db->execute($sql); $recordset->moveLast(); $record = $recordset->fetchObj(); print_r($record); /* * Prints ADOFetchObj Object ( [ACTNO] => 180 [ACTKWD] => DOC [ACTDESC] => DOCUME… text/html 2020-01-02T15:56:30+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:reference:recordset:movenext&rev=1577980590&do=diff moveNext Syntax bool moveNext() Description The function moveNext() moves the cursor to the next record in a recordset from the current position. If the cursor is successfully moved then the function returns true. If the move is passed EOF the function returns false. text/html 2016-01-17T03:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:reference:recordset:nextrecordset&rev=1453000196&do=diff nextRecordSet Do not confuse the recordset described here with ADOdb recordsets Syntax mixed nextRecordSet() Description In databases such as Microsoft SQL Server that can return record sets, i.e. a subset of the entire result set, this function returns the next set of records. Returning sets of records has benefits in terms of performance and memory management. text/html 2025-06-01T11:21:23+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:reference:recordset:numcols&rev=1748776883&do=diff numCols Syntax int numCols() Description The PEAR compatible method numCols returns the number of columns in a returned recordset. pear text/html 2025-06-01T11:21:24+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:reference:recordset:numrows&rev=1748776884&do=diff numRows Syntax int numRows() Description The PEAR compatible method numRows returns the number of rows in a returned recordset. pear