Converting XML to CSV using PHP

Question

I need to convert an XML file to CSV.

I have a script but I am unsure of how to use it to my needs.

Here is the script

$filexml='141.xml';
if (file_exists($filexml)) {
$xml = simplexml_load_file($filexml);
$f = fopen('141.csv', 'w');
foreach ($xml->item as $item) {
fputcsv($f, get_object_vars($item),',','"');
}
fclose($f);
}

The file is called 141.xml and here is some of the code in the XML which I need to convert.

<?xml version="1.0" encoding="UTF-8" ?>
<rss xmlns:g="http://base.google.com/ns/1.0" version="2.0">



<channel>
<item>
<title><![CDATA[//title name]]></title>
<link><![CDATA[https://www.someurl.co.uk]]></link>
<description><![CDATA[<p><span>Demo Description</span></p>]]></description>
<g:id><![CDATA[4796]]></g:id>
<g:condition><![CDATA[new]]></g:condition>
<g:price><![CDATA[0.89 GBP]]></g:price>
<g:availability><![CDATA[in stock]]></g:availability>
<g:image_link><![CDATA[https://image-location.png]]></g:image_link>
<g:service><![CDATA[Free Shipping]]></g:service>
<g:price><![CDATA[0 GBP]]></g:price>
</item>

I am running the script from SSH using:

php /var/www/vhosts/mywebsite.co.uk/httpdocs/xml/convert.php

If you can help me, it would be really appreciated :)

Thanks

Answer 1

Try out below code. And the XML file is having syntax error, the closing tag for rss and channel is missing.

$filexml='141.xml';
if (file_exists($filexml)) 
 {
       $xml = simplexml_load_file($filexml);
       $f = fopen('141.csv', 'w');
       createCsv($xml, $f);
       fclose($f);
 }
 function createCsv($xml,$f)
 {
       foreach ($xml->children() as $item) 
        {
           $hasChild = (count($item->children()) > 0)?true:false;
           if( ! $hasChild)
           {
              $put_arr = array($item->getName(),$item); 
              fputcsv($f, $put_arr ,',','"');
           }
           else
           {
              createCsv($item, $f);
           }
        }
 }

Answer 2

Consider passing XML data into an array $values and exporting array by row to csv.

Specifically, using the xpath() function for the XML extraction, iterate through each <item> and extract all its children's values (/*). By the way, I add headers in the CSV file.

$filexml='141.xml';
if (file_exists($filexml))  {

   $xml = simplexml_load_file($filexml);
   $i = 1;           // Position counter
   $values = [];     // PHP array

   // Writing column headers
   $columns = array('title', 'link', 'description', 'id', 'condition',
                    'price', 'availability', 'image_link', 'service', 'price');

   $fs = fopen('141.csv', 'w');
   fputcsv($fs, $columns);      
   fclose($fs);

   // Iterate through each <item> node
   $node = $xml->xpath('//item');

   foreach ($node as $n) {           

       // Iterate through each child of <item> node
       $child = $xml->xpath('//item['.$i.']/*');      

       foreach ($child as $value) {
          $values[] = $value;         
       }

       // Write to CSV files (appending to column headers)
       $fs = fopen('141.csv', 'a');
       fputcsv($fs, $values);      
       fclose($fs);  

       $values = [];    // Clean out array for next <item> (i.e., row)
       $i++;            // Move to next <item> (i.e., node position)
   }
}