diff options
| -rwxr-xr-x | ext/sqlite/tests/sqlite_010.phpt | 33 |
1 files changed, 33 insertions, 0 deletions
diff --git a/ext/sqlite/tests/sqlite_010.phpt b/ext/sqlite/tests/sqlite_010.phpt new file mode 100755 index 0000000000..d17b87a09d --- /dev/null +++ b/ext/sqlite/tests/sqlite_010.phpt @@ -0,0 +1,33 @@ +--TEST-- +sqlite: fetch all (unbuffered) +--SKIPIF-- +<?php # vim:ft=php +if (!extension_loaded("sqlite")) print "skip"; ?> +--FILE-- +<?php +include "blankdb.inc"; + +sqlite_query("CREATE TABLE strings(foo VARCHAR, bar VARCHAR, baz VARCHAR)", $db); + +echo "Buffered\n"; +$r = sqlite_query("SELECT * from strings", $db); +for($i=0; $i<sqlite_num_fields($r); $i++) { + var_dump(sqlite_field_name($r, $i)); +} +echo "Unbuffered\n"; +$r = sqlite_unbuffered_query("SELECT * from strings", $db); +for($i=0; $i<sqlite_num_fields($r); $i++) { + var_dump(sqlite_field_name($r, $i)); +} +echo "DONE!\n"; +?> +--EXPECT-- +Buffered +string(3) "foo" +string(3) "bar" +string(3) "baz" +Unbuffered +string(3) "foo" +string(3) "bar" +string(3) "baz" +DONE! |