mysqli_field_tell.phpt 1.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899
  1. --TEST--
  2. mysqli_field_tell()
  3. --EXTENSIONS--
  4. mysqli
  5. --SKIPIF--
  6. <?php
  7. require_once('skipifconnectfailure.inc');
  8. ?>
  9. --FILE--
  10. <?php
  11. require_once("connect.inc");
  12. require('table.inc');
  13. if (!$res = mysqli_query($link, "SELECT id FROM test ORDER BY id LIMIT 1", MYSQLI_USE_RESULT)) {
  14. printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
  15. }
  16. var_dump(mysqli_field_tell($res));
  17. var_dump(mysqli_field_tell($res));
  18. var_dump(mysqli_fetch_field($res));
  19. var_dump(mysqli_fetch_field($res));
  20. var_dump(mysqli_field_tell($res));
  21. try {
  22. var_dump(mysqli_field_seek($res, 2));
  23. } catch (\ValueError $e) {
  24. echo $e->getMessage() . \PHP_EOL;
  25. }
  26. var_dump(mysqli_field_tell($res));
  27. try {
  28. var_dump(mysqli_field_seek($res, -1));
  29. } catch (\ValueError $e) {
  30. echo $e->getMessage() . \PHP_EOL;
  31. }
  32. var_dump(mysqli_field_tell($res));
  33. var_dump(mysqli_field_seek($res, 0));
  34. var_dump(mysqli_field_tell($res));
  35. mysqli_free_result($res);
  36. try {
  37. mysqli_field_tell($res);
  38. } catch (Error $exception) {
  39. echo $exception->getMessage() . "\n";
  40. }
  41. mysqli_close($link);
  42. print "done!";
  43. ?>
  44. --CLEAN--
  45. <?php
  46. require_once("clean_table.inc");
  47. ?>
  48. --EXPECTF--
  49. int(0)
  50. int(0)
  51. object(stdClass)#%d (13) {
  52. ["name"]=>
  53. string(2) "id"
  54. ["orgname"]=>
  55. string(2) "id"
  56. ["table"]=>
  57. string(4) "test"
  58. ["orgtable"]=>
  59. string(4) "test"
  60. ["def"]=>
  61. string(0) ""
  62. ["db"]=>
  63. string(%d) "%s"
  64. ["catalog"]=>
  65. string(%d) "%s"
  66. ["max_length"]=>
  67. int(0)
  68. ["length"]=>
  69. int(11)
  70. ["charsetnr"]=>
  71. int(63)
  72. ["flags"]=>
  73. int(49155)
  74. ["type"]=>
  75. int(3)
  76. ["decimals"]=>
  77. int(0)
  78. }
  79. bool(false)
  80. int(1)
  81. mysqli_field_seek(): Argument #2 ($index) must be less than the number of fields for this result set
  82. int(1)
  83. mysqli_field_seek(): Argument #2 ($index) must be greater than or equal to 0
  84. int(1)
  85. bool(true)
  86. int(0)
  87. mysqli_result object is already closed
  88. done!