How to parse the data

Regular expression example

<?php
//This is a PHP(4/5) script example on how eurofxref-daily.xml can be parsed
//Read eurofxref-daily.xml file in memory
//For this command you will need the config option allow_url_fopen=On (default)
$XMLContent=file(" http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml");
//the file is updated daily between 2.15 p.m. and 3.00 p.m. CET

foreach($XMLContent as $line){
if(preg_match("/currency='([[:alpha:]]+)'/",$line,$currencyCode)){
if(preg_match("/rate='([[:graph:]]+)'/",$line,$rate)){
//Output the value of 1EUR for a currency code
echo'1€='.$rate[1].' '.$currencyCode[1].'<br/>';
//--------------------------------------------------
//Here you can add your code for inserting
//$rate[1] and $currencyCode[1] into your database
//--------------------------------------------------
}
}
}
?>
XML parser example

<?php
function StartElement($parser, $name, $attrs) {
if (!empty($attrs['RATE'])) {
echo "1€=".$attrs['RATE']." ".$attrs['CURRENCY']."<br />";
}
}
$xml_parser= xml_parser_create();
xml_set_element_handler($xml_parser, "StartElement", "");
// for the following command you will need file_get_contents (PHP >= 4.3.0)
// and the config option allow_url_fopen=On (default)
xml_parse($xml_parser, file_get_contents (" http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml"));
xml_parser_free($xml_parser);
?>
SimpleXML example

<?php
//This is aPHP(5)script example on how eurofxref-daily.xml can be parsed
//Read eurofxref-daily.xml file in memory
//For the next command you will need the config option allow_url_fopen=On (default)
$XML=simplexml_load_file(" http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml");
//the file is updated daily between 2.15 p.m. and 3.00 p.m. CET

foreach($XML->Cube->Cube->Cube as $rate){
//Output the value of 1EUR for a currency code
echo '1€='.$rate["rate"].' '.$rate["currency"].'<br/>';
//--------------------------------------------------
//Here you can add your code for inserting
//$rate["rate"] and $rate["currency"] into your database
//--------------------------------------------------
}
?>

1€=1.3448 USD
1€=102.59 JPY
1€=1.9558 BGN
1€=24.878 CZK
1€=7.4458 DKK
1€=0.87325 GBP
1€=293.06 HUF
1€=3.4528 LTL
1€=0.7093 LVL
1€=4.4863 PLN
1€=4.3055 RON
1€=9.2762 SEK
1€=1.2275 CHF
1€=7.8270 NOK
1€=7.4845 HRK
1€=43.2059 RUB
1€=2.4636 TRY
1€=1.3691 AUD
1€=2.4887 BRL
1€=1.3894 CAD
1€=8.6040 CNY
1€=10.4904 HKD
1€=12246.50 IDR
1€=4.9945 ILS
1€=66.6720 INR
1€=1605.66 KRW
1€=18.6738 MXN
1€=4.2744 MYR
1€=1.7185 NZD
1€=58.919 PHP
1€=1.7547 SGD
1€=41.379 THB
1€=11.0754 ZAR

<?xml version="1.0" encoding="UTF-8"?>
-<gesmes:Envelope xmlns=" http://www.ecb.int/vocabulary/2002-08-01/eurofxref" xmlns:gesmes=" http://www.gesmes.org/xml/2002-08-01"> <gesmes:subject>Reference rates</gesmes:subject> -<gesmes:Sender> <gesmes:name>European Central Bank</gesmes:name> </gesmes:Sender> -<Cube> -<Cube time="2011-09-22"> <Cube rate="1.3448" currency="USD"/> <Cube rate="102.59" currency="JPY"/> <Cube rate="1.9558" currency="BGN"/> <Cube rate="24.878" currency="CZK"/> <Cube rate="7.4458" currency="DKK"/> <Cube rate="0.87325" currency="GBP"/> <Cube rate="293.06" currency="HUF"/> <Cube rate="3.4528" currency="LTL"/> <Cube rate="0.7093" currency="LVL"/> <Cube rate="4.4863" currency="PLN"/> <Cube rate="4.3055" currency="RON"/> <Cube rate="9.2762" currency="SEK"/> <Cube rate="1.2275" currency="CHF"/> <Cube rate="7.8270" currency="NOK"/> <Cube rate="7.4845" currency="HRK"/> <Cube rate="43.2059" currency="RUB"/> <Cube rate="2.4636" currency="TRY"/> <Cube rate="1.3691" currency="AUD"/> <Cube rate="2.4887" currency="BRL"/> <Cube rate="1.3894" currency="CAD"/> <Cube rate="8.6040" currency="CNY"/> <Cube rate="10.4904" currency="HKD"/> <Cube rate="12246.50" currency="IDR"/> <Cube rate="4.9945" currency="ILS"/> <Cube rate="66.6720" currency="INR"/> <Cube rate="1605.66" currency="KRW"/> <Cube rate="18.6738" currency="MXN"/> <Cube rate="4.2744" currency="MYR"/> <Cube rate="1.7185" currency="NZD"/> <Cube rate="58.919" currency="PHP"/> <Cube rate="1.7547" currency="SGD"/> <Cube rate="41.379" currency="THB"/> <Cube rate="11.0754" currency="ZAR"/> </Cube> </Cube> </gesmes:Envelope>