1--TEST-- 2sqlite-oo: sqlite / foreach 3--INI-- 4sqlite.assoc_case=0 5--SKIPIF-- 6<?php # vim:ft=php 7if (!extension_loaded("sqlite")) print "skip"; 8?> 9--FILE-- 10<?php 11include "blankdb_oo.inc"; 12 13$data = array( 14 "one", 15 "two", 16 "three" 17 ); 18 19$db->query("CREATE TABLE strings(a VARCHAR)"); 20 21foreach ($data as $str) { 22 $db->query("INSERT INTO strings VALUES('$str')"); 23} 24 25echo "====UNBUFFERED====\n"; 26$r = $db->unbufferedQuery("SELECT a from strings", SQLITE_NUM); 27//var_dump(class_implements($r)); 28foreach($r as $row) { 29 var_dump($row); 30} 31echo "====NO-MORE====\n"; 32foreach($r as $row) { 33 var_dump($row); 34} 35echo "====DIRECT====\n"; 36foreach($db->unbufferedQuery("SELECT a from strings", SQLITE_NUM) as $row) { 37 var_dump($row); 38} 39echo "====BUFFERED====\n"; 40$r = $db->query("SELECT a from strings", SQLITE_NUM); 41//var_dump(class_implements($r)); 42foreach($r as $row) { 43 var_dump($row); 44} 45foreach($r as $row) { 46 var_dump($row); 47} 48echo "DONE!\n"; 49?> 50--EXPECT-- 51====UNBUFFERED==== 52array(1) { 53 [0]=> 54 string(3) "one" 55} 56array(1) { 57 [0]=> 58 string(3) "two" 59} 60array(1) { 61 [0]=> 62 string(5) "three" 63} 64====NO-MORE==== 65====DIRECT==== 66array(1) { 67 [0]=> 68 string(3) "one" 69} 70array(1) { 71 [0]=> 72 string(3) "two" 73} 74array(1) { 75 [0]=> 76 string(5) "three" 77} 78====BUFFERED==== 79array(1) { 80 [0]=> 81 string(3) "one" 82} 83array(1) { 84 [0]=> 85 string(3) "two" 86} 87array(1) { 88 [0]=> 89 string(5) "three" 90} 91array(1) { 92 [0]=> 93 string(3) "one" 94} 95array(1) { 96 [0]=> 97 string(3) "two" 98} 99array(1) { 100 [0]=> 101 string(5) "three" 102} 103DONE! 104