<?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", $user,
    $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 {
    $query = 'SELECT * FROM faculty where office <= 210';
    echo "query:  $query \n";
    $preparedQuery = $pdo->prepare($query);
    $preparedQuery->execute();
    $result = $preparedQuery->fetchall();
}
catch (Exception $e) {
    echo "error on query:  $query \n";
    echo "exiting \n";
    exit;
}

/* report results */
foreach ($result as $row) {
   echo $row['first'] . " " . $row['last'] . "\n";
}

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

?>