Parse XML files

[tewari68]

Hi,
Appreciate if anybody can let me know how to parse the following xml file in php

<?xml version="1.0" encoding="utf-8" ?>
<OrderList>
<Order ID="438" Wholesale_Fulfillment_ID=""></Order>
<Order ID="464" Wholesale_Fulfillment_ID=""></Order>
<Order ID="506" Wholesale_Fulfillment_ID=""></Order>
<Order ID="515" Wholesale_Fulfillment_ID=""></Order>
<Order ID="587" Wholesale_Fulfillment_ID=""></Order>
<Order ID="619" Wholesale_Fulfillment_ID=""></Order>
<Order ID="627" Wholesale_Fulfillment_ID=""></Order>
<Order ID="628" Wholesale_Fulfillment_ID=""></Order>
<Order ID="629" Wholesale_Fulfillment_ID=""></Order>
<Order ID="637" Wholesale_Fulfillment_ID=""></Order>
<Order ID="687" Wholesale_Fulfillment_ID=""></Order>
<Order ID="689" Wholesale_Fulfillment_ID=""></Order>
<Order ID="695" Wholesale_Fulfillment_ID=""></Order>
<Order ID="696" Wholesale_Fulfillment_ID=""></Order>
<Order ID="699" Wholesale_Fulfillment_ID=""></Order>
<Order ID="773" Wholesale_Fulfillment_ID=""></Order>
<Order ID="801" Wholesale_Fulfillment_ID=""></Order>
</OrderList>

I need to get the order id numbers in an array.
Appreciate any help.
Thanks,
tewari

 

[Miros]

There's an example at

http://us3.php.net/manual/en/ref.xml.php

that should be modifiable with very little trouble.

 

[tewari68]

Hi Miros,
Here the problem is that there is no data between the start and end tags but it is included within the start tag as

<?xml version="1.0" encoding="utf-8" ?>
<OrderList>
<Order ID="438" Wholesale_Fulfillment_ID=""></Order>
<Order ID="464" Wholesale_Fulfillment_ID=""></Order>
<Order ID="506" Wholesale_Fulfillment_ID=""></Order>
<Order ID="515" Wholesale_Fulfillment_ID=""></Order>
<Order ID="587" Wholesale_Fulfillment_ID=""></Order>
<Order ID="619" Wholesale_Fulfillment_ID=""></Order>
<Order ID="627" Wholesale_Fulfillment_ID=""></Order>
<Order ID="628" Wholesale_Fulfillment_ID=""></Order>
<Order ID="629" Wholesale_Fulfillment_ID=""></Order>
<Order ID="637" Wholesale_Fulfillment_ID=""></Order>
<Order ID="687" Wholesale_Fulfillment_ID=""></Order>
<Order ID="689" Wholesale_Fulfillment_ID=""></Order>
<Order ID="695" Wholesale_Fulfillment_ID=""></Order>
<Order ID="696" Wholesale_Fulfillment_ID=""></Order>
<Order ID="699" Wholesale_Fulfillment_ID=""></Order>
<Order ID="773" Wholesale_Fulfillment_ID=""></Order>
<Order ID="801" Wholesale_Fulfillment_ID=""></Order>
</OrderList>

I am new to xml parsing in php can you help me a little bit more on how to get the order ids.

Thanks,
tewari

 

[Miros]

You simply access the attributes instead of the values.

 

[Miros]

Basically in this routine:

function startHandler($parser, $name, $attributes)
   {
       $data['name'] = $name;
       if ($attributes) { $data['attributes'] = $attributes; }
       $this->data[] = $data;
   }

you'd do:

if ($attributes) $this->orders[] = GetID($attributes);

GetID would parse the $attributes string and return the ID.

 

[tewari68]

Hi Miros,
I replaced the code with what you have suggested, however I keep getting call to undefined function getid() error.
Do I need to further define the GetID function?

Appreciate your help.

Thanks,
tewari

 

[Miros]

Yes, you write GetID. It would use indexOf to find ID=" and the following ", then do a substring to get the actual ID.