sqlite_fetch_array

Description

Object oriented style (method):

Fetches the next row from the given result handle. If there are no more rows, returns FALSE, otherwise returns an associative array representing the row data.

Parameters

Return Values

Returns an array of the next row from a result set; FALSE if the next position is beyond the final row.

The column names returned by SQLITE_ASSOC and SQLITE_BOTH will be case-folded according to the value of the sqlite.assoc_case configuration option.

Examples

Example 1. Procedural example <?php $dbhandle = sqlite_open('sqlitedb'); $query = sqlite_query($dbhandle, 'SELECT name, email FROM users LIMIT 25'); while ($entry = sqlite_fetch_array($query, SQLITE_ASSOC)) {     echo 'Name: ' . $entry['name'] . '  E-mail: ' . $entry['email']; } ?>

Example 2. Object-oriented example <?php $dbhandle = new SQLiteDatabase('sqlitedb'); $query = $dbhandle->query('SELECT name, email FROM users LIMIT 25'); // buffered result set $query = $dbhandle->unbufferedQuery('SELECT name, email FROM users LIMIT 25'); // unbuffered result set while ($entry = $query->fetch(SQLITE_ASSOC)) {     echo 'Name: ' . $entry['name'] . '  E-mail: ' . $entry['email']; } ?>

See Also