Annotation of embedaddon/php/ext/mysqli/tests/mysqli_fetch_assoc_oo.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: mysqli_fetch_assoc()
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: // Note: no SQL type tests, internally the same function gets used as for mysqli_fetch_array() which does a lot of SQL type test
17: $mysqli = new mysqli();
18: $res = @new mysqli_result($mysqli);
19: if (!is_null($tmp = @$res->fetch_assoc()))
20: printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
21:
22: require('table.inc');
23: if (!$mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket))
24: printf("[002] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
25: $host, $user, $db, $port, $socket);
26:
27: if (!is_null($tmp = @$res->fetch_assoc($link)))
28: printf("[003] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
29:
30: if (!$res = $mysqli->query("SELECT id, label FROM test ORDER BY id LIMIT 1")) {
31: printf("[004] [%d] %s\n", $mysqli->errno, $mysqli->error);
32: }
33:
34: print "[005]\n";
35: var_dump($res->fetch_assoc());
36:
37: print "[006]\n";
38: var_dump($res->fetch_assoc());
39:
40: $res->free_result();
41:
42: if (!$res = $mysqli->query("SELECT 1 AS a, 2 AS a, 3 AS c, 4 AS C, NULL AS d, true AS e")) {
43: printf("[007] Cannot run query, [%d] %s\n", $mysqli->errno, $mysqli->error);
44: }
45: print "[008]\n";
46: var_dump($res->fetch_assoc());
47:
48: $res->free_result();
49:
50: if (NULL !== ($tmp = $res->fetch_assoc()))
51: printf("[008] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
52:
53: mysqli_close($link);
54:
55: print "done!";
56: ?>
57: --CLEAN--
58: <?php
59: require_once("clean_table.inc");
60: ?>
61: --EXPECTF--
62: [005]
63: array(2) {
64: [%u|b%"id"]=>
65: %unicode|string%(1) "1"
66: [%u|b%"label"]=>
67: %unicode|string%(1) "a"
68: }
69: [006]
70: NULL
71: [008]
72: array(5) {
73: [%u|b%"a"]=>
74: %unicode|string%(1) "2"
75: [%u|b%"c"]=>
76: %unicode|string%(1) "3"
77: [%u|b%"C"]=>
78: %unicode|string%(1) "4"
79: [%u|b%"d"]=>
80: NULL
81: [%u|b%"e"]=>
82: %unicode|string%(1) "1"
83: }
84:
85: Warning: mysqli_result::fetch_assoc(): Couldn't fetch mysqli_result in %s on line %d
86: done!
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>