cvs: phpdoc /en/reference/sqlite/functions sqlite-fetch-array.xml

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']; } ?>