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