12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667 |
- --TEST--
- PostgreSQL pg_fetch_*() functions
- --SKIPIF--
- <?php include("skipif.inc"); ?>
- --FILE--
- <?php
- error_reporting(E_ALL);
- include 'config.inc';
- $db = pg_connect($conn_str);
- $sql = "SELECT * FROM $table_name";
- $result = pg_query($db, $sql) or die('Cannot qeury db');
- $rows = pg_num_rows($result);
- var_dump(pg_result_seek($result, 1));
- var_dump(pg_fetch_object($result));
- var_dump(pg_fetch_array($result, 1));
- var_dump(pg_fetch_row($result, 1));
- var_dump(pg_fetch_assoc($result, 1));
- var_dump(pg_result_seek($result, 0));
- echo "Ok\n";
- ?>
- --EXPECT--
- bool(true)
- object(stdClass)#1 (3) {
- ["num"]=>
- string(1) "1"
- ["str"]=>
- string(3) "ABC"
- ["bin"]=>
- NULL
- }
- array(6) {
- [0]=>
- string(1) "1"
- ["num"]=>
- string(1) "1"
- [1]=>
- string(3) "ABC"
- ["str"]=>
- string(3) "ABC"
- [2]=>
- NULL
- ["bin"]=>
- NULL
- }
- array(3) {
- [0]=>
- string(1) "1"
- [1]=>
- string(3) "ABC"
- [2]=>
- NULL
- }
- array(3) {
- ["num"]=>
- string(1) "1"
- ["str"]=>
- string(3) "ABC"
- ["bin"]=>
- NULL
- }
- bool(true)
- Ok
|