045.phpt 1.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253
  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. require_once("connect.inc");
  9. $link = my_mysqli_connect($host, $user, $passwd);
  10. $stmt = mysqli_prepare($link, "SHOW VARIABLES LIKE 'port'");
  11. mysqli_stmt_execute($stmt);
  12. if (!$stmt->field_count) {
  13. printf("skip SHOW command is not supported in prepared statements.");
  14. }
  15. $stmt->close();
  16. mysqli_close($link);
  17. ?>
  18. --FILE--
  19. <?php
  20. require_once("connect.inc");
  21. /*** test mysqli_connect 127.0.0.1 ***/
  22. $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket);
  23. $stmt = mysqli_prepare($link, "SHOW VARIABLES LIKE 'port'");
  24. mysqli_stmt_execute($stmt);
  25. mysqli_stmt_bind_result($stmt, $c1, $c2);
  26. mysqli_stmt_fetch($stmt);
  27. mysqli_stmt_close($stmt);
  28. if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1) && mysqli_get_server_version($link) < 50000) {
  29. /* variables are binary */
  30. settype($c1, "unicode");
  31. settype($c2, "unicode");
  32. }
  33. $test = array ($c1,$c2);
  34. var_dump($test);
  35. mysqli_close($link);
  36. print "done!";
  37. ?>
  38. --EXPECTF--
  39. array(2) {
  40. [0]=>
  41. %unicode|string%(4) "port"
  42. [1]=>
  43. %unicode|string%(%d) "%s"
  44. }
  45. done!