Using SimpleXML in PHP with a Twist

Question

I am using SimpleXML to load a remote XML

My PHP code looks like below

$xml = simplexml_load_file('http://www.abc.om/xml.php');

foreach( $xml as $Product )
    {
        echo 'ProductCode: '.$Product->ProductCode.'<br />';
        echo 'ProductName: '.$Product->ProductName.'<br />';

    }

MY XML looks like below

<All_Products>
<Product>
<ProductCode>9978H</ProductCode>
<ProductName>abc with Buckle in aBlack</ProductName>
<StockStatus>2</StockStatus>
</Product>
</All_Products>

Product tags are repeated as there are many products

after reading that XMLfeed the XML feed should display with some ammends that is before <StockStatus> tag it should add a tag

<ProductURL><ProductURL>

and that tag should display like

<ProductURL>http://abc.com/abc with Buckle in aBlack-p/9978H.htm<ProductURL>

That means each ProductURL should be appended as

<ProductURL>http://abc.com/<ProductName>-p/<ProductCode>.htm<ProductURL>

The final XML to display will look like

<All_Products>
<Product>
<ProductCode>9978H</ProductCode>
<ProductName>abc with Buckle in aBlack</ProductName>
<ProductURL>http://abc.com/abc with Buckle in aBlack-p/9978H.htm<ProductURL>
<StockStatus>2</StockStatus>
</Product>
</All_Products>

So my questions are

1) Do i have to read all the elements of the Product tag in the foreach( $xml as $Product ) loop and then append ProductURL element or is there any shortcut to do it

2) Once this data is ready how do i again display the data in XML format

@phpdev i added the question i tried reading XML and loading but how to read those 2 specific tags — user580950, Jul 14 '12 at 09:31

score 1 · Accepted Answer · edited May 23 '17 at 11:56

1

You can use DOM with SimpleXML.

Here's what you should do:

Use xpath() to run an xpath query that picks out all the Product tags. This should return you an array of SimpleXMLElements representing each Product tag.
Use xpath() again to select from each Product tag the ProductCode and ProductName and get their contents. Create your url and save it to a variable.
Use xpath() to select the StockStatus tag.
Using DOM's dom_import_simplexml(), convert the SimpleXMLElement StockStatus tags to a DOMElement.
Create the ProductURL element using DOM's createElement() and insert the url we created before.
Insert it before StockStatus using DOM's insertBefore().

This question should show you how to do the conversion to a DOMElement and finally do the insertion.

edited May 23 '17 at 11:56

Community

1
1

answered Jul 14 '12 at 09:42

F21

32,163
26
99
170

I tried till step 3 and it works great i did this $element = $dom->createElement('ProductURL', 'This is the root element!'); // We insert the new element as root (child of the document) $dom->appendChild($element); but i am not sure how to create that producr url dynamically like http://abc.com/-p/.htm – user580950 Jul 14 '12 at 09:56
your first step doesnt work i tried using the following it doesnt picks out the product tags $result = $xml->xpath('/All_Products/Product'); while(list( , $node) = each($result)) { echo '/a/b/c: ',$node,"\n"; } – user580950 Jul 14 '12 at 12:23

Using SimpleXML in PHP with a Twist

1 Answers1