1--TEST-- 2mysqli_stmt_result_metadata 3--SKIPIF-- 4<?php 5require_once('skipif.inc'); 6require_once('skipifconnectfailure.inc'); 7?> 8--FILE-- 9<?php 10 require_once("connect.inc"); 11 12 /*** test mysqli_connect 127.0.0.1 ***/ 13 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 14 15 mysqli_select_db($link, $db); 16 17 mysqli_query($link, "DROP TABLE IF EXISTS test_affected"); 18 mysqli_query($link, "CREATE TABLE test_affected (foo int, bar varchar(10) character set latin1) ENGINE=" . $engine); 19 20 mysqli_query($link, "INSERT INTO test_affected VALUES (1, 'Zak'),(2, 'Greant')"); 21 22 $stmt = mysqli_prepare($link, "SELECT * FROM test_affected"); 23 mysqli_stmt_execute($stmt); 24 $result = mysqli_stmt_result_metadata($stmt); 25 26 echo "\n=== fetch_fields ===\n"; 27 var_dump(mysqli_fetch_fields($result)); 28 29 echo "\n=== fetch_field_direct ===\n"; 30 var_dump(mysqli_fetch_field_direct($result, 0)); 31 var_dump(mysqli_fetch_field_direct($result, 1)); 32 33 echo "\n=== fetch_field ===\n"; 34 while ($field = mysqli_fetch_field($result)) { 35 var_dump($field); 36 } 37 38 print_r(mysqli_fetch_lengths($result)); 39 40 mysqli_free_result($result); 41 42 43 mysqli_stmt_close($stmt); 44 mysqli_query($link, "DROP TABLE IF EXISTS test_affected"); 45 mysqli_close($link); 46 print "done!"; 47?> 48--CLEAN-- 49<?php 50require_once("connect.inc"); 51if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) 52 printf("[c001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error()); 53 54if (!mysqli_query($link, "DROP TABLE IF EXISTS test_affected")) 55 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 56 57mysqli_close($link); 58?> 59--EXPECTF-- 60=== fetch_fields === 61array(2) { 62 [0]=> 63 object(stdClass)#5 (13) { 64 [%u|b%"name"]=> 65 %unicode|string%(3) "foo" 66 [%u|b%"orgname"]=> 67 %unicode|string%(3) "foo" 68 [%u|b%"table"]=> 69 %unicode|string%(13) "test_affected" 70 [%u|b%"orgtable"]=> 71 %unicode|string%(13) "test_affected" 72 [%u|b%"def"]=> 73 %unicode|string%(0) "" 74 [%u|b%"db"]=> 75 %unicode|string%(%d) "%s" 76 [%u|b%"catalog"]=> 77 %unicode|string%(%d) "%s" 78 [%u|b%"max_length"]=> 79 int(0) 80 [%u|b%"length"]=> 81 int(%d) 82 [%u|b%"charsetnr"]=> 83 int(%d) 84 [%u|b%"flags"]=> 85 int(32768) 86 [%u|b%"type"]=> 87 int(3) 88 [%u|b%"decimals"]=> 89 int(0) 90 } 91 [1]=> 92 object(stdClass)#6 (13) { 93 [%u|b%"name"]=> 94 %unicode|string%(3) "bar" 95 [%u|b%"orgname"]=> 96 %unicode|string%(3) "bar" 97 [%u|b%"table"]=> 98 %unicode|string%(13) "test_affected" 99 [%u|b%"orgtable"]=> 100 %unicode|string%(13) "test_affected" 101 [%u|b%"def"]=> 102 %unicode|string%(0) "" 103 [%u|b%"db"]=> 104 %unicode|string%(%d) "%s" 105 [%u|b%"catalog"]=> 106 %unicode|string%(%d) "%s" 107 [%u|b%"max_length"]=> 108 int(0) 109 [%u|b%"length"]=> 110 int(%d) 111 [%u|b%"charsetnr"]=> 112 int(%d) 113 [%u|b%"flags"]=> 114 int(0) 115 [%u|b%"type"]=> 116 int(253) 117 [%u|b%"decimals"]=> 118 int(0) 119 } 120} 121 122=== fetch_field_direct === 123object(stdClass)#6 (13) { 124 [%u|b%"name"]=> 125 %unicode|string%(3) "foo" 126 [%u|b%"orgname"]=> 127 %unicode|string%(3) "foo" 128 [%u|b%"table"]=> 129 %unicode|string%(13) "test_affected" 130 [%u|b%"orgtable"]=> 131 %unicode|string%(13) "test_affected" 132 [%u|b%"def"]=> 133 %unicode|string%(0) "" 134 [%u|b%"db"]=> 135 %unicode|string%(%d) "%s" 136 [%u|b%"catalog"]=> 137 %unicode|string%(%d) "%s" 138 [%u|b%"max_length"]=> 139 int(0) 140 [%u|b%"length"]=> 141 int(%d) 142 [%u|b%"charsetnr"]=> 143 int(%d) 144 [%u|b%"flags"]=> 145 int(32768) 146 [%u|b%"type"]=> 147 int(3) 148 [%u|b%"decimals"]=> 149 int(0) 150} 151object(stdClass)#6 (13) { 152 [%u|b%"name"]=> 153 %unicode|string%(3) "bar" 154 [%u|b%"orgname"]=> 155 %unicode|string%(3) "bar" 156 [%u|b%"table"]=> 157 %unicode|string%(13) "test_affected" 158 [%u|b%"orgtable"]=> 159 %unicode|string%(13) "test_affected" 160 [%u|b%"def"]=> 161 %unicode|string%(0) "" 162 [%u|b%"db"]=> 163 %unicode|string%(%d) "%s" 164 [%u|b%"catalog"]=> 165 %unicode|string%(%d) "%s" 166 [%u|b%"max_length"]=> 167 int(0) 168 [%u|b%"length"]=> 169 int(%d) 170 [%u|b%"charsetnr"]=> 171 int(%d) 172 [%u|b%"flags"]=> 173 int(0) 174 [%u|b%"type"]=> 175 int(253) 176 [%u|b%"decimals"]=> 177 int(0) 178} 179 180=== fetch_field === 181object(stdClass)#6 (13) { 182 [%u|b%"name"]=> 183 %unicode|string%(3) "foo" 184 [%u|b%"orgname"]=> 185 %unicode|string%(3) "foo" 186 [%u|b%"table"]=> 187 %unicode|string%(13) "test_affected" 188 [%u|b%"orgtable"]=> 189 %unicode|string%(13) "test_affected" 190 [%u|b%"def"]=> 191 %unicode|string%(0) "" 192 [%u|b%"db"]=> 193 %unicode|string%(%d) "%s" 194 [%u|b%"catalog"]=> 195 %unicode|string%(%d) "%s" 196 [%u|b%"max_length"]=> 197 int(0) 198 [%u|b%"length"]=> 199 int(%d) 200 [%u|b%"charsetnr"]=> 201 int(%d) 202 [%u|b%"flags"]=> 203 int(32768) 204 [%u|b%"type"]=> 205 int(3) 206 [%u|b%"decimals"]=> 207 int(0) 208} 209object(stdClass)#5 (13) { 210 [%u|b%"name"]=> 211 %unicode|string%(3) "bar" 212 [%u|b%"orgname"]=> 213 %unicode|string%(3) "bar" 214 [%u|b%"table"]=> 215 %unicode|string%(13) "test_affected" 216 [%u|b%"orgtable"]=> 217 %unicode|string%(13) "test_affected" 218 [%u|b%"def"]=> 219 %unicode|string%(0) "" 220 [%u|b%"db"]=> 221 %unicode|string%(%d) "%s" 222 [%u|b%"catalog"]=> 223 %unicode|string%(%d) "%s" 224 [%u|b%"max_length"]=> 225 int(0) 226 [%u|b%"length"]=> 227 int(%d) 228 [%u|b%"charsetnr"]=> 229 int(%d) 230 [%u|b%"flags"]=> 231 int(0) 232 [%u|b%"type"]=> 233 int(253) 234 [%u|b%"decimals"]=> 235 int(0) 236} 237done!
