Annotation of embedaddon/php/ext/sqlite/tests/sqlite_010.phpt, revision 1.1.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>