<?php
$dbconn
= pg_connect("host=localhost
dbname=publishing user=postgres password=foo
port=5432")
or
die('Could not connect: '
. pg_last_error());
$query = 'SELECT * FROM
authors';
$result =
pg_query($query) or die('Query failed:
' . pg_last_error());
echo "<table>n";
while ($line = pg_fetch_array($result, null, PGSQL_ASSOC)) {
echo
"t<tr>n";
foreach
($line as $col_value) {
echo "tt<td>$col_value</td>n";
}
echo
"t</tr>n";
}
echo "</table>n";
pg_free_result($result);
pg_close($dbconn);
?>
请发表评论