069.phpt 759 B

123456789101112131415161718192021222324252627282930313233343536373839
  1. --TEST--
  2. mysqli multi_query, next_result, more_results
  3. --EXTENSIONS--
  4. mysqli
  5. --SKIPIF--
  6. <?php
  7. require_once('skipifconnectfailure.inc');
  8. ?>
  9. --FILE--
  10. <?php
  11. require_once("connect.inc");
  12. $mysql = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
  13. $mysql->multi_query('SELECT 1;SELECT 2');
  14. do {
  15. $res = $mysql->store_result();
  16. if ($mysql->errno == 0) {
  17. while ($arr = $res->fetch_assoc()) {
  18. var_dump($arr);
  19. }
  20. $res->free();
  21. }
  22. if (!$mysql->more_results()) {
  23. break;
  24. }
  25. } while (@$mysql->next_result());
  26. $mysql->close();
  27. print "done!";
  28. ?>
  29. --EXPECT--
  30. array(1) {
  31. [1]=>
  32. string(1) "1"
  33. }
  34. array(1) {
  35. [2]=>
  36. string(1) "2"
  37. }
  38. done!