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 ''; foreach($dbh->query('SELECT * FROM features LIMIT 5') as $row) { echo "" . ""; } echo '
NameStateLatitudeLongitude
${row['feature_name']}${row['state_alpha']}${row['prim_lat_dms']}${row['prim_long_dms']}
'; $dbh = null; } catch (PDOException $e) { print "Error!: " . $e->getMessage() . "
"; die(); } ?>

DONE!