PostgreSQL - Use PHP to Output Data in HTML Table

<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>