Main (PHP)

Home Forums PHP News PHP Tutorials Articles PHP Code Snippets Contact Us Sysadmin Resources Books Template Shop

3rd Party Streams

SlashDot PHPDeveloper.org PHP.Net

Resources

PHP Manual MySQL Manual Smarty Manual PEAR Manual PHP-GTK Manual Symfony Manual

Code Snippets

Authentication Database Graphics HTTP Miscellaneous Time/Date

Affiliates

Scripts TutorialMan TutorialGuide CodingForums.com PHP Scripts Cheap Web Hosting Affordable Web Hosting Dreamweaver Templates

DB_result::fetchInto()

PEAR Manual
Prev		Next

DB_result::fetchInto()

DB_result::fetchInto() -- Fetches a row of a result set into a variable

Synopsis

integer fetchInto (array &$arr [, integer $fetchMode = DB_FETCHMODE_DEFAULT [, integer $rowNum = NULL]])

Description

Places a row of data from a result set into a variable you provide then moves the result pointer to the next row. The data can be formatted as an array or an object.

Parameter

mixed $arr

reference to a variable to contain the row

integer $fetchMode

the fetch mode to use. The default is DB_FETCHMODE_DEFAULT, which tells this method to use DB's current fetch mode. DB's current default fetch mode can be changed using setFetchMode(). Potential values include:

DB_FETCHMODE_ORDERED
DB_FETCHMODE_ASSOC
DB_FETCHMODE_OBJECT

integer $rowNum

the row number to fetch

Return value

integer - DB_OK if a row is processed, NULL when the end of the result set is reached or a DB_Error object on failure

Note

This function can not be called statically.

Example

Example 26-1. Using fetchInto()

<?php
// Once you have a valid DB object named $db...
$res =& $db->query('SELECT * FROM mytable');
while ($res->fetchInto($row)) {
    // Assuming DB's default fetchmode is
    // DB_FETCHMODE_ORDERED
    echo $row[0] . "\n";
}
?>

See

"Intro - Results", setFetchMode(), fetchRow()

Prev	Home	Next
DB_result	Up	DB_result::fetchRow()

Print this page

Top Sponsor

$Symantec\'s Norton SystemWorks 2006$