1--TEST-- 2sqlite: fetch all (iterator) 3--INI-- 4sqlite.assoc_case=0 5--SKIPIF-- 6<?php # vim:ft=php 7if (!extension_loaded("sqlite")) print "skip"; ?> 8--FILE-- 9<?php 10include "blankdb.inc"; 11 12$data = array( 13 "one", 14 "two", 15 "three" 16 ); 17 18sqlite_query("CREATE TABLE strings(a VARCHAR)", $db); 19 20foreach ($data as $str) { 21 sqlite_query("INSERT INTO strings VALUES('$str')", $db); 22} 23 24$r = sqlite_unbuffered_query("SELECT a from strings", $db); 25while (sqlite_valid($r)) { 26 var_dump(sqlite_current($r, SQLITE_NUM)); 27 sqlite_next($r); 28} 29$r = sqlite_query("SELECT a from strings", $db); 30while (sqlite_valid($r)) { 31 var_dump(sqlite_current($r, SQLITE_NUM)); 32 sqlite_next($r); 33} 34sqlite_rewind($r); 35while (sqlite_valid($r)) { 36 var_dump(sqlite_current($r, SQLITE_NUM)); 37 sqlite_next($r); 38} 39 40sqlite_close($db); 41 42echo "DONE!\n"; 43?> 44--EXPECT-- 45array(1) { 46 [0]=> 47 string(3) "one" 48} 49array(1) { 50 [0]=> 51 string(3) "two" 52} 53array(1) { 54 [0]=> 55 string(5) "three" 56} 57array(1) { 58 [0]=> 59 string(3) "one" 60} 61array(1) { 62 [0]=> 63 string(3) "two" 64} 65array(1) { 66 [0]=> 67 string(5) "three" 68} 69array(1) { 70 [0]=> 71 string(3) "one" 72} 73array(1) { 74 [0]=> 75 string(3) "two" 76} 77array(1) { 78 [0]=> 79 string(5) "three" 80} 81DONE! 82
