<?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();
}
?>