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