<?php
// database access parameters
// alter this as per your configuration
$host = "localhost";
$user = "manas237";
$pass = "pwmanas237";
$db = "pgsdemo1";
// open a connection to the database server
$dbconn = pg_connect ("host=$host dbname=$db user=$user password=$pass");
if (!$dbconn)
{
die("Could not open connection to database server");
}
echo "connection successful <br/>";

$result = pg_query($dbconn, "SELECT * FROM emp1 ORDER BY fname");
if (!$result) {
echo "An error occured.\n";
exit;
}

while ($row = pg_fetch_row($result)) {
echo "fname: $row[0] lname: $row[1]";
echo "<br />\n";
}
pg_close($dbconn);
?>