The return value of a call to pg_query() is a pointer to a resultset that can be used with these functions:
Retrieving Data from PostgreSQL (pg_fetch.php; excerpt)<table> <tr><th>#</th><th>Quote</th><th>Author</th><th>Year< /th></tr> <?php if ($db = @pg_connect('host=localhost port=5432 dbname=phrasebook user=postgres password=abc123')) { $result = pg_query($db, 'SELECT * FROM quotes'); while ($row = pg_fetch_row($result)) { vprintf( '<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td></ tr>', $row ); } pg_close($db); } else { echo '<tr><td colspan="4">Connection failed.</td></tr>'; } ?> </table> The code uses pg_fetch_row() to read out all data from the quotes table. Alternatively, pg_select() works similarly to pg_insert() and pg_update(). Just provide a database handle, a table name, and maybe a WHERE clause in the form of an array, and you get the complete resultset as an array of (associative) arrays. $data = pg_select($db, 'quotes'); |