本文实例讲述了php使用fputcsv()函数csv文件读写数据的方法。分享给大家供大家参考。具体分析如下:
fputcsv() 函数用于将数据格式为csv格式,以便写入文件或者数据库.
1.将字符串写入csv文件中,代码如下:
$test_array = array(
array(\"111\",\"sdfsd\",\"sdds\",\"43344\",\"rrrr\"),
array(\"sssssssss\",\"gdfgfd\",\"232323\",\"wwewe\",\"dsfds\"),
array(\"fgfg\",\"e4343\",\"dsfds\",\"w2332\",\"xcvxc\"),
array(\"11212\",\"2323\",\"344343\",\"344343\",\"rerreer\"),
array(\"fds\",\"43344444\",\"33333333\",\"ttttttt\",\"gggggggggggg\"),
array(\"kdfs\",\"dsfdsfds\",\"wewewe\",\"sdsdddddddd\",\"wwwwwwwwwww\")
);
$file = fopen(\"test.csv\",\"w\") or die(\"Can\'t Open test.csv\");
foreach($test_array as $line_array)
{
$isSuccess = fputcsv($file,$line_array);
print $isSuccess.\"<br>\";
if($isSuccess===false)
{
die(\"Can\'t write csv line\".$line_array);
}
}
fclose($file) or die(\"Can\'t close file test.csv.\");
fputcsv()函数返回所写入行的字符的个数或者false,当写入失败时返回false.
2.将格式化的csv字符串保存到字符串中,代码如下:
$test_array = array(
array(\"111\",\"sdfsd\",\"sdds\",\"43344\",\"rrrr\"),
array(\"sssssssss\",\"gdfgfd\",\"232323\",\"wwewe\",\"dsfds\"),
array(\"fgfg\",\"e4343\",\"dsfds\",\"w2332\",\"xcvxc\"),
array(\"11212\",\"2323\",\"344343\",\"344343\",\"rerreer\"),
array(\"fds\",\"43344444\",\"33333333\",\"ttttttt\",\"gggggggggggg\"),
array(\"kdfs\",\"dsfdsfds\",\"wewewe\",\"sdsdddddddd\",\"wwwwwwwwwww\")
);
ob_start();
$file = fopen(\"php://output\",\"w\") or die(\"Can\'t Open php://output\");
foreach($test_array as $line_array)
{
$isSuccess = fputcsv($file,$line_array);
if($isSuccess===false)
{
die(\"Can\'t write csv line\".$line_array);
}
}
fclose($file) or die(\"Can\'t close file test.csv.\");
$result = ob_get_contents();
ob_end_clean();