当前位置:Gxlcms > PHP教程 > PHPxmltocsv

PHPxmltocsv

时间:2021-07-01 10:21:17 帮助过:19人阅读

From: http://codestips.com/php-xml-to-csv/

To create a csv file from a xml in PHP 5.0 it’s very simple, we will just have to write some lines.
We will use the SimpleXML extension that come from PHP 5.0.
SimpleXML reads an entire xml into an object that we can iterate through his properties.
To write to the csv output file we will use fputcsv.
fputcsv formats a line as csv and writes it to the file.
Suppose we are having this xml named cars.xml:

 blue 2000 red 10000  black 5000

First we should read our xml using simplexml_load_file passing the name of the file and returns an object with all the properties and values of the csv:

    $xml = simplexml_load_file($filexml);

After reading it we should iterate through all the child nodes of cars and write it to the output file using fputcsv specifying the object,delimiter and enclosure. We should first convert the object into an array in order to write it to the csv:

foreach ($xml->car as $car) fputcsv($f, get_object_vars($car),',','"');

Here is the complete source code that converts xml to csv in php 5.0:

car as $car) {    fputcsv($f, get_object_vars($car),',','"');}fclose($f);}?>

Download php source code for converting xml into a csv

人气教程排行