Welcome aboard! We are happy you are here and wish you good net-raft!
<?php
$host = "host=xxx";
$port = "port=xxx";
$dbname = "dbname=xxx";
$credentials = "user=xxx password=xxx";
$db = pg_connect( "$host $port $dbname $credentials" );
if(!$db){
echo "Error : Unable to open database\n";
} else {
echo "Opened database successfully\n";
}
$sql =<<<EOF
SELECT * from SALARIES;
EOF;
$ret = pg_query($db, $sql);
if(!$ret){
echo pg_last_error($db);
exit;
}
while($row = pg_fetch_row($ret)){
echo "ID = ". $row[0] . "\n";
echo "NAME = ". $row[1] ."\n";
echo "ADDRESS = ". $row[2] ."\n";
echo "SALARY = ".$row[4] ."\n\n";
}
echo "Operation done successfully\n";
pg_close($db);
?>
The most helpful PHP solutions
detect browser phpPHP Click to see more ... 4.6K 408