1--TEST-- 2mysqli_stmt_execute() - Stored Procedures 3--SKIPIF-- 4<?php 5require_once('skipif.inc'); 6require_once('skipifconnectfailure.inc'); 7require_once('connect.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) <= 50000) { 12 die(sprintf('skip Needs MySQL 5.0+, found version %d.', mysqli_get_server_version($link))); 13} 14?> 15--FILE-- 16<?php 17 require_once('connect.inc'); 18 require_once('table.inc'); 19 20 if (!mysqli_query($link, 'DROP PROCEDURE IF EXISTS p')) 21 printf("[009] [%d] %s.\n", mysqli_errno($link), mysqli_error($link)); 22 23 if (mysqli_real_query($link, 'CREATE PROCEDURE p(OUT ver_param VARCHAR(25)) BEGIN SELECT VERSION() INTO ver_param; END;')) { 24 /* no result set, one output parameter */ 25 if (!$stmt = mysqli_prepare($link, 'CALL p(@version)')) 26 printf("[011] Cannot prepare CALL, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 27 28 if (!mysqli_stmt_execute($stmt)) 29 printf("[012] Cannot execute CALL, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 30 31 /* yes, I really want to call it twice! */ 32 if (!mysqli_stmt_execute($stmt)) 33 printf("[013] Cannot execute CALL, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 34 35 if (!mysqli_stmt_close($stmt)) 36 printf("[014] Cannot close statement, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 37 38 if (!$stmt = mysqli_prepare($link, 'SELECT @version AS _version')) 39 printf("[015] Cannot prepare SELECT, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 40 41 if (!mysqli_stmt_execute($stmt)) 42 printf("[016] Cannot execute SELECT, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 43 44 $version = 'unknown'; 45 if (!mysqli_stmt_bind_result($stmt, $version) || 46 !mysqli_stmt_fetch($stmt)) 47 printf("[017] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 48 49 if (($version == "unknown") || ($version == "")) 50 printf("[018] Results seem wrong, got %s, [%d] %s\n", 51 $version, 52 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 53 54 mysqli_stmt_free_result($stmt); 55 mysqli_stmt_close($stmt); 56 57 } else { 58 printf("[010] Cannot create SP, [%d] %s.\n", mysqli_errno($link), mysqli_error($link)); 59 } 60 61 62 if (function_exists('mysqli_stmt_get_result')) { 63 64 if (!mysqli_query($link, 'DROP PROCEDURE IF EXISTS p')) 65 printf("[019] [%d] %s.\n", mysqli_errno($link), mysqli_error($link)); 66 67 if (mysqli_real_query($link, 'CREATE PROCEDURE p(OUT ver_param VARCHAR(25)) BEGIN SELECT VERSION() INTO ver_param; END;')) { 68 // no result set, one output parameter 69 if (!$stmt = mysqli_prepare($link, 'CALL p(@version)')) 70 printf("[020] Cannot prepare CALL, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 71 72 if (!mysqli_stmt_execute($stmt)) 73 printf("[021] Cannot execute CALL, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 74 75 if (!mysqli_stmt_close($stmt)) 76 printf("[022] Cannot close statement, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 77 78 if (!$stmt = mysqli_prepare($link, 'SELECT @version AS _version')) 79 printf("[023] Cannot prepare SELECT, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 80 81 if (!mysqli_stmt_execute($stmt)) 82 printf("[024] Cannot execute SELECT, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 83 84 if (!$res = mysqli_stmt_get_result($stmt)) 85 printf("[025] Cannot get result set, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 86 87 if ((!($row = mysqli_fetch_assoc($res))) || ($row['_version'] == "")) 88 printf("[026] Results seem wrong, got %s, [%d] %s\n", 89 $row['_version'], 90 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 91 92 mysqli_free_result($res); 93 mysqli_stmt_close($stmt); 94 95 } else { 96 printf("[027] Cannot create SP, [%d] %s.\n", mysqli_errno($link), mysqli_error($link)); 97 } 98 99 } 100 101 if (!mysqli_query($link, 'DROP PROCEDURE IF EXISTS p')) 102 printf("[028] [%d] %s.\n", mysqli_errno($link), mysqli_error($link)); 103 104 if (mysqli_real_query($link, 'CREATE PROCEDURE p(IN ver_in VARCHAR(25), OUT ver_out VARCHAR(25)) BEGIN SELECT ver_in INTO ver_out; END;')) { 105 // no result set, one input parameter, output parameter 106 // yes, I really do not want to bind input values... 107 if (!$stmt = mysqli_prepare($link, "CALL p('myversion', @version)")) 108 printf("[029] Cannot prepare CALL, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 109 110 if (!mysqli_stmt_execute($stmt)) 111 printf("[030] Cannot execute CALL, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 112 113 if (!mysqli_stmt_close($stmt)) 114 printf("[031] Cannot close statement, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 115 116 if (!$stmt = mysqli_prepare($link, 'SELECT @version AS _version')) 117 printf("[032] Cannot prepare SELECT, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 118 119 if (!mysqli_stmt_execute($stmt)) 120 printf("[033] Cannot execute SELECT, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 121 122 $version = 'unknown'; 123 if (!mysqli_stmt_bind_result($stmt, $version) || 124 !mysqli_stmt_fetch($stmt)) 125 printf("[034] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 126 127 if ($version != "myversion") 128 printf("[035] Results seem wrong, got %s, [%d] %s\n", 129 $version, 130 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 131 132 mysqli_stmt_free_result($stmt); 133 mysqli_stmt_close($stmt); 134 135 } else { 136 printf("[036] Cannot create SP, [%d] %s.\n", mysqli_errno($link), mysqli_error($link)); 137 } 138 139 if (!mysqli_query($link, 'DROP PROCEDURE IF EXISTS p')) 140 printf("[037] [%d] %s.\n", mysqli_errno($link), mysqli_error($link)); 141 142 if (mysqli_real_query($link, 'CREATE PROCEDURE p(IN ver_in VARCHAR(25), OUT ver_out VARCHAR(25)) BEGIN SELECT ver_in INTO ver_out; END;')) { 143 // no result set, one input parameter, output parameter 144 // yes, I really do not want to bind input values... 145 if (!$stmt = mysqli_prepare($link, 'CALL p(?, @version)')) 146 printf("[038] Cannot prepare CALL, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 147 148 $version = 'myversion'; 149 if (!mysqli_stmt_bind_param($stmt, 's', $version)) 150 printf("[039] Cannot bind input parameter, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 151 152 if (!mysqli_stmt_execute($stmt)) 153 printf("[040] Cannot execute CALL, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 154 155 if (!mysqli_stmt_close($stmt)) 156 printf("[041] Cannot close statement, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 157 158 if (!$stmt = mysqli_prepare($link, 'SELECT @version AS _version')) 159 printf("[042] Cannot prepare SELECT, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 160 161 if (!mysqli_stmt_execute($stmt)) 162 printf("[043] Cannot execute SELECT, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 163 164 $version = 'unknown'; 165 if (!mysqli_stmt_bind_result($stmt, $version) || 166 !mysqli_stmt_fetch($stmt)) 167 printf("[044] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 168 169 if ($version !== "myversion") 170 printf("[045] Results seem wrong, got %s, [%d] %s\n", 171 $version, 172 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 173 174 mysqli_stmt_free_result($stmt); 175 mysqli_stmt_close($stmt); 176 177 } else { 178 printf("[046] Cannot create SP, [%d] %s.\n", mysqli_errno($link), mysqli_error($link)); 179 } 180 181 mysqli_close($link); 182 print "done!"; 183?> 184--CLEAN-- 185<?php 186require_once("connect.inc"); 187if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) 188 printf("[c001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error()); 189 190if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch")) 191 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 192 193@mysqli_query($link, 'DROP PROCEDURE IF EXISTS p'); 194 195mysqli_close($link); 196?> 197--EXPECT-- 198done! 199
