<?php
/**
 * @name MtGox Ticker Script
 * @author Svante Hansson
 * Used to fetch current ticker data using cronjob
 */

require_once('xxx/db.php');
define('MTGOX_TICKER', 'http://data.mtgox.com/api/1/BTCUSD/ticker');

$ch = curl_init(MTGOX_TICKER);

curl_setopt($ch, CURLOPT_USERAGENT, "BitAlerts/0.1");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

$data = curl_exec($ch);
$json = json_decode($data);

if($json->result == 'success')
{
    $stmt = $dbh->prepare('INSERT INTO tbl_ticker_data VALUES(null, NOW(), :last_price, :last_vol)');
    $stmt->bindParam(':last_price', $json->return->last->value, PDO::PARAM_STR);
    $stmt->bindParam(':last_vol', $json->return->vol->value);
    $stmt->execute();
}
?>