Annotation of embedaddon/php/ext/sqlite/tests/sqlite_oo_016.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: sqlite-oo: fetch single
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_oo.inc";
11:
12: $data = array(
13: array (0 => 'one', 1 => 'two'),
14: array (0 => 'three', 1 => 'four')
15: );
16:
17: $db->query("CREATE TABLE strings(a VARCHAR, b VARCHAR)");
18:
19: foreach ($data as $str) {
20: $db->query("INSERT INTO strings VALUES('${str[0]}','${str[1]}')");
21: }
22:
23: echo "====BUFFERED====\n";
24: $r = $db->query("SELECT a, b from strings");
25: while ($r->valid()) {
26: var_dump($r->fetchSingle());
27: }
28: echo "====UNBUFFERED====\n";
29: $r = $db->unbufferedQuery("SELECT a, b from strings");
30: while ($r->valid()) {
31: var_dump($r->fetchSingle());
32: }
33: echo "DONE!\n";
34: ?>
35: --EXPECT--
36: ====BUFFERED====
37: string(3) "one"
38: string(5) "three"
39: ====UNBUFFERED====
40: string(3) "one"
41: string(5) "three"
42: DONE!
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>