Pasted

<html>
 
<head>
<title>Test</title>
</head>
 
<body bgcolor="white">
 
<?php
$link = pg_connect("host=db_host.org port=5432 dbname=db_name user=your_username password=your_password");
$result = pg_exec($link, "select * from some_table");
$numrows = pg_numrows($result);
echo "<p>link = $link<br>
result = $result<br>
numrows = $numrows</p>
";
?>
 
<table border="1">
<tr>
<th>Last name</th>
<th>First name</th>
<th>ID</th>
</tr>
<?php
 
// Loop on rows in the result set.
 
for($ri = 0; $ri < $numrows; $ri++) {
echo "<tr>\n";
$row = pg_fetch_array($result, $ri);
echo " <td>", $row["first_name"], "</td>
<td>", $row["last_name"], "</td>
<td>", $row["id"], "</td>
</tr>
";
}
pg_close($link);
?>
</table>
 
</body>
 
</html>