在用XML提取XML格式的欧洲央行汇率时遇到了一些麻烦.完整的源代码有问题

我需要获取一个内部会计系统的历史汇率参考汇率列表。

这个问题是关于下面的代码，如果你觉得它有用，可以随意使用这段代码(当然，一旦我们得到了解决最终"琐碎"的答案)。我在代码中包含了一个DB结构转储，所有DB例程都被注释掉了，现在只是回显调试数据。

数据来自欧洲中央银行的XML，网址为http://www.ecb.europa.eu/stats/eurofxref/eurofxref-hist.xml

固定!如果您需要将历史汇率值列表拉入数据库，请随意使用此代码。确保删除echo调试并整理DB查询

<?php
/* DB structure:
 CREATE TABLE IF NOT EXISTS `currency_rates_history` (
  `id` int(4) NOT NULL auto_increment,
  `currency` char(3) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `rate` float NOT NULL default '0',
  `date` int(4) NOT NULL default '0',
  `est` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8_unicode_ci AUTO_INCREMENT=1 ;
*/
error_reporting(E_ALL);
$table = "currency_rates_history";
$secs = '86400';
$prev_date = time();
$days = "0";
$XML=simplexml_load_file("http://www.ecb.europa.eu/stats/eurofxref/eurofxref-hist.xml");    // European Central Bank xml only contains business days! oh well....

foreach($XML->Cube->Cube as $time)                                                          // run first loop for each date section
{
    echo "<h1>".$time["time"].'</h1>';
    list($dy,$dm,$dd) = explode("-", $time["time"]);
    $date = mktime(8,0,0,$dm,$dd,$dy);
    echo ($prev_date - $date)."<br />";
    if(($prev_date - $date) > $secs)                                                        // detect missing weekend and bank holiday values.
    {
        echo "ooh";                                                                         // for debug to search the output for missing days
        $days =(round((($prev_date - $date)/$secs),0)-1);                                   // got to remove 1 from the count....
        echo $days;                                                                         // debug, will output the number of missing days
    }
    foreach($time->Cube as $_rate)                                              // That fixed it! run the 2nd loop and ad enter the new exchange values....
    {
        $rate = floatval(str_replace(",", ".", $_rate["rate"]));

        if($days > 0)                                                                       // add the missing dates using the last known value, coul dbe more accurate but at least there is some reference data to work with
        {
            $days_cc = $days;                                                               // need to keep $days in mem for the next currency
            while($days_cc > 0)
            {
                echo $rate;
                echo date('D',$date+($days_cc*$secs))."<br />";
                /*
                mysql_query("LOCK TABLES {$table} WRITE");
                mysql_query("INSERT INTO {$table}(rate,date,currency,est) VALUES('{$rate}','".($date+($days_cc*$secs))."','{$currency}','1')");
                mysql_query("UNLOCK TABLES");
                */
                $days_cc = ($days_cc - 1);  // count down
            }
        }
        $currency = addslashes(strtolower($_rate["currency"]));
        /*
        mysql_query("LOCK TABLES {$table} WRITE");
//      mysql_query("UPDATE {$table} SET rate='{$rate}',date='{$date}' WHERE currency='{$currency}' AND date='{$date}'");   // all this double checking was crashing the script
//      if (mysql_affected_rows() == 0)
//      {
            mysql_query("INSERT INTO {$table}(rate,date,currency) VALUES('{$rate}','{$date}','{$currency}')");              // so just insert, its only going to be run once anyway!
//      }
        mysql_query("UNLOCK TABLES");
        */
        echo "1&euro;=  ".$currency."   ".$rate.", date:   ".date('D d m Y',$date)."<br/>";
    }
          $days="";                                                                         // clear days value
    $prev_date = $date;                                                                     // store the previous date
}
echo "<h1>Currencies Saved!</h1>";
?>

所以…问题是在第二个foreach循环:foreach($XML->Cube->Cube->Cube as $_rate)，如果你试着运行脚本，你会注意到日期是正确的，它处理丢失的周末和银行假日日期很好，但汇率值只引用XML中的最新汇率，即今天的值。

它应该从XML中的相关区域提取数据，即给定日期的费率…但事实并非如此。这是simplexml_load_file中的问题还是我在代码中错过了一些愚蠢的东西?现在头开始疼了，所以要休息一下。新鲜的眼睛是最受欢迎的!