mysqli_fetch_array_assoc.phpt 1019 B

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849
  1. --TEST--
  2. mysqli_fetch_array()
  3. --SKIPIF--
  4. <?php
  5. require_once('skipif.inc');
  6. require_once('skipifemb.inc');
  7. require_once('skipifconnectfailure.inc');
  8. ?>
  9. --FILE--
  10. <?php
  11. require('table.inc');
  12. if (!$res = mysqli_query($link, "SELECT * FROM test ORDER BY id LIMIT 5")) {
  13. printf("[001] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
  14. }
  15. print "[002]\n";
  16. var_dump(mysqli_fetch_array($res, MYSQLI_ASSOC));
  17. mysqli_free_result($res);
  18. if (!$res = mysqli_query($link, "SELECT id, label FROM test ORDER BY id LIMIT 5")) {
  19. printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
  20. }
  21. print "[004]\n";
  22. var_dump(mysqli_fetch_array($res, MYSQLI_ASSOC));
  23. mysqli_free_result($res);
  24. mysqli_close($link);
  25. print "done!";
  26. ?>
  27. --CLEAN--
  28. <?php
  29. require_once("clean_table.inc");
  30. ?>
  31. --EXPECTF--
  32. [002]
  33. array(2) {
  34. [%u|b%"id"]=>
  35. %unicode|string%(1) "1"
  36. [%u|b%"label"]=>
  37. %unicode|string%(1) "a"
  38. }
  39. [004]
  40. array(2) {
  41. [%u|b%"id"]=>
  42. %unicode|string%(1) "1"
  43. [%u|b%"label"]=>
  44. %unicode|string%(1) "a"
  45. }
  46. done!