mysqli_store_result.phpt 1.9 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364
  1. --TEST--
  2. mysqli_store_result()
  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_once("connect.inc");
  12. $tmp = NULL;
  13. $link = NULL;
  14. if (!is_null($tmp = @mysqli_store_result()))
  15. printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
  16. if (!is_null($tmp = @mysqli_store_result($link)))
  17. printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
  18. require('table.inc');
  19. if (!$res = mysqli_real_query($link, "SELECT id, label FROM test ORDER BY id"))
  20. printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
  21. if (!is_object($res = mysqli_store_result($link)))
  22. printf("[004] Expecting object, got %s/%s. [%d] %s\n",
  23. gettype($res), $res, mysqli_errno($link), mysqli_error($link));
  24. if (true !== ($tmp = mysqli_data_seek($res, 2)))
  25. printf("[005] Expecting boolean/true, got %s/%s. [%d] %s\n",
  26. gettype($tmp), $tmp, mysqli_errno($link), mysqli_error($link));
  27. mysqli_free_result($res);
  28. if (!mysqli_query($link, "DELETE FROM test"))
  29. printf("[006] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
  30. if (false !== ($res = mysqli_store_result($link)))
  31. printf("[007] Expecting boolean/false, got %s/%s. [%d] %s\n",
  32. gettype($res), $res, mysqli_errno($link), mysqli_error($link));
  33. if (!$res = mysqli_query($link, "SELECT id, label FROM test ORDER BY id"))
  34. printf("[008] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
  35. if (false !== ($tmp = mysqli_data_seek($res, 1)))
  36. printf("[009] Expecting boolean/false, got %s/%s\n",
  37. gettype($tmp), $tmp);
  38. mysqli_close($link);
  39. if (NULL !== ($tmp = mysqli_store_result($link)))
  40. printf("[010] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
  41. print "done!";
  42. ?>
  43. --CLEAN--
  44. <?php
  45. require_once("clean_table.inc");
  46. ?>
  47. --EXPECTF--
  48. Warning: mysqli_store_result(): Couldn't fetch mysqli in %s on line %d
  49. done!