Annotation of embedaddon/php/ext/mysqli/tests/045.phpt, revision 1.1
1.1 ! misho 1: --TEST--
! 2: mysqli_stmt_bind_result (SHOW)
! 3: --SKIPIF--
! 4: <?php
! 5: require_once('skipif.inc');
! 6: require_once('skipifemb.inc');
! 7: require_once('skipifconnectfailure.inc');
! 8:
! 9: require_once("connect.inc");
! 10: $link = my_mysqli_connect($host, $user, $passwd);
! 11:
! 12: $stmt = mysqli_prepare($link, "SHOW VARIABLES LIKE 'port'");
! 13: mysqli_stmt_execute($stmt);
! 14:
! 15: if (!$stmt->field_count) {
! 16: printf("skip SHOW command is not supported in prepared statements.");
! 17: }
! 18: $stmt->close();
! 19: mysqli_close($link);
! 20: ?>
! 21: --FILE--
! 22: <?php
! 23: require_once("connect.inc");
! 24:
! 25: /*** test mysqli_connect 127.0.0.1 ***/
! 26: $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket);
! 27:
! 28: $stmt = mysqli_prepare($link, "SHOW VARIABLES LIKE 'port'");
! 29: mysqli_stmt_execute($stmt);
! 30:
! 31: mysqli_stmt_bind_result($stmt, $c1, $c2);
! 32: mysqli_stmt_fetch($stmt);
! 33: mysqli_stmt_close($stmt);
! 34: if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1) && mysqli_get_server_version($link) < 50000) {
! 35: /* variables are binary */
! 36: settype($c1, "unicode");
! 37: settype($c2, "unicode");
! 38: }
! 39: $test = array ($c1,$c2);
! 40:
! 41: var_dump($test);
! 42:
! 43: mysqli_close($link);
! 44: print "done!";
! 45: ?>
! 46: --EXPECTF--
! 47: array(2) {
! 48: [0]=>
! 49: %unicode|string%(4) "port"
! 50: [1]=>
! 51: %unicode|string%(%d) "%s"
! 52: }
! 53: done!
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>