1--TEST--
2mysqli_stmt_execute()
3--SKIPIF--
4<?php
5require_once('skipif.inc');
6require_once('skipifemb.inc');
7require_once('skipifconnectfailure.inc');
8if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) {
9	die(sprintf('skip Cannot connect to MySQL, [%d] %s.', mysqli_connect_errno(), mysqli_connect_error()));
10}
11if (mysqli_get_server_version($link) <= 40100) {
12	die(sprintf('skip Needs MySQL 4.1+, found version %d.', mysqli_get_server_version($link)));
13}
14?>
15--FILE--
16<?php
17	require_once("connect.inc");
18
19	$tmp    = NULL;
20	$link   = NULL;
21
22	if (!is_null($tmp = @mysqli_stmt_execute()))
23		printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
24
25	if (!is_null($tmp = @mysqli_stmt_execute($link)))
26		printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
27
28	require('table.inc');
29
30	if (!$stmt = mysqli_stmt_init($link))
31		printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
32
33	// stmt object status test
34	if (NULL !== ($tmp = mysqli_stmt_execute($stmt)))
35		printf("[004] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
36
37	if (mysqli_stmt_prepare($stmt, "SELECT i_do_not_exist_believe_me FROM test ORDER BY id"))
38		printf("[005] Statement should have failed!\n");
39
40	// stmt object status test
41	if (NULL !== ($tmp = mysqli_stmt_execute($stmt)))
42		printf("[006] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
43
44	if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id LIMIT 1"))
45		printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
46
47	if (true !== ($tmp = mysqli_stmt_execute($stmt)))
48		printf("[008] Expecting boolean/true, got %s/%s. [%d] %s\n",
49			gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
50
51	if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (?, ?)"))
52		printf("[009] [%d] %s\n", mysqli_stmt_execute($stmt), mysqli_stmt_execute($stmt));
53
54	// no input variables bound
55	if (false !== ($tmp = mysqli_stmt_execute($stmt)))
56		printf("[010] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
57
58	$id = 100;
59	$label = "z";
60	if (!mysqli_stmt_bind_param($stmt, "is", $id, $label))
61		printf("[011] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
62
63	if (true !== ($tmp = mysqli_stmt_execute($stmt)))
64		printf("[012] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
65
66	// calling reset between executions
67	mysqli_stmt_close($stmt);
68	if (!$stmt = mysqli_stmt_init($link))
69		printf("[013] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
70
71	if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id LIMIT ?"))
72		printf("[014] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
73
74	$limit = 1;
75	if (!mysqli_stmt_bind_param($stmt, "i", $limit))
76		printf("[015] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
77
78	if (true !== ($tmp = mysqli_stmt_execute($stmt)))
79		printf("[016] Expecting boolean/true, got %s/%s. [%d] %s\n",
80			gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
81
82	$id = null;
83	if (!mysqli_stmt_bind_result($stmt, $id) || !mysqli_stmt_fetch($stmt))
84		printf("[017] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
85
86	if ($id !== 1)
87		printf("[018] Expecting int/1 got %s/%s\n", gettype($id), $id);
88
89	if (true !== ($tmp = mysqli_stmt_reset($stmt)))
90		printf("[019] Expecting boolean/true, got %s/%s. [%d] %s\n",
91			gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
92
93	if (true !== ($tmp = mysqli_stmt_execute($stmt)))
94		printf("[020] Expecting boolean/true after reset to prepare status, got %s/%s. [%d] %s\n",
95			gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
96
97	$id = null;
98	if (!mysqli_stmt_fetch($stmt))
99		printf("[021] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
100
101	if ($id !== 1)
102		printf("[022] Expecting int/1 got %s/%s\n", gettype($id), $id);
103
104	mysqli_stmt_close($stmt);
105	if (!$stmt = mysqli_stmt_init($link))
106		printf("[023] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
107
108	if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id LIMIT 1"))
109		printf("[024] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
110
111	if (true !== ($tmp = mysqli_stmt_execute($stmt)))
112		printf("[025] Expecting boolean/true, got %s/%s. [%d] %s\n",
113			gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
114
115	if (true !== ($tmp = mysqli_stmt_reset($stmt)))
116		printf("[026] Expecting boolean/true, got %s/%s. [%d] %s\n",
117			gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
118
119	var_dump(mysqli_stmt_execute($stmt));
120	var_dump(mysqli_stmt_fetch($stmt));
121
122	mysqli_kill($link, mysqli_thread_id($link));
123
124	if (false !== ($tmp = mysqli_stmt_execute($stmt)))
125		printf("[027] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
126
127	mysqli_stmt_close($stmt);
128
129	if (NULL !== ($tmp = mysqli_stmt_execute($stmt)))
130		printf("[028] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
131
132	mysqli_close($link);
133	print "done!";
134?>
135--CLEAN--
136<?php
137	require_once("clean_table.inc");
138?>
139--EXPECTF--
140Warning: mysqli_stmt_execute(): invalid object or resource mysqli_stmt
141 in %s on line %d
142
143Warning: mysqli_stmt_execute(): invalid object or resource mysqli_stmt
144 in %s on line %d
145bool(true)
146bool(true)
147[027] Expecting boolean/false, got boolean/1
148
149Warning: mysqli_stmt_execute(): Couldn't fetch mysqli_stmt in %s on line %d
150done!
151