diff options
author | SVN Migration <svn@php.net> | 2004-01-26 01:59:15 +0000 |
---|---|---|
committer | SVN Migration <svn@php.net> | 2004-01-26 01:59:15 +0000 |
commit | c99a4f4747eac00e5e7fb44eb9e6467e258b30c6 (patch) | |
tree | 99ab150cf56eb6b75e0c0327d0b608e74445df58 /ext/sqlite/tests/sqlite_013.phpt | |
parent | 3507f040622d2267950f26c69b6ac30c1beb94f4 (diff) | |
download | php-git-RELEASE_1_3b6.tar.gz |
This commit was manufactured by cvs2svn to create tag 'RELEASE_1_3b6'.RELEASE_1_3b6
Diffstat (limited to 'ext/sqlite/tests/sqlite_013.phpt')
-rwxr-xr-x | ext/sqlite/tests/sqlite_013.phpt | 78 |
1 files changed, 0 insertions, 78 deletions
diff --git a/ext/sqlite/tests/sqlite_013.phpt b/ext/sqlite/tests/sqlite_013.phpt deleted file mode 100755 index 2a5e44ccf3..0000000000 --- a/ext/sqlite/tests/sqlite_013.phpt +++ /dev/null @@ -1,78 +0,0 @@ ---TEST-- -sqlite: fetch column ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -$data = array( - array (0 => 'one', 1 => 'two'), - array (0 => 'three', 1 => 'four') - ); - -sqlite_query("CREATE TABLE strings(a VARCHAR, b VARCHAR)", $db); - -foreach ($data as $str) { - sqlite_query("INSERT INTO strings VALUES('${str[0]}','${str[1]}')", $db); -} - -echo "====BUFFERED====\n"; -$r = sqlite_query("SELECT a, b from strings", $db); -while (sqlite_has_more($r)) { - var_dump(sqlite_current($r, SQLITE_NUM)); - var_dump(sqlite_column($r, 0)); - var_dump(sqlite_column($r, 1)); - var_dump(sqlite_column($r, 'a')); - var_dump(sqlite_column($r, 'b')); - sqlite_next($r); -} -echo "====UNBUFFERED====\n"; -$r = sqlite_unbuffered_query("SELECT a, b from strings", $db); -while (sqlite_has_more($r)) { - var_dump(sqlite_column($r, 0)); - var_dump(sqlite_column($r, 'b')); - var_dump(sqlite_column($r, 1)); - var_dump(sqlite_column($r, 'a')); - sqlite_next($r); -} - -sqlite_close($db); - -echo "DONE!\n"; -?> ---EXPECT-- -====BUFFERED==== -array(2) { - [0]=> - string(3) "one" - [1]=> - string(3) "two" -} -string(3) "one" -string(3) "two" -string(3) "one" -string(3) "two" -array(2) { - [0]=> - string(5) "three" - [1]=> - string(4) "four" -} -string(5) "three" -string(4) "four" -string(5) "three" -string(4) "four" -====UNBUFFERED==== -string(3) "one" -string(3) "two" -NULL -NULL -string(5) "three" -string(4) "four" -NULL -NULL -DONE! |