Annotation of embedaddon/php/ext/mysqli/tests/mysqli_query_iterators.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: mysqli iterators
3: --SKIPIF--
4: <?php
5: require_once('skipif.inc');
6: require_once('skipifemb.inc');
7: require_once('skipifconnectfailure.inc');
8: ?>
9: --FILE--
10: <?php
11: require_once("connect.inc");
12:
13: $tmp = NULL;
14: $link = NULL;
15:
16: require('table.inc');
17:
18: echo "--- Testing default ---\n";
19: if (!is_object($res = mysqli_query($link, "SELECT id FROM test ORDER BY id")))
20: printf("[011] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
21: else {
22: foreach ($res as $row) {
23: var_dump($row);
24: }
25: echo "======\n";
26: foreach ($res as $row) {
27: var_dump($row);
28: }
29: mysqli_free_result($res);
30: foreach ($res as $row) {
31: var_dump($row);
32: }
33: }
34: echo "--- Testing USE_RESULT ---\n";
35: if (!is_object($res = mysqli_query($link, "SELECT id FROM test ORDER BY id", MYSQLI_USE_RESULT)))
36: printf("[011] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
37: else {
38: foreach ($res as $row) {
39: var_dump($row);
40: }
41: echo "======\n";
42: foreach ($res as $row) {
43: var_dump($row);
44: }
45: mysqli_free_result($res);
46: }
47:
48: echo "--- Testing STORE_RESULT ---\n";
49: if (!is_object($res = mysqli_query($link, "SELECT id FROM test ORDER BY id", MYSQLI_STORE_RESULT)))
50: printf("[012] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
51: else {
52: foreach ($res as $row) {
53: var_dump($row);
54: }
55: echo "======\n";
56: foreach ($res as $row) {
57: var_dump($row);
58: }
59: mysqli_free_result($res);
60: }
61:
62: mysqli_close($link);
63:
64: print "done!";
65: ?>
66: --CLEAN--
67: <?php
68: require_once("clean_table.inc");
69: ?>
70: --EXPECTF--
71: --- Testing default ---
72: array(1) {
73: ["id"]=>
74: string(1) "1"
75: }
76: array(1) {
77: ["id"]=>
78: string(1) "2"
79: }
80: array(1) {
81: ["id"]=>
82: string(1) "3"
83: }
84: array(1) {
85: ["id"]=>
86: string(1) "4"
87: }
88: array(1) {
89: ["id"]=>
90: string(1) "5"
91: }
92: array(1) {
93: ["id"]=>
94: string(1) "6"
95: }
96: ======
97: array(1) {
98: ["id"]=>
99: string(1) "1"
100: }
101: array(1) {
102: ["id"]=>
103: string(1) "2"
104: }
105: array(1) {
106: ["id"]=>
107: string(1) "3"
108: }
109: array(1) {
110: ["id"]=>
111: string(1) "4"
112: }
113: array(1) {
114: ["id"]=>
115: string(1) "5"
116: }
117: array(1) {
118: ["id"]=>
119: string(1) "6"
120: }
121:
122: Warning: main(): Couldn't fetch mysqli_result in %s on line %d
123: --- Testing USE_RESULT ---
124: array(1) {
125: ["id"]=>
126: string(1) "1"
127: }
128: array(1) {
129: ["id"]=>
130: string(1) "2"
131: }
132: array(1) {
133: ["id"]=>
134: string(1) "3"
135: }
136: array(1) {
137: ["id"]=>
138: string(1) "4"
139: }
140: array(1) {
141: ["id"]=>
142: string(1) "5"
143: }
144: array(1) {
145: ["id"]=>
146: string(1) "6"
147: }
148: ======
149:
150: Warning: main(): Data fetched with MYSQLI_USE_RESULT can be iterated only once in %s on line %d
151: --- Testing STORE_RESULT ---
152: array(1) {
153: ["id"]=>
154: string(1) "1"
155: }
156: array(1) {
157: ["id"]=>
158: string(1) "2"
159: }
160: array(1) {
161: ["id"]=>
162: string(1) "3"
163: }
164: array(1) {
165: ["id"]=>
166: string(1) "4"
167: }
168: array(1) {
169: ["id"]=>
170: string(1) "5"
171: }
172: array(1) {
173: ["id"]=>
174: string(1) "6"
175: }
176: ======
177: array(1) {
178: ["id"]=>
179: string(1) "1"
180: }
181: array(1) {
182: ["id"]=>
183: string(1) "2"
184: }
185: array(1) {
186: ["id"]=>
187: string(1) "3"
188: }
189: array(1) {
190: ["id"]=>
191: string(1) "4"
192: }
193: array(1) {
194: ["id"]=>
195: string(1) "5"
196: }
197: array(1) {
198: ["id"]=>
199: string(1) "6"
200: }
201: done!
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>