XML解析和foreach结构

Question

I'm new to XML parsing but not new to php and html. I need to parse the following XML structure:

<er_data service="pl">
    <manufacturer_item>
        <item_id></item_id>
        <model></model>
        <manufacturer></manufacturer>
        <product_name></product_name>
        <description></description>
        <datasheeturl/>
        <image_url/>
        <map></map>
    </manufacturer_item>
    <dealers>
        <dealer id="111">
            <dealer_logo>http:/source.com/images/vendors/90x60/111.gif</dealer_logo>
            <dealer_name></dealer_name>
            <dealer_url></dealer_url>
        </dealer>
        <dealer id="222">
            <dealer_logo>http:/source.com/images/vendors/90x60/222.gif</dealer_logo>
            <dealer_name></dealer_name>
            <dealer_url></dealer_url>
        </dealer>
    </dealers>
    <dealer_item>
        <dealer_id>111</dealer_id>
        <dealer_sku></dealer_sku>
        <model></model>
        <manufacturer></manufacturer>
        <name></name>
        <price></price>
        <availability></availability>
        <image_url></image_url>
        <buy_url>http://source.com/c/?nVID=111&rsSku=321321</buy_url>
    </dealer_item>
    <dealer_item>
        <dealer_id>222</dealer_id>
        <dealer_sku></dealer_sku>
        <model></model>
        <manufacturer></manufacturer>
        <name></name>
        <price></price>
        <availability></availability>
        <image_url></image_url>
        <buy_url>http://source.com/c/?nVID=222&rsSku=654654</buy_url>
    </dealer_item>
    <loggingpixel></loggingpixel>
</er_data>

and create a foreach that outputs html like this:

<tr>
    <td><img src=$dealer_logo></td>
<td><a href=$buy_url>Buy Online</a></td>
</tr>

For brevity, I'm not putting all the things I've tried. There will be one manufacturer item and it will be a constant. There will be multiple dealer id (s) and each dealer could have multiple dealer_item (s) but will always have at least one. I don't know the constructs to use to get the things I need. The dealer_logo comes out of dealers and the buy_url comes out of dealer_items. Note the logo URL will have the dealer id number in it.

For brevity, I won't show all the newbie things I've tried. Basically, I am using a structure like this for the reading and looping:

$retailers = simplexml_load_file("http://source.com/xml.asp");

foreach ($retailers->dealer_items as $storeinfo):
endforeach;

Any help would be greatly appreciated! Sorry that the XML is not indented properly. Karen edit MrCode- I'm still getting nothing. The XML file is under someone else's control but when I open it in Safari and save it to disk I see &. I also changed the URL that I feed it to have the & but still nothing. Here is the code exactly as I have it currently:

<table class="gridtable">
<tr>
    <th>Retailer</th>
    <th>In Stock</th>
    <th></th>
    </tr>

<?php   
$retailers = simplexml_load_string('http://pg.links.channelintelligence.com/pages/plxml.asp?sSKU=633472600401&amp;nRGID=4938');
$dealers = array();
foreach($retailers->dealers->dealer as $dealer)
{
$dealers[(int)$dealer->attributes()->id] = array('dealer_logo' => (string)$dealer->dealer_logo);
}
?>

<?php foreach($retailers->dealer_item as $item): ?>
<tr>
<td><img src="<?php echo $dealers[(int)$item->dealer_id]['dealer_logo']; ?>"></td>
<td>Yes</td>
<td><a href="<?php echo (string)$item->buy_url; ?>">Buy Online</a></td>
</tr>
<?php endforeach; ?>

</table>

edit (strugging with formatting on the forum) *The XML file is under someone else's control but when I open it in Safari and save it to disk I see the encoded version of ampersand.

Edit to post errors: [Mon Aug 12 20:32:06 2013] [error] [client 204.181.48.224] PHP Warning: simplexml_load_string(): Entity: line 1: parser error : Start tag expected, '<' not found in /home/sites/staging.clearblueeasy.com/website/m/advanced-digital-ovulation-test-buyonline.php on line 32 [Mon Aug 12 20:32:06 2013] [error] [client 204.181.48.224] PHP Warning: simplexml_load_string(): http://pg.links.channelintelligence.com/pages/plxml.asp?nrgid=4938&ssku=63347260 in /home/sites/staging.clearblueeasy.com/website/m/advanced-digital-ovulation-test-buyonline.php on line 32 [Mon Aug 12 20:32:06 2013] [error] [client 204.181.48.224] PHP Warning: simplexml_load_string(): ^ in /home/sites/staging.clearblueeasy.com/website/m/advanced-digital-ovulation-test-buyonline.php on line 32 [Mon Aug 12 20:32:06 2013] [error] [client 204.181.48.224] PHP Warning: Invalid argument supplied for foreach() in /home/sites/staging.clearblueeasy.com/website/m/advanced-digital-ovulation-test-buyonline.php on line 34 [Mon Aug 12 20:32:06 2013] [error] [client 204.181.48.224] PHP Warning: Invalid argument supplied for foreach() in /home/sites/staging.clearblueeasy.com/website/m/advanced-digital-ovulation-test-buyonline.php on line 40

Answer 1

Because you have the dealers defined separately in the XML, you will need to first extract the dealers, so that you can lookup the dealer_logo based on the ID in the dealer_item:

<?php
// assume $retailers is the xml object
$dealers = array();
foreach($retailers->dealers->dealer as $dealer)
{
    $dealers[(int)$dealer->attributes()->id] = array('dealer_logo' => (string)$dealer->dealer_logo);
}
?>

<?php foreach($retailers->dealer_item as $item): ?>
<tr>
    <td><img src="<?php echo $dealers[(int)$item->dealer_id]['dealer_logo']; ?>"></td>
    <td><a href="<?php echo (string)$item->buy_url; ?>">Buy Online</a></td>
</tr>
<?php endforeach; ?>

Edit: Codepad Demo

Make sure that your XML is valid. Take a look at your URLs in the XML, they contain raw & which is not valid. You need to encode them into &. In the demo, I have changed them so you can see the code working.

Edit 2: final code

<?php

$retailers = simplexml_load_file('http://pg.links.channelintelligence.com/pages/plxml.asp?sSKU=633472600401&nRGID=4938');

$dealers = array();
foreach($retailers->dealers->dealer as $dealer)
{
    $dealers[(int)$dealer->attributes()->id] = array('dealer_logo' => (string)$dealer->dealer_logo);
}

?>

<?php foreach($retailers->dealer_items->dealer_item as $item): ?>
<tr>
    <td><img src="<?php echo $dealers[(int)$item->dealer_id]['dealer_logo']; ?>"></td>
    <td><a href="<?php echo (string)$item->buy_url; ?>">Buy Online</a></td>
</tr>
<?php endforeach; ?>