1--TEST-- 2mysqli_stmt_affected_rows() 3--SKIPIF-- 4<?php 5require_once('skipif.inc'); 6require_once('skipifemb.inc'); 7require_once('skipifconnectfailure.inc'); 8?> 9--FILE-- 10<?php 11 require_once("connect.inc"); 12 13 $tmp = NULL; 14 $link = NULL; 15 16 if (!is_null($tmp = @mysqli_stmt_affected_rows())) 17 printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); 18 19 if (!is_null($tmp = @mysqli_stmt_affected_rows($link))) 20 printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); 21 22 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) { 23 printf("Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", 24 $host, $user, $db, $port, $socket); 25 } 26 $stmt = mysqli_stmt_init($link); 27 28 if (!mysqli_stmt_prepare($stmt, 'DROP TABLE IF EXISTS test') || 29 !mysqli_stmt_execute($stmt)) { 30 printf("[003] Failed to drop old test table: [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 31 } 32 33 if (!mysqli_stmt_prepare($stmt, 'CREATE TABLE test(id INT, label CHAR(1), PRIMARY KEY(id)) ENGINE = ' . $engine) || 34 !mysqli_stmt_execute($stmt)) { 35 printf("[004] Failed to create test table: [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 36 } 37 38 if (0 !== ($tmp = mysqli_stmt_affected_rows($stmt))) 39 printf("[005] Expecting int/0, got %s/'%s'\n", gettype($tmp), $tmp); 40 41 mysqli_stmt_close($stmt); 42 $stmt = mysqli_stmt_init($link); 43 44 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (1, 'a')") || 45 !mysqli_stmt_execute($stmt)) 46 printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 47 48 mysqli_stmt_close($stmt); 49 $stmt = mysqli_stmt_init($link); 50 51 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (100, 'z')") || 52 !mysqli_stmt_execute($stmt)) 53 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 54 55 if (1 !== ($tmp = mysqli_stmt_affected_rows($stmt))) 56 printf("[008] Expecting int/1, got %s/%s\n", gettype($tmp), $tmp); 57 58 mysqli_stmt_close($stmt); 59 $stmt = mysqli_stmt_init($link); 60 61 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (100, 'z')") || 62 !mysqli_stmt_execute($stmt)) 63 // NOTE: the error message varies with the MySQL Server version, dump only the error code! 64 printf("[009] [%d] (error message varies with the MySQL Server version, check the error code)\n", mysqli_stmt_errno($stmt)); 65 66 /* an error occurred: affected rows should return -1 */ 67 if (-1 !== ($tmp = mysqli_stmt_affected_rows($stmt))) 68 printf("[010] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp); 69 70 mysqli_stmt_close($stmt); 71 $stmt = mysqli_stmt_init($link); 72 73 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (1, 'a') ON DUPLICATE KEY UPDATE id = 4") || 74 !mysqli_stmt_execute($stmt)) 75 printf("[011] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 76 77 if (2 !== ($tmp = mysqli_stmt_affected_rows($stmt))) 78 printf("[012] Expecting int/2, got %s/%s\n", gettype($tmp), $tmp); 79 80 mysqli_stmt_close($stmt); 81 $stmt = mysqli_stmt_init($link); 82 83 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (2, 'b'), (3, 'c')") || 84 !mysqli_stmt_execute($stmt)) 85 printf("[013] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 86 87 if (2 !== ($tmp = mysqli_stmt_affected_rows($stmt))) 88 printf("[014] Expecting int/2, got %s/%s\n", gettype($tmp), $tmp); 89 90 mysqli_stmt_close($stmt); 91 $stmt = mysqli_stmt_init($link); 92 93 if (!mysqli_stmt_prepare($stmt, "INSERT IGNORE INTO test(id, label) VALUES (1, 'a')") || 94 !mysqli_stmt_execute($stmt)) 95 printf("[015] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 96 97 if (1 !== ($tmp = mysqli_stmt_affected_rows($stmt))) 98 printf("[016] Expecting int/1, got %s/%s\n", gettype($tmp), $tmp); 99 100 if (!($res = mysqli_query($link, "SELECT count(id) AS num FROM test")) || 101 !($tmp = mysqli_fetch_assoc($res))) 102 printf("[017] [%d] %s\n", mysqli_error($link), mysqli_error($link)); 103 $num = (int)$tmp['num']; 104 mysqli_free_result($res); 105 106 mysqli_stmt_close($stmt); 107 $stmt = mysqli_stmt_init($link); 108 109 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) SELECT id + 10, label FROM test") || 110 !mysqli_stmt_execute($stmt)) 111 printf("[018] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 112 113 if ($num !== ($tmp = mysqli_stmt_affected_rows($stmt))) 114 printf("[019] Expecting int/%d, got %s/%s\n", $num, gettype($tmp), $tmp); 115 116 mysqli_stmt_close($stmt); 117 $stmt = mysqli_stmt_init($link); 118 119 if (!mysqli_stmt_prepare($stmt, "REPLACE INTO test(id, label) values (4, 'd')") || 120 !mysqli_stmt_execute($stmt)) 121 printf("[020] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 122 123 if (2 !== ($tmp = mysqli_stmt_affected_rows($stmt))) 124 printf("[021] Expecting int/2, got %s/%s\n", gettype($tmp), $tmp); 125 126 mysqli_stmt_close($stmt); 127 $stmt = mysqli_stmt_init($link); 128 129 if (!mysqli_stmt_prepare($stmt, "REPLACE INTO test(id, label) values (5, 'e')") || 130 !mysqli_stmt_execute($stmt)) 131 printf("[022] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 132 133 if (1 !== ($tmp = mysqli_stmt_affected_rows($stmt))) 134 printf("[023] Expecting int/1, got %s/%s\n", gettype($tmp), $tmp); 135 136 mysqli_stmt_close($stmt); 137 $stmt = mysqli_stmt_init($link); 138 139 if (!mysqli_stmt_prepare($stmt, "UPDATE test SET label = 'a' WHERE id = 2") || 140 !mysqli_stmt_execute($stmt)) 141 printf("[024] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 142 143 if (1 !== ($tmp = mysqli_stmt_affected_rows($stmt))) 144 printf("[025] Expecting int/1, got %s/%s\n", gettype($tmp), $tmp); 145 146 if (!mysqli_stmt_prepare($stmt, "UPDATE test SET label = 'a' WHERE id = 2") || 147 !mysqli_stmt_execute($stmt)) 148 printf("[026] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 149 150 if (0 !== ($tmp = mysqli_stmt_affected_rows($stmt))) 151 printf("[027] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp); 152 153 mysqli_stmt_close($stmt); 154 $stmt = mysqli_stmt_init($link); 155 156 if (!mysqli_stmt_prepare($stmt, "UPDATE test SET label = 'a' WHERE id = 100") || 157 !mysqli_stmt_execute($stmt)) 158 printf("[028] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 159 160 if (1 !== ($tmp = mysqli_stmt_affected_rows($stmt))) 161 printf("[029] Expecting int/1, got %s/%s\n", gettype($tmp), $tmp); 162 163 if (!mysqli_stmt_prepare($stmt, 'SELECT label FROM test WHERE id = 100') || 164 !mysqli_stmt_execute($stmt)) 165 printf("[030] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 166 167 /* use it like num_rows */ 168 /* PS are unbuffered, num_rows cannot determine the row count before all rows have been fetched and/or buffered */ 169 if (-1 !== ($tmp = mysqli_stmt_affected_rows($stmt))) 170 printf("[031] Expecting int/-1, got %s/%s\n", gettype($tmp), $tmp); 171 172 if (0 !== ($tmp = mysqli_stmt_num_rows($stmt))) 173 printf("[032] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp); 174 175 if (!mysqli_stmt_store_result($stmt)) 176 printf("[033] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 177 178 if (1 !== ($tmp = mysqli_stmt_affected_rows($stmt))) 179 printf("[034] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp); 180 181 if (1 !== ($tmp = mysqli_stmt_num_rows($stmt))) 182 printf("[035] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp); 183 184 mysqli_stmt_free_result($stmt); 185 mysqli_stmt_close($stmt); 186 $stmt = mysqli_stmt_init($link); 187 188 if (!mysqli_stmt_prepare($stmt, 'SELECT label FROM test WHERE 1 = 2') || 189 !mysqli_stmt_execute($stmt)) 190 printf("[036] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 191 192 /* use it like num_rows */ 193 if (-1 !== ($tmp = mysqli_stmt_affected_rows($stmt))) 194 printf("[037] Expecting int/-1, got %s/%s\n", gettype($tmp), $tmp); 195 196 if (true !== ($tmp = mysqli_stmt_store_result($stmt))) 197 printf("[038] Expecting boolean/true, got %s\%s\n", gettype($tmp), $tmp); 198 199 if (0 !== ($tmp = mysqli_stmt_num_rows($stmt))) 200 printf("[039] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp); 201 202 if (0 !== ($tmp = mysqli_stmt_affected_rows($stmt))) 203 printf("[040] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp); 204 205 /* try to use stmt_affected_rows like stmt_num_rows */ 206 /* stmt_affected_rows is not really meant for SELECT! */ 207 if (mysqli_stmt_prepare($stmt, 'SELECT unknown_column FROM this_table_does_not_exist') || 208 mysqli_stmt_execute($stmt)) 209 printf("[041] The invalid SELECT statement is issued on purpose\n"); 210 211 if (-1 !== ($tmp = mysqli_stmt_affected_rows($stmt))) 212 printf("[042] Expecting int/-1, got %s/%s\n", gettype($tmp), $tmp); 213 214 if ($IS_MYSQLND) { 215 if (false !== ($tmp = mysqli_stmt_store_result($stmt))) 216 printf("[043] Expecting boolean/false, got %s\%s\n", gettype($tmp), $tmp); 217 } else { 218 if (true !== ($tmp = mysqli_stmt_store_result($stmt))) 219 printf("[043] Libmysql does not care if the previous statement was bogus, expecting boolean/true, got %s\%s\n", gettype($tmp), $tmp); 220 } 221 222 if (0 !== ($tmp = mysqli_stmt_num_rows($stmt))) 223 printf("[044] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp); 224 225 if (-1 !== ($tmp = mysqli_stmt_affected_rows($stmt))) 226 printf("[045] Expecting int/-1, got %s/%s\n", gettype($tmp), $tmp); 227 228 mysqli_stmt_close($stmt); 229 $stmt = mysqli_stmt_init($link); 230 231 if (!mysqli_stmt_prepare($stmt, "DROP TABLE IF EXISTS test") || 232 !mysqli_stmt_execute($stmt)) 233 printf("[046] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 234 235 mysqli_stmt_close($stmt); 236 237 if (false !== ($tmp = mysqli_stmt_affected_rows($stmt))) 238 printf("[047] Expecting false, got %s/%s\n", gettype($tmp), $tmp); 239 240 mysqli_close($link); 241 242 print "done!"; 243?> 244--CLEAN-- 245<?php 246 require_once("clean_table.inc"); 247?> 248--EXPECTF-- 249[009] [%d] (error message varies with the MySQL Server version, check the error code) 250 251Warning: mysqli_stmt_affected_rows(): Couldn't fetch mysqli_stmt in %s on line %d 252done! 253
