#!/usr/bin/php
<?


function fatal_error($msg) {
        echo('fatal: '.$msg."\n");
        exit -1;
}

function curl_safe_setopt($ch, $option, $value) {
        if (!curl_setopt($ch, $option, $value)) fatal_error('curl_setopt(): '.curl_error($ch));
}


if (!($ch = curl_init())) fatal_error('curl_init() failed');

curl_safe_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1)');
curl_safe_setopt($ch, CURLOPT_FOLLOWLOCATION, FALSE);
curl_safe_setopt($ch, CURLOPT_AUTOREFERER, true);
curl_safe_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_safe_setopt($ch, CURLOPT_FAILONERROR, true);

curl_safe_setopt($ch, CURLOPT_HTTPGET, true);
curl_safe_setopt($ch, CURLOPT_URL, 'https://www.bitstamp.net/api/transactions/?timedelta=70');
curl_safe_setopt($ch, CURLOPT_CONNECTTIMEOUT, 4);

$ret = curl_exec($ch);
if (!$ret) exit -1;

$json = json_decode($ret);

mysql_connect('localhost', 'trading', 'Q46XmtzATKnMGu3Z');
mysql_select_db('trading');

foreach ($json as $tx) {
	if (!mysql_query("INSERT INTO transactions ( tid, date, price, amount ) VALUES ( {$tx->tid}, {$tx->date}, {$tx->price}, {$tx->amount} )")) die(mysql_error()); 

}


?>