sqlite_fetch_all

Fetches all rows from a result set as an array of arrays (PHP 5, PECL sqlite:1.0-1.0.3)
array sqlite_fetch_all ( resource result [, int result_type [, bool decode_binary]] )

Example 2329. Procedural example

<?php

$dbhandle = sqlite_open('sqlitedb');
$query = sqlite_query($dbhandle, 'SELECT name, email FROM users LIMIT 25');
$result = sqlite_fetch_all($query, SQLITE_ASSOC);

foreach ($result as $entry) {

    echo 'Name: ' . $entry['name'] . '  E-mail: ' . $entry['email'];

}
?>

Example 2330. Object-oriented example

copy to clipboard

<?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

$result = $query->fetchAll(SQLITE_ASSOC);

foreach ($result as $entry) {

    echo 'Name: ' . $entry['name'] . '  E-mail: ' . $entry['email'];

}
?>

Code Examples / Notes » sqlite_fetch_all

minots estichÃ¡

The usage of sqlite_fetch_all should be your choise (instead the well known practice of "while()" loop) when unmodified tabledata is prefered. Example code for a better illustration: <?php if ($dbhandle = sqlite_open('mysqlitedb', 0666, $sqliteerror)): $query = "SELECT x, y FROM sometable LIMIT 3;"; $result = sqlite_query($dbhandle, $query); // usage with sqlite_fetch_all $array1 = sqlite_fetch_all($result, SQLITE_ASSOC); // the "well known practice" $i = '0'; while ($row = sqlite_fetch_array($result, SQLITE_ASSOC)): $array2["$i"] = $row; $i++; endwhile; sqlite_close($dbhandle); endif; ?> There are no differents within the values of array1 and array2. Both arrays will be something like: Array ( [0] => Array ( [x] => 22004 [y] => example_data1 ) [1] => Array ( [x] => 92044 [y] => example_data2 ) [2] => Array ( [x] => 143060 [y] => example_data3 ) ) If you want to let me know about your comments, feel free to send me a note via feedback-formular at: http://www.d0x.de/pages/kontakt.php

sqlite_fetch_all

Fetches all rows from a result set as an array of arrays (PHP 5, PECL sqlite:1.0-1.0.3) array sqlite_fetch_all ( resource result [, int result_type [, bool decode_binary]] )

Example 2329. Procedural example

Example 2330. Object-oriented example

Code Examples / Notes » sqlite_fetch_all

Change Language

Fetches all rows from a result set as an array of arrays (PHP 5, PECL sqlite:1.0-1.0.3)
array sqlite_fetch_all ( resource result [, int result_type [, bool decode_binary]] )