PHP 数组转 CSV [英] PHP Array to CSV

问题描述

我正在尝试将一系列产品转换为 CSV 文件，但似乎没有计划.CSV 文件很长，这是我的代码:

I'm trying to convert an array of products into a CSV file, but it doesn't seem to be going to plan. The CSV file is one long line, here is my code:

for($i=0;$i<count($prods);$i++) {
$sql = "SELECT * FROM products WHERE id = '".$prods[$i]."'";
$result = $mysqli->query($sql);
$info = $result->fetch_array(); 
}

$header = '';

for($i=0;$i<count($info);$i++)  
  {
    $row = $info[$i];

    $line = '';
    for($b=0;$b<count($row);$b++)
    { 
    $value = $row[$b];                                      
        if ( ( !isset( $value ) ) || ( $value == "" ) )
        {
            $value = "	";
        }
        else
        {
            $value = str_replace( '"' , '""' , $value );
            $value = '"' . $value . '"' . "	";
        }
         $line .= $value;
        }
    $data .= trim( $line ) . "
";
}
$data = str_replace( "
" , "" , $data );

if ( $data == "" )
{
$data = "
(0) Records Found!
";                        
}

header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=your_desired_name.xls");
header("Pragma: no-cache");
header("Expires: 0");

array_to_CSV($data);


function array_to_CSV($data)
    {
        $outstream = fopen("php://output", 'r+');
        fputcsv($outstream, $data, ',', '"');
        rewind($outstream);
        $csv = fgets($outstream);
        fclose($outstream);
        return $csv;
    }

此外，标题不会强制下载.我一直在复制和粘贴输出并保存为 .csv

Also, the header doesn't force a download. I've been copy and pasting the output and saving as .csv

问题已解决:

如果其他人正在寻找相同的东西，请找到更好的方法:

If anyone else was looking for the same thing, found a better way of doing it:

$num = 0;
$sql = "SELECT id, name, description FROM products";
if($result = $mysqli->query($sql)) {
     while($p = $result->fetch_array()) {
         $prod[$num]['id']          = $p['id'];
         $prod[$num]['name']        = $p['name'];
         $prod[$num]['description'] = $p['description'];
         $num++;        
    }
 }
$output = fopen("php://output",'w') or die("Can't open php://output");
header("Content-Type:application/csv"); 
header("Content-Disposition:attachment;filename=pressurecsv.csv"); 
fputcsv($output, array('id','name','description'));
foreach($prod as $product) {
    fputcsv($output, $product);
}
fclose($output) or die("Can't close php://output");

推荐答案

与其写出值，不如考虑使用 fputcsv().

Instead of writing out values consider using fputcsv().

这可能会立即解决您的问题.

This may solve your problem immediately.

评论注意:我应该提到这将在您的服务器上制作一个文件，因此您需要在输出之前阅读该文件的内容，如果您不想保存一份副本，完成后你需要 ùnlink`该文件

Note from comment: I should mention that this will be making a file on your server, so you'll need to read that file's contents before outputting it, also if you don't want to save a copy then you'll need to ùnlink`the file when you are done

这篇关于PHP 数组转 CSV的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！