17result.phpt 1007 B

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667
  1. --TEST--
  2. PostgreSQL pg_fetch_*() functions
  3. --SKIPIF--
  4. <?php include("skipif.inc"); ?>
  5. --FILE--
  6. <?php
  7. error_reporting(E_ALL);
  8. include 'config.inc';
  9. $db = pg_connect($conn_str);
  10. $sql = "SELECT * FROM $table_name";
  11. $result = pg_query($db, $sql) or die('Cannot qeury db');
  12. $rows = pg_num_rows($result);
  13. var_dump(pg_result_seek($result, 1));
  14. var_dump(pg_fetch_object($result));
  15. var_dump(pg_fetch_array($result, 1));
  16. var_dump(pg_fetch_row($result, 1));
  17. var_dump(pg_fetch_assoc($result, 1));
  18. var_dump(pg_result_seek($result, 0));
  19. echo "Ok\n";
  20. ?>
  21. --EXPECT--
  22. bool(true)
  23. object(stdClass)#1 (3) {
  24. ["num"]=>
  25. string(1) "1"
  26. ["str"]=>
  27. string(3) "ABC"
  28. ["bin"]=>
  29. NULL
  30. }
  31. array(6) {
  32. [0]=>
  33. string(1) "1"
  34. ["num"]=>
  35. string(1) "1"
  36. [1]=>
  37. string(3) "ABC"
  38. ["str"]=>
  39. string(3) "ABC"
  40. [2]=>
  41. NULL
  42. ["bin"]=>
  43. NULL
  44. }
  45. array(3) {
  46. [0]=>
  47. string(1) "1"
  48. [1]=>
  49. string(3) "ABC"
  50. [2]=>
  51. NULL
  52. }
  53. array(3) {
  54. ["num"]=>
  55. string(1) "1"
  56. ["str"]=>
  57. string(3) "ABC"
  58. ["bin"]=>
  59. NULL
  60. }
  61. bool(true)
  62. Ok