1--TEST-- 2sqlite: 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.inc"; 11 12$data = array( 13 array (0 => 'one', 1 => 'two'), 14 array (0 => 'three', 1 => 'four') 15 ); 16 17sqlite_query("CREATE TABLE strings(a VARCHAR, b VARCHAR)", $db); 18 19foreach ($data as $str) { 20 sqlite_query("INSERT INTO strings VALUES('${str[0]}','${str[1]}')", $db); 21} 22 23echo "====BUFFERED====\n"; 24$r = sqlite_query("SELECT a, b from strings", $db); 25while (sqlite_valid($r)) { 26 var_dump(sqlite_current($r, SQLITE_NUM)); 27 var_dump(sqlite_column($r, 0)); 28 var_dump(sqlite_column($r, 1)); 29 var_dump(sqlite_column($r, 'a')); 30 var_dump(sqlite_column($r, 'b')); 31 sqlite_next($r); 32} 33echo "====UNBUFFERED====\n"; 34$r = sqlite_unbuffered_query("SELECT a, b from strings", $db); 35while (sqlite_valid($r)) { 36 var_dump(sqlite_column($r, 0)); 37 var_dump(sqlite_column($r, 'b')); 38 var_dump(sqlite_column($r, 1)); 39 var_dump(sqlite_column($r, 'a')); 40 sqlite_next($r); 41} 42 43sqlite_close($db); 44 45echo "DONE!\n"; 46?> 47--EXPECT-- 48====BUFFERED==== 49array(2) { 50 [0]=> 51 string(3) "one" 52 [1]=> 53 string(3) "two" 54} 55string(3) "one" 56string(3) "two" 57string(3) "one" 58string(3) "two" 59array(2) { 60 [0]=> 61 string(5) "three" 62 [1]=> 63 string(4) "four" 64} 65string(5) "three" 66string(4) "four" 67string(5) "three" 68string(4) "four" 69====UNBUFFERED==== 70string(3) "one" 71string(3) "two" 72NULL 73NULL 74string(5) "three" 75string(4) "four" 76NULL 77NULL 78DONE! 79
