psql_php_while1.htm
Source code: psql_php_while1.txt
$result = pg_query($dbconn,"SELECT * FROM emp2");
echo "<table >";
while($row=pg_fetch_assoc($result))
{
echo "<tr>";
echo "<td class='td0' align='center' >" . $row['eid'] . "</td>";
echo "<td class='td0' align='center' >" . $row['fname'] . "</td>";
echo "<td class='td0' align='center' >" . $row['lname'] . "</td>";
echo "<td class='td1' align='center' >" . $row['job'] . "</td>";
echo "<td class='td0' align='center' >" . $row['deptno'] . "</td>";
echo "<td class='td2' align='center' >" . $row['hired'] . "</td>";
echo "<td class='td2' align='center' >" . $row['released'] . "</td>";
echo "<td class='td1' align='center' >" . $row['salary'] . "</td>";
echo "<td class='td1' align='center' >" . $row['comm'] . "</td>";
echo "</tr>";
}
echo "</table>";