View source for PHP - Database Connection

<syntaxhighlight lang="php" line='line'>
<?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";
}
</syntaxhighlight>