diff options
Diffstat (limited to 'ext/sqlite/tests/sqlite_023.phpt')
-rw-r--r-- | ext/sqlite/tests/sqlite_023.phpt | 103 |
1 files changed, 0 insertions, 103 deletions
diff --git a/ext/sqlite/tests/sqlite_023.phpt b/ext/sqlite/tests/sqlite_023.phpt deleted file mode 100644 index ca1bee6b18..0000000000 --- a/ext/sqlite/tests/sqlite_023.phpt +++ /dev/null @@ -1,103 +0,0 @@ ---TEST-- -sqlite: sqlite_[has_]prev ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -$data = array( - "one", - "two", - "three" - ); - -sqlite_query("CREATE TABLE strings(a)", $db); - -foreach ($data as $str) { - sqlite_query("INSERT INTO strings VALUES('$str')", $db); -} - -$r = sqlite_query("SELECT a FROM strings", $db, SQLITE_NUM); - -echo "====TRAVERSE====\n"; -for(sqlite_rewind($r); sqlite_has_more($r); sqlite_next($r)) { - var_dump(sqlite_current($r)); - -} -echo "====REVERSE====\n"; -do { - sqlite_prev($r); - var_dump(sqlite_current($r)); -} while(sqlite_has_prev($r)); - -echo "====UNBUFFERED====\n"; - -$r = sqlite_unbuffered_query("SELECT a FROM strings", $db, SQLITE_NUM); - -echo "====TRAVERSE====\n"; -for(sqlite_rewind($r); sqlite_has_more($r); sqlite_next($r)) { - var_dump(sqlite_current($r)); - -} -echo "====REVERSE====\n"; -do { - sqlite_prev($r); - var_dump(sqlite_current($r)); -} while(sqlite_has_prev($r)); - -echo "====DONE!====\n"; -?> ---EXPECTF-- -====TRAVERSE==== -array(1) { - [0]=> - string(3) "one" -} -array(1) { - [0]=> - string(3) "two" -} -array(1) { - [0]=> - string(5) "three" -} -====REVERSE==== -array(1) { - [0]=> - string(5) "three" -} -array(1) { - [0]=> - string(3) "two" -} -array(1) { - [0]=> - string(3) "one" -} -====UNBUFFERED==== -====TRAVERSE==== - -Warning: sqlite_rewind(): Cannot rewind an unbuffered result set in %ssqlite_023.php on line %d -array(1) { - [0]=> - string(3) "one" -} -array(1) { - [0]=> - string(3) "two" -} -array(1) { - [0]=> - string(5) "three" -} -====REVERSE==== - -Warning: sqlite_prev(): you cannot use sqlite_prev on unbuffered querys in %ssqlite_023.php on line %d -bool(false) - -Warning: sqlite_has_prev(): you cannot use sqlite_has_prev on unbuffered querys in %ssqlite_023.php on line %d -====DONE!==== |