Need help with array

[ColinHughes]

Hi

I have the following which puts the content of an XML feed into an array:

<?php
require_once('classes/xml2array.php');

    function curlURL($url) {  
     $ch= curl_init();  
       curl_setopt($ch, CURLOPT_URL, $url);  
         curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);  
           curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2');  
       $output = curl_exec($ch);  
      return $output;  
   }  
    
  $curlResults = curlURL("http://www.a website/75.xml");  
     
  $xml = $curlResults;

$converter = new Xml2Array();
$converter->setXml($xml);
$xml_array = $converter->get_array();

?>

The array is structured as follows:

Array
(
    [root] => Array
        (
            [feed] => Array
                (
                    [version] => Array
                        (
                            [#text] => 2_1
                        )
 
                )
 
            [item] => Array
                (
                    [0] => Array
                        (
                            [id] => Array
                                (
                                    [#text] => HE 019
                                )
 
                            [date] => Array
                                (
                                    [#text] => 2009-02-01 21:17:05
                                )
 
                            [ref] => Array
                                (
                                    [#text] => HE 019
                                )
 
                            [price] => Array
                                (
                                    [#text] => 760000

I would like some tailored advice as to how I can output the various values to my page. the example shows only one item there are around 400 items in the feed.

Despite trawling the info about arrays and trying to implement what I have read I cannot seem to get my head around this.

Can somebody please get me started on this.

TIA

Colin

[Dan Grossman]

foreach ($xml_array['root']['item'] as $item) {
  echo $item['id']; 
  //...
} 

[ColinHughes]

Thanks for the reply.

Your solution returns "ArrayArray" ?? I have also managed to get this as a result in one of my many attempts along with a few blank pages.


C

[Dan Grossman]

echo $item['id']['#text']

A little use of print_r or var_dump should make figuring out where you are in the array easy

[ColinHughes]

Yep used print_r to view the array initially.

$xml_array = $converter->get_array();
//print_r($xml_array);

foreach ($xml_array['root']['item'] as $item) {
  echo $item['id']['#text'];
  //...
} 

I was getting it wrong because I was trying to include the [0] in there in order to return individual item results. How would I go about doing this, adding it after [item] as seen in the array tree does not work?

thanx

C

[Dan Grossman]

The foreach would make $item equal to element 0, then 1, then 2...

Does that not work? What do you see when you dump $item in that loop?

[ColinHughes]

Yes I see all items within the group.

Maybe I failed to explain myself properly. What I will need to do is be able to direct a page to item say 120 and display only those details rather than just display a loop of all the items as at the moment.

Thanks

C

[ColinHughes]

Array
(
    [root] => Array
        (
            [feed] => Array
                (
                    [version] => Array
                        (
                            [#text] => 2_1
                        )
 
                )
 
            [item] => Array
                (
                    [0] => Array
                        (
                            [id] => Array
                                (
                                    [#text] => HE 019
                                )
 
                            [date] => Array
                                (
                                    [#text] => 2009-02-01 21:17:05
                                )
 
                            [ref] => Array
                                (
                                    [#text] => HE 019
                                )
                         )
 
                    [1] => Array
                        (
                            [id] => Array
                                (
                                    [#text] => HE033
                                )
 
                            [date] => Array
                                (
                                    [#text] => 2009-03-05 14:48:22
                                )
 
                            [ref] => Array
                                (
                                    [#text] => HE33

I am having difficulty understanding why [0] & [1] are seemingly ignored. These are the key elements in each item that will enable me to output unique content for an item. Do I really need to loop through the array or can I somehow just return the results relevant to whatever the value of the[0] element is?

Colin

[Dan Grossman]

echo $xml_array['root']['item'][0][id]['#text']

[ColinHughes]

Thanks

I have actually got this far now, but I used ['id'] and not [id].

This could get involved as I need to limit my list results to 3 and add some pagination. I also need to link from an item in the list to a new page featuring that item.

Is there a way of counting the results to facilitate pagination

Colin

[Dan Grossman]

count($xml_array['root']['item'])

You might also consider parsing the xml array into a simpler array containing only the parts you want, right under the root level, if that'll make the rest of your code simpler.

[ColinHughes]

OK Dan thanx for your help I have a lot to be going on with. Watch this space if I get stuck (sure I will)

Thanx again

Colin