vrana Wed Jun 14 12:08:09 2006 UTC
Modified files:
/phpdoc/en/reference/sqlite/functions sqlite-fetch-array.xml
Log:
Example for this function
http://cvs.php.net/viewcvs.cgi/phpdoc/en/reference/sqlite/functions/sqlite-fetch-array.xml?r1=1.8&r2=1.9&diff_format=u
Index: phpdoc/en/reference/sqlite/functions/sqlite-fetch-array.xml
diff -u phpdoc/en/reference/sqlite/functions/sqlite-fetch-array.xml:1.8
phpdoc/en/reference/sqlite/functions/sqlite-fetch-array.xml:1.9
--- phpdoc/en/reference/sqlite/functions/sqlite-fetch-array.xml:1.8 Mon Feb
21 00:31:07 2005
+++ phpdoc/en/reference/sqlite/functions/sqlite-fetch-array.xml Wed Jun 14
12:08:09 2006
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.8 $ -->
+<!-- $Revision: 1.9 $ -->
<refentry id="function.sqlite-fetch-array">
<refnamediv>
<refname>sqlite_fetch_array</refname>
@@ -88,8 +88,7 @@
<?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) {
+while ($entry = sqlite_fetch_array($query, SQLITE_ASSOC)) {
echo 'Name: ' . $entry['name'] . ' E-mail: ' . $entry['email'];
}
?>
@@ -108,8 +107,7 @@
$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) {
+while ($entry = $query->fetch(SQLITE_ASSOC)) {
echo 'Name: ' . $entry['name'] . ' E-mail: ' . $entry['email'];
}
?>
