Help converting XML to CSV

[ak111in]

xml file:

<PRICES>
<PRICE>
<WIC>HDE0AAFGRBOX</WIC>
<STOCK>100+</STOCK>
<MY_PRICE>219.00</MY_PRICE>
</PRICE>
</PRICES>

php file:

<?
$filexml='stock.xml';
if (file_exists($filexml)) {
$xml = simplexml_load_file($filexml);
$f = fopen('stock.csv', 'w');
foreach($xml->PRICES->PRICE as $price) {
fputcsv($f, get_object_vars($price),',','"');
}
fclose($f);
}
?>

 

Error:

Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\stock.php on line 6

 

Please help with this.

[q11we]

as PRICES is the root element it is already loaded when you load xml file.

so try using

foreach($xml->PRICE as $price) 

hope this will help