<?php

/*
 * Sketch showing how we might update wins for a player
 */

$who = $_GET["winner"];

$data = load_player_data($who);

$data["wins"] += 1;

echo "{$data['wins']} wins for $who";

save_player_data($who, $data);

#var_dump($data);

function load_player_data($name)
{
    $conn = newconn();
    $stmt = $conn->prepare("select data from players where name=:name");
    $stmt->bindParam(":name", $name);
    $result = $stmt->execute();
    if (!$result) pdo_die($stmt);
    
    $rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
    assert(count($rows) == 1);
    
    $data = unserialize($rows[0]["data"]);

    return $data;
}

function save_player_data($name, $data)
{
    $conn = newconn();
    $stmt = $conn->prepare("update players set data=:data where name=:name");
    $stmt->bindParam(":name", $name);
    $stmt->bindParam(":data", serialize($data));
    $result = $stmt->execute();
    if (!$result) pdo_die($stmt);
    
    assert($stmt->rowCount() == 1);
}


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;
}

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