1--TEST-- 2sqlite-oo: fetch all (buffered) 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_oo.inc"; 11 12$data = array( 13 "one", 14 "two", 15 "three" 16 ); 17 18$db->query("CREATE TABLE strings(a VARCHAR)"); 19 20foreach ($data as $str) { 21 $db->query("INSERT INTO strings VALUES('$str')"); 22} 23 24$r = $db->query("SELECT a from strings"); 25while ($row = $r->fetch(SQLITE_NUM)) { 26 var_dump($row); 27} 28echo "DONE!\n"; 29?> 30--EXPECT-- 31array(1) { 32 [0]=> 33 string(3) "one" 34} 35array(1) { 36 [0]=> 37 string(3) "two" 38} 39array(1) { 40 [0]=> 41 string(5) "three" 42} 43DONE! 44
