1--TEST-- 2sqlite: read field names 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 12sqlite_query("CREATE TABLE strings(foo VARCHAR, bar VARCHAR, baz VARCHAR)", $db); 13 14echo "Buffered\n"; 15$r = sqlite_query("SELECT * from strings", $db); 16for($i=0; $i<sqlite_num_fields($r); $i++) { 17 var_dump(sqlite_field_name($r, $i)); 18} 19echo "Unbuffered\n"; 20$r = sqlite_unbuffered_query("SELECT * from strings", $db); 21for($i=0; $i<sqlite_num_fields($r); $i++) { 22 var_dump(sqlite_field_name($r, $i)); 23} 24 25sqlite_close($db); 26 27echo "DONE!\n"; 28?> 29--EXPECT-- 30Buffered 31string(3) "foo" 32string(3) "bar" 33string(3) "baz" 34Unbuffered 35string(3) "foo" 36string(3) "bar" 37string(3) "baz" 38DONE! 39
