<?php
/* a first program, illustrating how to open, access, and print data
   from a database table, using pdo */

/* establishing a connection to the database */
require "credentials.php"; // for $user and $password
$server   = 'localhost';
$database = 'hwalker';

try {
    $pdo = new PDO("mysql:host=localhost;dbname=$database", $username, $password);
    
    // set the PDO error mode to throw exception when run-time error encountered
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
    // provide as much protection as possible to counteract possible injection attacks
    $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);

}
catch (Exception $e) {
    echo "error connecting to $database \n";
    echo "full error message " . $e->getMessage() . "\n";
    echo "exiting\n";
    exit;
}

echo "connected to database '$database'\n";

/* query the database */
try {
    $sqlQuery = 'SELECT * FROM faculty where office <= 210';
    echo "query:  $sqlQuery \n";
    $result = $pdo->query($sqlQuery);
}
catch (Exception $e) {
    echo "error on query:  $sqlQuery \n";
    echo "error message:  $e->getMessage \n";
    echo "exiting \n";
    exit;
}

/* report results */
while ($row = $result->fetch()) {
   echo $row['first'] . " " . $row['last'] . "\n";
}

/* closing the database connection */
$pdo = null;
echo "database connection closed\n";

?>