<?php
/*
 * Creates an array representing data for three players and then stores a serialized representation
 * for each in a row in the players table.
 */

$a = array(
 "whm" => array(
    "wins" => 7,
    "losses" => 2,
    "games" => array("+-==--+++","+-=++++++","+-==----+++","+-----===+","+-==---=+++","+-=++++++","+-=--=----+++","+-----+++","+-===+++")
    ),
 "j-than" => array(
    "wins" => 10,
    "losses" => 6,
    "games" => array("==++---+++","+-=++++++","+-==-=====---+++","+-----+++","+-===+++","+-==----+++","+-----===+","+-==---=+++","+-=++++++","+-==----+++","+-----===+","+-==---=+++","+-=++++++")
    ),
 "bruce" => array(
    "wins" => 3,
    "losses" => 1,
    "games" => array("====-+++","+-=++++++","+-==----+++")
    ));

$conn = newconn();

foreach ($a as $name => $data) {
    $sdata = serialize($data);
    $stmt = $conn->prepare("insert into players(name, data)
        values(:name, :sdata)");
    $stmt->bindParam(":name", $name);
    $stmt->bindParam(":sdata", $sdata);
    $result = $stmt->execute();
    if (!$result) {
        var_dump($stmt->errorInfo());
        die("error!");
        }
    }

function newconn()
{
    if (gethostname() === "cgi-vm.cs.arizona.edu") {
        $dbname = "whm_cs337f13";
        $user = "cs337f13"; $pw = "tednelson";
        $host = "mysql.cs.arizona.edu";
    } else {
        $dbname = "serialstore";
        $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;
}