045.phpt 1.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. --TEST--
  2. mysqli_stmt_bind_result (SHOW)
  3. --EXTENSIONS--
  4. mysqli
  5. --SKIPIF--
  6. <?php
  7. require_once('skipifconnectfailure.inc');
  8. require_once("connect.inc");
  9. $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket);
  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. $test = array ($c1,$c2);
  29. var_dump($test);
  30. mysqli_close($link);
  31. print "done!";
  32. ?>
  33. --EXPECTF--
  34. array(2) {
  35. [0]=>
  36. string(4) "port"
  37. [1]=>
  38. string(%d) "%s"
  39. }
  40. done!