How to extract value from xml to php [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 7 years ago.

Improve this question

<?xml version="1.0"?>
<ABCD xmlns="http://abcd.com">
<PRODUCT xmlns="">
 <CNHEADER>
  <CNTRACK>true</CNTRACK>
  <FIELD name="PRODUCTNO" value="BK201122"/>
  <FIELD name="ProductType" value="DP"/>
  <FIELD name="strProdCode" value="NL1754"/>

Here i want the value of PRODUCTNO and so on.

i tried this but still not getting any output

$ch = curl_init(); 

curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); 

curl_setopt($ch, CURLOPT_URL, $url); // get the url contents 

$data = curl_exec($ch); // execute curl request 

curl_close($ch); 

$xml = simplexml_load_string($data); 

echo $value = (string) $xml->FIELD[0]->attributes()->name;

Hello Ravi, you should take a look at XML Parser utilities (like SimpleXML) : php.net/manual/fr/simplexml.examples-basic.php — André DS
– André DS, Commented Sep 20, 2018 at 7:32
Possible duplicate of PHP How to read XML Child Node Value in a String using PHP? — Tom Udding
– Tom Udding, Commented Sep 20, 2018 at 7:33
Please do some proper research and make some attempts before posting. There are plenty of guides about reading XML with PHP out there (and here on SO). Try any of those first. If you still can't get it working, you're welcome to come back to show us what you've tried, explain where you're stuck and we can help you from there but we won't write it all for you. — M. Eriksson
– M. Eriksson, Commented Sep 20, 2018 at 7:37
You're just asking for code and SO isn't a free coding service. You're expected to write your own code. We can help you if you get stuck on something specific with your existing code. Please visit the help center and read the guidelines. — M. Eriksson
– M. Eriksson, Commented Sep 20, 2018 at 7:39
Have you read the comment posted by @Tom Udding? So try that solution and then ask if you have some errors — law_81
– law_81, Commented Sep 20, 2018 at 7:46

Divyesh Prajapati · Accepted Answer · 2018-09-20 07:51:45Z

1

Using SimpleXMLElement() you can get your product data from xml string; ref

// Your xml string
$xmlString = '<?xml version="1.0"?>
<ABCD xmlns="http://abcd.com">
<PRODUCT xmlns="">
 <CNHEADER>
  <CNTRACK>true</CNTRACK>
  <FIELD name="PRODUCTNO" value="Z41346020"/>
  <FIELD name="ProductType" value="DP"/>
  <FIELD name="strProdCode" value="NL1754"/>
 </CNHEADER>
</PRODUCT>
</ABCD>';

$xmlData = new SimpleXMLElement($xmlString);

$productData = [];
foreach ($xmlData->PRODUCT->CNHEADER->FIELD as $productField) {
    $productData[(string)$productField{'name'}] = (string)$productField{'value'};
}

echo "<pre>";
print_r($productData);
exit;

You will get following output

// Output
Array
(
    [PRODUCTNO] => Z41346020
    [ProductType] => DP
    [strProdCode] => NL1754
)

answered Sep 20, 2018 at 7:51

Divyesh Prajapati

9855 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

How to extract value from xml to php [closed]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related