xref: /php-src/ext/pgsql/tests/17result.phpt (revision c15988aa) 
1--TEST--
2PostgreSQL pg_fetch_*() functions
3--EXTENSIONS--
4pgsql
5--SKIPIF--
6<?php include("inc/skipif.inc"); ?>
7--FILE--
8<?php
9error_reporting(E_ALL);
10
11include 'inc/config.inc';
12$table_name = "table_17result";
13
14$db = pg_connect($conn_str);
15pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)");
16pg_query($db, "INSERT INTO {$table_name} VALUES(1, 'ABC', null)");
17pg_query($db, "INSERT INTO {$table_name} VALUES(1, 'ABC', null)");
18
19$sql = "SELECT * FROM $table_name ORDER BY num";
20$result = pg_query($db, $sql) or die('Cannot query db');
21$rows = pg_num_rows($result);
22
23var_dump(pg_result_seek($result, 1));
24var_dump(pg_fetch_object($result));
25var_dump(pg_fetch_array($result, 1));
26var_dump(pg_fetch_row($result, 1));
27var_dump(pg_fetch_assoc($result, 1));
28var_dump(pg_result_seek($result, 0));
29
30echo "Ok\n";
31?>
32--CLEAN--
33<?php
34include('inc/config.inc');
35$table_name = "table_17result";
36
37$db = pg_connect($conn_str);
38pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
39?>
40--EXPECTF--
41bool(true)
42object(stdClass)#%d (3) {
43  ["num"]=>
44  string(1) "1"
45  ["str"]=>
46  string(3) "ABC"
47  ["bin"]=>
48  NULL
49}
50array(6) {
51  [0]=>
52  string(1) "1"
53  ["num"]=>
54  string(1) "1"
55  [1]=>
56  string(3) "ABC"
57  ["str"]=>
58  string(3) "ABC"
59  [2]=>
60  NULL
61  ["bin"]=>
62  NULL
63}
64array(3) {
65  [0]=>
66  string(1) "1"
67  [1]=>
68  string(3) "ABC"
69  [2]=>
70  NULL
71}
72array(3) {
73  ["num"]=>
74  string(1) "1"
75  ["str"]=>
76  string(3) "ABC"
77  ["bin"]=>
78  NULL
79}
80bool(true)
81Ok
82