oto bardzo niewielki fragmanet xml'a, którego musze pobrac i zapisać do bazy.
- <Betradar>
- <OO>
<Sport>Baseball</Sport>
<Category />
<Tournament>MLB</Tournament>
<Date>2009-08-27T19:05:00</Date>
<AC>1</AC>
<OddsType>2W</OddsType>
- <OddsData>
<HomeTeam>New York Yankees</HomeTeam>
<AwayTeam>Texas Rangers</AwayTeam>
<HomeOdds>1.40</HomeOdds>
<AwayOdds>2.85</AwayOdds>
</OddsData>
</OO>
- <OO>
<Sport>Baseball</Sport>
<Category />
<Tournament>MLB</Tournament>
<Date>2009-08-27T19:05:00</Date>
<AC>1</AC>
<OddsType>Total</OddsType>
- <OddsData>
<HomeTeam>New York Yankees</HomeTeam>
<AwayTeam>Texas Rangers</AwayTeam>
<Totalscore>9.50</Totalscore>
<OverOdds>1.80</OverOdds>
<UnderOdds>1.90</UnderOdds>
</OddsData>
</OO>
- <OO>
<Sport>Cricket</Sport>
<Category />
<Tournament>One Day Internationals</Tournament>
<Date>2009-08-28T11:15:00</Date>
<AC>1</AC>
<OddsType>2W</OddsType>
- <OddsData>
<HomeTeam>Scotland</HomeTeam>
<AwayTeam>Australia</AwayTeam>
<HomeOdds>10.00</HomeOdds>
<AwayOdds>1.02</AwayOdds>
</OddsData>
</OO>
</Betradar>
i teraz by zapisać dane z kategorii sport listuje to wszystko poprzez
$xml = simplexml_load_string($plik_z_xml);
foreach ($xml->OO as $channel ) {
if ($channel->Sport=="Cricket") {
[zapis do bazy]
}
}
jest jakieś szybsze (wydajniejsze) dotarcie do samej kategorii np:Cricket
czekam na sugestie