duży xml Opcje

[grzegorz_g]

oto bardzo niewielki fragmanet xml'a, którego musze pobrac i zapisać do bazy.

[XML] pobierz, plaintext 
 
- <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>
 
[XML] pobierz, plaintext 

i teraz by zapisać dane z kategorii sport listuje to wszystko poprzez

[PHP] pobierz, plaintext 
$xml = simplexml_load_string($plik_z_xml);
foreach ($xml->OO as $channel )        { 
 
if ($channel->Sport=="Cricket") {
[zapis do bazy]
                                               }
 
 
                                                        }
 
 
[PHP] pobierz, plaintext 

jest jakieś szybsze (wydajniejsze) dotarcie do samej kategorii np:Cricket
czekam na sugestie

[grush]

a moze Xpath w simpleXML:

[PHP] pobierz, plaintext 
 
<dwml>
  <data>
    <location>
      <location-key>point1</location-key>
      	<point latitude="37.39" longitude="-122.07"></point>
      </location>
  </data>
  .....
</dwml>
 
XPATH Query to take the latitude in more general way
/dwml/data/location/point/@latitude
 
Where as with simple XML it is just a familiar PHP statement,
$simplexml->data->location->point->attributes()->latitude
 
Anyway still you can use the xpath inside your simplexml code. You can execute xpath queries by calling xpath function from any SimpleXMLEelment. It will return an array of SimpleXMLElement that match your query. So for the above example your XPath query would be something  like this,
$simplexml= new SimpleXMLElement($xml);
$lats =  $simplexml->xpath('/dwml/data/location/point/@latitude');
echo $lats[0];
 
[PHP] pobierz, plaintext