<?php if (sizeof($argv) < 2) { print "usage: php Gengi.php <yyyy-mm-dd>\n"; exit; } $dags = $argv[1]; $fields = split('-', $dags); $sdags = $fields[2] . "." . $fields[1] . "." . $fields[0]; $db = pg_connect("host=127.0.0.1 dbname=postgres user=postgres password=superpost"); $data = file_get_contents("http://www.sedlabanki.is/?PageID=289&dagur=" . $sdags); $currency = array("USD", "GBP", "JPY", "CHF"); $s = new SimpleXMLElement($data); pg_query($db, "BEGIN"); foreach ($s->mynt as $mynt) { if ($mynt->myntnafn == "") continue; if (!in_array($mynt->myntnafn, $currency)) continue; $result = pg_insert($db, "gengi", array( "dags" => $dags, "myntnafn" => (string)$mynt->myntnafn, "kaupgengi" => (string)$mynt->kaupgengi, "midgengi" => (string)$mynt->midgengi, "solugengi" => (string)$mynt->solugengi )); if (!$result) { print "Error: " . pg_last_error($db) . "\n"; } } pg_query($db, "COMMIT"); ?>