DB Test - PDO
hostname = $curhost";
$dbtype = 'pgsql';
$dbuser = 'Your DBMS username';
$dbpass = 'Your DBMS passord';
$dbname = 'koomen_db';
$dbhost = 'localhost';
if($curhost == 'betaweb.csug.rochester.edu')
// Leave $dbhost off on betaweb
$dsn = "$dbtype:dbname=$dbname";
else
$dsn = "$dbtype:host=$dbhost;dbname=$dbname";
try {
echo 'Establishing DB connection...
';
$dbh = new PDO($dsn, $dbuser, $dbpass);
echo 'Issuing DB query...
';
echo '';
// print column headers
echo '| Name | State | Latitude | Longitude |
';
foreach($dbh->query('SELECT * FROM features LIMIT 5') as $row) {
echo "| ${row['feature_name']} | ${row['state_alpha']} | " .
"${row['prim_lat_dms']} | ${row['prim_long_dms']} |
";
}
echo '
';
$dbh = null;
} catch (PDOException $e) {
print "Error!: " . $e->getMessage() . "
";
die();
}
?>
DONE!