PHP connect PostgreSQL code?

liop12345

Which prawns are there, send them quickly, thanks in advance

qijun2005

<? php
// Connect, select database
$ dbconn = pg_connect ("host = localhost dbname = publishing user = www password = foo")
    or die ('Could not connect:'. pg_last_error ());

// execute SQL query
$ query = 'SELECT * FROM authors';
$ result = pg_query ($ query) or die ('Query failed:'. pg_last_error ());

// Display the result 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";

// release result set
pg_free_result ($ result);

// close the connection
pg_close ($ dbconn);
?>