Annotation of embedaddon/php/ext/mysqli/tests/047.phpt, revision 1.1
1.1 ! misho 1: --TEST--
! 2: mysqli_stmt_result_metadata
! 3: --SKIPIF--
! 4: <?php
! 5: require_once('skipif.inc');
! 6: require_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
! 50: require_once("connect.inc");
! 51: if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
! 52: printf("[c001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
! 53:
! 54: if (!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:
! 57: mysqli_close($link);
! 58: ?>
! 59: --EXPECTF--
! 60: === fetch_fields ===
! 61: array(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 ===
! 123: object(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: }
! 151: object(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 ===
! 181: object(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: }
! 209: object(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: }
! 237: done!
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>