php generating xml adding text inside foreach loop

Question

I want to generate a dynamic xml to send to a webservice. I have a php foreach loop inside the xml. But I can't get the syntax right.

I need the string to look like this -

<?xml version=1.0" encoding="ISO-8859-1">
<inventoryUpdateRequest version="1.0">
<action name="bookupdate">
</action>
<SiteNameList>
<SiteName>
<vendorBookID>123456</vendorBookID>
</SiteName>
<SiteName>
<vendorBookID>788901</vendorBookID>
</SiteName>
</SiteNameList>
</inventoryUpdateRequest>

The <SiteName>...</SiteName> is looped for each value found.

My code so far is this -

<?php 
$xml =
'<?xml version="1.0" encoding="ISO-8859-1">
<inventoryUpdateRequest version="1.0">
<action name="bookupdate">
</action>
<SiteNameList>
'.
$ids_orderlineitem_portal_rownum = 1;
foreach($ids_row['order_line_item::bookID'] as  $ids_orderlineitem_portal_row=>$ids_orderlineitem_portal)
{
.'
<SiteName>
<vendorBookID>
'.$ids_row['order_line_item::bookID'][$ids_orderlineitem_portal_row].'
</vendorBookID>
</SiteName>
'.if($ids_orderlineitem_portal_rownum == 0) break; else  $ids_orderlineitem_portal_rownum++;
}//portal_end
.'
</SiteNameList>
</inventoryUpdateRequest>'
;
$url ='https://inventoryupdate.sitename.com';
$port = 80;

$response = xml_post($xml, $url, $port);    
?>

Help? How can I get the loop to output the format I need?

Use one of the XML extensions. See stackoverflow.com/questions/2060346/… — Gordon
– Gordon, Commented May 22, 2011 at 21:46

Jayy · Accepted Answer · 2011-05-22 21:55:03Z

1

It's hard to know if this will work, because I don't know what format the input data is in , but hopefully this should work, or is at least closer to what you need:

<?php 
    $xml =
    '<?xml version="1.0" encoding="ISO-8859-1">
    <inventoryUpdateRequest version="1.0">
    <action name="bookupdate">
    </action>
    <SiteNameList>';
    foreach($ids_row['order_line_item::bookID'] as  $book_id)
    {
        $xml .= '
        <SiteName>
        <vendorBookID>
        '.$book_id.'
        </vendorBookID>
        </SiteName>';
    }//portal_end
    $xml .= '
    </SiteNameList>
    </inventoryUpdateRequest>'
    ;

    $url ='https://inventoryupdate.sitename.com';
    $port = 80;

    $response = xml_post($xml, $url, $port);    
?>

edited May 22, 2011 at 21:55

answered May 22, 2011 at 21:48

Jayy

14.9k27 gold badges108 silver badges168 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Lily Over a year ago

Jodes, tried your method, source code shows correct xml format and info, but response from webservice says XML error. Grr, feels like the solution is so close! Thanks for the help.

Lily Over a year ago

OK, so I figured it out, I was missing a "?" at the end of the first line. And so it works beautifully now. Thank you Jodes, my hero!

Collectives™ on Stack Overflow

php generating xml adding text inside foreach loop

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related