CSV转XML代码,PHP代码库,德仔网

代码语言
代码分类
【PHP】 CSV转XML
作者:Dezai.CN / 发布于2011/6/11/ 548
<div><span style="color: rgb(0,0,0); font-weight: bold"><?php</span>
<span style="font-style: italic; color: rgb(128,128,128)">/**
* Converts a CSV file to a simple XML file
*
* @param string $file
* @param string $container
* @param string $rows
* @return string
*/</span>
<span style="color: rgb(0,0,0); font-weight: bold">function</span> csv2xml<span style="color: rgb(102,204,102)">(</span><span style="color: rgb(0,0,255)">$file</span>, <span style="color: rgb(0,0,255)">$container</span> = <span style="color: rgb(255,0,0)">'data'</span>, <span style="color: rgb(0,0,255)">$rows</span> = <span style="color: rgb(255,0,0)">'row'</span><span style="color: rgb(102,204,102)">)</span>
<span style="color: rgb(102,204,102)">{</span>
<span style="color: rgb(0,0,255)">$r</span> = <span style="color: rgb(255,0,0)">"<{$container}><span style="color: rgb(0,0,153); font-weight: bold">\n</span>"</span>;
<span style="color: rgb(0,0,255)">$row</span> = <span style="color: rgb(204,102,204)">0</span>;
<span style="color: rgb(0,0,255)">$cols</span> = <span style="color: rgb(204,102,204)">0</span>;
<span style="color: rgb(0,0,255)">$titles</span> = <a href="http://www.php.net/array" target="_blank"><span style="color: rgb(0,0,102)">array</span></a><span style="color: rgb(102,204,102)">(</span><span style="color: rgb(102,204,102)">)</span>;

<span style="color: rgb(0,0,255)">$handle</span> = @<a href="http://www.php.net/fopen" target="_blank"><span style="color: rgb(0,0,102)">fopen</span></a><span style="color: rgb(102,204,102)">(</span><span style="color: rgb(0,0,255)">$file</span>, <span style="color: rgb(255,0,0)">'r'</span><span style="color: rgb(102,204,102)">)</span>;
<span style="color: rgb(177,177,0)">if</span> <span style="color: rgb(102,204,102)">(</span>!<span style="color: rgb(0,0,255)">$handle</span><span style="color: rgb(102,204,102)">)</span> <span style="color: rgb(177,177,0)">return</span> <span style="color: rgb(0,0,255)">$handle</span>;

<span style="color: rgb(177,177,0)">while</span> <span style="color: rgb(102,204,102)">(</span><span style="color: rgb(102,204,102)">(</span><span style="color: rgb(0,0,255)">$data</span> = <a href="http://www.php.net/fgetcsv" target="_blank"><span style="color: rgb(0,0,102)">fgetcsv</span></a><span style="color: rgb(102,204,102)">(</span><span style="color: rgb(0,0,255)">$handle</span>, <span style="color: rgb(204,102,204)">1000</span>, <span style="color: rgb(255,0,0)">','</span><span style="color: rgb(102,204,102)">)</span><span style="color: rgb(102,204,102)">)</span> !== <span style="color: rgb(0,0,0); font-weight: bold">FALSE</span><span style="color: rgb(102,204,102)">)</span>
<span style="color: rgb(102,204,102)">{</span>
<span style="color: rgb(177,177,0)">if</span> <span style="color: rgb(102,204,102)">(</span><span style="color: rgb(0,0,255)">$row</span> > <span style="color: rgb(204,102,204)">0</span><span style="color: rgb(102,204,102)">)</span> <span style="color: rgb(0,0,255)">$r</span> .= <span style="color: rgb(255,0,0)">"<span style="color: rgb(0,0,153); font-weight: bold">\t</span><{$rows}><span style="color: rgb(0,0,153); font-weight: bold">\n</span>"</span>;
<span style="color: rgb(177,177,0)">if</span> <span style="color: rgb(102,204,102)">(</span>!<span style="color: rgb(0,0,255)">$cols</span><span style="color: rgb(102,204,102)">)</span> <span style="color: rgb(0,0,255)">$cols</span> = <a href="http://www.php.net/count" target="_blank"><span style="color: rgb(0,0,102)">count</span></a><span style="color: rgb(102,204,102)">(</span><span style="color: rgb(0,0,255)">$data</span><span style="color: rgb(102,204,102)">)</span>;
<span style="color: rgb(177,177,0)">for</span> <span style="color: rgb(102,204,102)">(</span><span style="color: rgb(0,0,255)">$i</span> = <span style="color: rgb(204,102,204)">0</span>; <span style="color: rgb(0,0,255)">$i</span> < <span style="color: rgb(0,0,255)">$cols</span>; <span style="color: rgb(0,0,255)">$i</span>++<span style="color: rgb(102,204,102)">)</span>
<span style="color: rgb(102,204,102)">{</span>
<span style="color: rgb(177,177,0)">if</span> <span style="color: rgb(102,204,102)">(</span><span style="color: rgb(0,0,255)">$row</span> == <span style="color: rgb(204,102,204)">0</span><span style="color: rgb(102,204,102)">)</span>
<span style="color: rgb(102,204,102)">{</span>
<span style="color: rgb(0,0,255)">$titles</span><span style="color: rgb(102,204,102)">[</span><span style="color: rgb(0,0,255)">$i</span><span style="color: rgb(102,204,102)">]</span> = <span style="color: rgb(0,0,255)">$data</span><span style="color: rgb(102,204,102)">[</span><span style="color: rgb(0,0,255)">$i</span><span style="color: rgb(102,204,102)">]</span>;
<span style="color: rgb(177,177,0)">continue</span>;
<span style="color: rgb(102,204,102)">}</span>

<span style="color: rgb(0,0,255)">$r</span> .= <span style="color: rgb(255,0,0)">"<span style="color: rgb(0,0,153); font-weight: bold">\t</span><span style="color: rgb(0,0,153); font-weight: bold">\t</span><{$titles[$i]}>"</span>;
<span style="color: rgb(0,0,255)">$r</span> .= <span style="color: rgb(0,0,255)">$data</span><span style="color: rgb(102,204,102)">[</span><span style="color: rgb(0,0,255)">$i</span><span style="color: rgb(102,204,102)">]</span>;
<span style="color: rgb(0,0,255)">$r</span> .= <span style="color: rgb(255,0,0)">"</{$titles[$i]}><span style="color: rgb(0,0,153); font-weight: bold">\n</span>"</span>;
<span style="color: rgb(102,204,102)">}</span>
<span style="color: rgb(177,177,0)">if</span> <span style="color: rgb(102,204,102)">(</span><span style="color: rgb(0,0,255)">$row</span> > <span style="color: rgb(204,102,204)">0</span><span style="color: rgb(102,204,102)">)</span> <span style="color: rgb(0,0,255)">$r</span> .= <span style="color: rgb(255,0,0)">"<span style="color: rgb(0,0,153); font-weight: bold">\t</span></{$rows}><span style="color: rgb(0,0,153); font-weight: bold">\n</span>"</span>;
<span style="color: rgb(0,0,255)">$row</span>++;
<span style="color: rgb(102,204,102)">}</span>
<a href="http://www.php.net/fclose" target="_blank"><span style="color: rgb(0,0,102)">fclose</span></a><span style="color: rgb(102,204,102)">(</span><span style="color: rgb(0,0,255)">$handle</span><span style="color: rgb(102,204,102)">)</span>;
<span style="color: rgb(0,0,255)">$r</span> .= <span style="color: rgb(255,0,0)">"</{$container}>"</span>;

<span style="color: rgb(177,177,0)">return</span> <span style="color: rgb(0,0,255)">$r</span>;
<span style="color: rgb(102,204,102)">}</span>
<span style="color: rgb(0,0,0); font-weight: bold">?></span>
<div style="font-family: monospace" class="php">
<span style="color: rgb(0,0,255)">$xml</span> = csv2xml<span style="color: rgb(102,204,102)">(</span><span style="color: rgb(255,0,0)">'/home/user/myfile.csv'</span>, <span style="color: rgb(255,0,0)">'people'</span>, <span style="color: rgb(255,0,0)">'person'</span><span style="color: rgb(102,204,102)">)</span>;
</div>
<div style="font-family: monospace" class="xml">
<span style="color: rgb(0,153,0)"><span style="color: black; font-weight: bold"><people<span style="color: black; font-weight: bold">></span></span></span>
<span style="color: rgb(0,153,0)"><span style="color: black; font-weight: bold"><person<span style="color: black; font-weight: bold">></span></span></span>
<span style="color: rgb(0,153,0)"><span style="color: black; font-weight: bold"><name<span style="color: black; font-weight: bold">></span></span></span>John Smith<span style="color: rgb(0,153,0)"><span style="color: black; font-weight: bold"></name<span style="color: black; font-weight: bold">></span></span></span>
<span style="color: rgb(0,153,0)"><span style="color: black; font-weight: bold"><zip<span style="color: black; font-weight: bold">></span></span></span>19100<span style="color: rgb(0,153,0)"><span style="color: black; font-weight: bold"></zip<span style="color: black; font-weight: bold">></span></span></span>
<span style="color: rgb(0,153,0)"><span style="color: black; font-weight: bold"></person<span style="color: black; font-weight: bold">></span></span></span>
<span style="color: rgb(0,153,0)"><span style="color: black; font-weight: bold"><person<span style="color: black; font-weight: bold">></span></span></span>
<span style="color: rgb(0,153,0)"><span style="color: black; font-weight: bold"><name<span style="color: black; font-weight: bold">></span></span></span>Jane Doe<span style="color: rgb(0,153,0)"><span style="color: black; font-weight: bold"></name<span style="color: black; font-weight: bold">></span></span></span>
<span style="color: rgb(0,153,0)"><span style="color: black; font-weight: bold"><name<span style="color: black; font-weight: bold">></span></span></span>19200<span style="color: rgb(0,153,0)"><span style="color: black; font-weight: bold"></name<span style="color: black; font-weight: bold">></span></span></span>
<span style="color: rgb(0,153,0)"><span style="color: black; font-weight: bold"></person<span style="color: black; font-weight: bold">></span></span></span>
<span style="color: rgb(0,153,0)"><span style="color: black; font-weight: bold"></people<span style="color: black; font-weight: bold">></span></span></span>
</div>
</div>
试试其它关键字
　CSV转XML　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)