1--TEST--
2mysqli_stmt_get_result()
3--SKIPIF--
4<?php
5require_once('skipif.inc');
6require_once('skipifemb.inc');
7require_once('skipifconnectfailure.inc');
8if (!function_exists('mysqli_stmt_get_result'))
9	die('skip mysqli_stmt_get_result not available');
10?>
11--FILE--
12<?php
13	/*
14	NOTE: no datatype tests here! This is done by
15	mysqli_stmt_bind_result.phpt already. Restrict
16	this test case to the basics.
17	*/
18	require_once("connect.inc");
19
20	$tmp	= NULL;
21	$link   = NULL;
22
23	if (!is_null($tmp = @mysqli_stmt_get_result()))
24		printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
25
26	if (!is_null($tmp = @mysqli_stmt_get_result($link)))
27		printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
28
29	require('table.inc');
30
31	if (!$stmt = mysqli_stmt_init($link))
32		printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
33
34	if (!is_null($tmp = @mysqli_stmt_get_result($stmt, "foo")))
35		printf("[004] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
36
37	if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id ASC LIMIT 1"))
38		printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
39
40		if (!mysqli_stmt_execute($stmt))
41			printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
42
43		if (!is_object($res = mysqli_stmt_get_result($stmt)) || 'mysqli_result' != get_class($res)) {
44			printf("[007] Expecting object/mysqli_result got %s/%s, [%d] %s\n",
45				gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
46		}
47		while ($row = mysqli_fetch_assoc($res))
48			var_dump($row);
49		var_dump(mysqli_fetch_assoc($res));
50		mysqli_free_result($res);
51
52		if (false !== ($res = mysqli_stmt_get_result($stmt))) {
53			printf("[008] boolean/false got %s/%s, [%d] %s\n",
54				gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
55		}
56
57		mysqli_stmt_execute($stmt);
58		if (!is_object($res = mysqli_stmt_get_result($stmt)) || 'mysqli_result' != get_class($res)) {
59			printf("[009] Expecting object/mysqli_result got %s/%s, [%d] %s\n",
60				gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
61		}
62		while ($row = mysqli_fetch_assoc($res))
63			var_dump($row);
64		var_dump(mysqli_fetch_assoc($res));
65		mysqli_free_result($res);
66
67	mysqli_stmt_close($stmt);
68
69	if (!($stmt = mysqli_stmt_init($link)) ||
70		!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id ASC LIMIT 2") ||
71		!mysqli_stmt_execute($stmt))
72		printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
73
74	$id = $label = null;
75	if (!mysqli_stmt_bind_result($stmt, $id, $label))
76		printf("[011] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
77
78	if (!mysqli_stmt_fetch($stmt))
79		printf("[012] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
80
81	if (false !== ($res = mysqli_stmt_get_result($stmt))) {
82		printf("[013] boolean/false got %s/%s, [%d] %s\n",
83			gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
84	}
85
86	mysqli_stmt_close($stmt);
87
88	if (!($stmt = mysqli_stmt_init($link)) ||
89		!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id ASC LIMIT 2") ||
90		!mysqli_stmt_execute($stmt))
91		printf("[014] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
92
93	if (!is_object($res = mysqli_stmt_get_result($stmt)) || 'mysqli_result' != get_class($res)) {
94		printf("[015] Expecting object/mysqli_result got %s/%s, [%d] %s\n",
95			gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
96	}
97
98	$id = $label = null;
99	if (!mysqli_stmt_bind_result($stmt, $id, $label))
100		printf("[016] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
101
102	if (!mysqli_stmt_fetch($stmt))
103		printf("[017] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
104
105	mysqli_stmt_close($stmt);
106
107	if (!($stmt = mysqli_stmt_init($link)) ||
108		!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id ASC LIMIT 2") ||
109		!mysqli_stmt_execute($stmt))
110		printf("[018] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
111
112	if (!is_object($res = mysqli_stmt_get_result($stmt)) || 'mysqli_result' != get_class($res)) {
113		printf("[019] Expecting object/mysqli_result got %s/%s, [%d] %s\n",
114			gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
115	}
116
117	$id = $label = null;
118	if (!mysqli_stmt_bind_result($stmt, $id, $label))
119		printf("[020] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
120
121	$row = mysqli_fetch_assoc($res);
122	if (NULL !== $id || NULL !== $label)
123		printf("[021] Bound variables should not have been set\n");
124	mysqli_free_result($res);
125
126	mysqli_stmt_close($stmt);
127
128	if (!($stmt = mysqli_stmt_init($link)) ||
129		!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id ASC LIMIT 2") ||
130		!mysqli_stmt_execute($stmt))
131		printf("[022] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
132
133	if (!is_object($res = mysqli_stmt_get_result($stmt)) || 'mysqli_result' != get_class($res)) {
134		printf("[023] Expecting object/mysqli_result got %s/%s, [%d] %s\n",
135			gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
136	}
137	if (!in_array($res->type, array(MYSQLI_STORE_RESULT, MYSQLI_USE_RESULT))) {
138		printf("[024] Unknown result set type %s\n", $res->type);
139	}
140	if ($res->type !== MYSQLI_STORE_RESULT)
141		printf("[025] Expecting int/%d got %s/%s", MYSQLI_STORE_RESULT, gettype($res->type), $res->type);
142
143	mysqli_free_result($res);
144	mysqli_stmt_close($stmt);
145	mysqli_close($link);
146
147	if (false !== ($res = mysqli_stmt_get_result($stmt))) {
148		printf("[026] Expecting false got %s/%s\n",
149			gettype($res), $res);
150	}
151
152		print "done!";
153?>
154--CLEAN--
155<?php
156	require_once("clean_table.inc");
157?>
158--EXPECTF--
159array(2) {
160  ["id"]=>
161  int(1)
162  ["label"]=>
163  string(1) "a"
164}
165NULL
166array(2) {
167  ["id"]=>
168  int(1)
169  ["label"]=>
170  string(1) "a"
171}
172NULL
173[017] [2014] Commands out of sync; you can't run this command now
174
175Warning: mysqli_stmt_get_result(): Couldn't fetch mysqli_stmt in %s on line %d
176done!
177