downloads \| documentation \| faq \| getting help \| mailing lists \| reporting bugs \| php.net sites \| links \| my php.net

search for in the

Predefined Constants	PostgreSQL Functions

	Last updated: Thu, 26 Jun 2008

Examples

This simple example shows how to connect, execute a query, print resulting rows and disconnect from a PostgreSQL database.

Example #1 PostgreSQL extension overview example


<?php

// Connecting, selecting database

$dbconn = pg_connect("host=localhost dbname=publishing user=www password=foo")

    or die('Could not connect: ' . pg_last_error());



// Performing SQL query

$query = 'SELECT * FROM authors';

$result = pg_query($query) or die('Query failed: ' . pg_last_error());



// Printing results in HTML

echo "<table>\n";

while ($line = pg_fetch_array($result, null, PGSQL_ASSOC)) {

    echo "\t<tr>\n";

    foreach ($line as $col_value) {

        echo "\t\t<td>$col_value</td>\n";

    }

    echo "\t</tr>\n";

}

echo "</table>\n";



// Free resultset

pg_free_result($result);



// Closing connection

pg_close($dbconn);

?>

add a note User Contributed Notes
Examples

There are no user contributed notes for this page.

Predefined Constants	PostgreSQL Functions

	Last updated: Thu, 26 Jun 2008

This unofficial mirror is operated at: http://phpbuilder.com/
Last updated: Tue Nov 1 20:20:59 2005 EST