PHP - Database Connection
<?php
/**
* Created by PhpStorm.
* User: stevet
* Date: 6/15/16
* Time: 8:37 AM
*/
$conn = pg_connect("host=localhost dbname=test user=test password=test");
if (!$conn) {
echo "Can't connect to database\n";
exit;
}
$result = pg_query($conn, "SELECT * FROM demo");
if (!$result) {
echo "A query error occured.\n";
exit;
}
while ($row = pg_fetch_row($result)) {
echo "ID: $row[0] Value: $row[1]";
echo "<br />\n";
}