Annotation of embedaddon/php/ext/sqlite/tests/sqlite_010.phpt, revision 1.1
1.1 ! misho 1: --TEST--
! 2: sqlite: fetch all (iterator)
! 3: --INI--
! 4: sqlite.assoc_case=0
! 5: --SKIPIF--
! 6: <?php # vim:ft=php
! 7: if (!extension_loaded("sqlite")) print "skip"; ?>
! 8: --FILE--
! 9: <?php
! 10: include "blankdb.inc";
! 11:
! 12: $data = array(
! 13: "one",
! 14: "two",
! 15: "three"
! 16: );
! 17:
! 18: sqlite_query("CREATE TABLE strings(a VARCHAR)", $db);
! 19:
! 20: foreach ($data as $str) {
! 21: sqlite_query("INSERT INTO strings VALUES('$str')", $db);
! 22: }
! 23:
! 24: $r = sqlite_unbuffered_query("SELECT a from strings", $db);
! 25: while (sqlite_valid($r)) {
! 26: var_dump(sqlite_current($r, SQLITE_NUM));
! 27: sqlite_next($r);
! 28: }
! 29: $r = sqlite_query("SELECT a from strings", $db);
! 30: while (sqlite_valid($r)) {
! 31: var_dump(sqlite_current($r, SQLITE_NUM));
! 32: sqlite_next($r);
! 33: }
! 34: sqlite_rewind($r);
! 35: while (sqlite_valid($r)) {
! 36: var_dump(sqlite_current($r, SQLITE_NUM));
! 37: sqlite_next($r);
! 38: }
! 39:
! 40: sqlite_close($db);
! 41:
! 42: echo "DONE!\n";
! 43: ?>
! 44: --EXPECT--
! 45: array(1) {
! 46: [0]=>
! 47: string(3) "one"
! 48: }
! 49: array(1) {
! 50: [0]=>
! 51: string(3) "two"
! 52: }
! 53: array(1) {
! 54: [0]=>
! 55: string(5) "three"
! 56: }
! 57: array(1) {
! 58: [0]=>
! 59: string(3) "one"
! 60: }
! 61: array(1) {
! 62: [0]=>
! 63: string(3) "two"
! 64: }
! 65: array(1) {
! 66: [0]=>
! 67: string(5) "three"
! 68: }
! 69: array(1) {
! 70: [0]=>
! 71: string(3) "one"
! 72: }
! 73: array(1) {
! 74: [0]=>
! 75: string(3) "two"
! 76: }
! 77: array(1) {
! 78: [0]=>
! 79: string(5) "three"
! 80: }
! 81: DONE!
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>