diff options
| author | SVN Migration <svn@php.net> | 2003-06-18 22:02:29 +0000 |
|---|---|---|
| committer | SVN Migration <svn@php.net> | 2003-06-18 22:02:29 +0000 |
| commit | a400da70d39a3c947663830f78878ec5bdc17864 (patch) | |
| tree | 7ecb565070571b50ebaafa3851d145dc370af387 /ext/sqlite/tests/sqlite_013.phpt | |
| parent | 4cf62ff62cd37a70bdadce9375f89eefe311d539 (diff) | |
| download | php-git-php-4.3.3RC1.tar.gz | |
This commit was manufactured by cvs2svn to create tag 'php_4_3_3RC1'.php-4.3.3RC1
Diffstat (limited to 'ext/sqlite/tests/sqlite_013.phpt')
| -rwxr-xr-x | ext/sqlite/tests/sqlite_013.phpt | 75 |
1 files changed, 0 insertions, 75 deletions
diff --git a/ext/sqlite/tests/sqlite_013.phpt b/ext/sqlite/tests/sqlite_013.phpt deleted file mode 100755 index a9f2ae5dad..0000000000 --- a/ext/sqlite/tests/sqlite_013.phpt +++ /dev/null @@ -1,75 +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); -} -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! |
