<?php

/*
 * This is slight change from newconn() in the slides.  Instead of always
 * getting a connection we use a static declaration to cause $conn to
 * retain its value across calls.
 *
 * The first call to getconn() will get a connection, save it in $conn,
 * and return it.
 *
 * Subsequent calls will simply return that already-established connection.
 */
function getconn()
{
    static $conn;

    if ($conn)
        return $conn;
        
    if (gethostname() === "cgi-vm.cs.arizona.edu") {
        $dbname = "whm_cs337f13";
        $user = "cs337f13"; $pw = "tednelson";
        $host = "mysql.cs.arizona.edu";
    } else {
        $dbname = "draw";
        $user = "root"; $pw = "";
        $host = "127.0.0.1";
    }
        
    $dsn = "mysql:host=$host;dbname=$dbname"; // Data source name

    $conn = new PDO($dsn, $user, $pw);

    return $conn;
}

function pdo_die($stmt)
{
    var_dump($stmt->errorInfo());
    die("PDO error!");
}