1--TEST-- 2sqlite-oo: fetch column 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->current(SQLITE_NUM)); 27 var_dump($r->column(0)); 28 var_dump($r->column(1)); 29 var_dump($r->column('a')); 30 var_dump($r->column('b')); 31 $r->next(); 32} 33echo "====UNBUFFERED====\n"; 34$r = $db->unbufferedQuery("SELECT a, b from strings"); 35while ($r->valid()) { 36 var_dump($r->column(0)); 37 var_dump($r->column('b')); 38 var_dump($r->column(1)); 39 var_dump($r->column('a')); 40 $r->next(); 41} 42echo "DONE!\n"; 43?> 44--EXPECT-- 45====BUFFERED==== 46array(2) { 47 [0]=> 48 string(3) "one" 49 [1]=> 50 string(3) "two" 51} 52string(3) "one" 53string(3) "two" 54string(3) "one" 55string(3) "two" 56array(2) { 57 [0]=> 58 string(5) "three" 59 [1]=> 60 string(4) "four" 61} 62string(5) "three" 63string(4) "four" 64string(5) "three" 65string(4) "four" 66====UNBUFFERED==== 67string(3) "one" 68string(3) "two" 69NULL 70NULL 71string(5) "three" 72string(4) "four" 73NULL 74NULL 75DONE! 76
