php数组保存到csv,PHP数组到CSV

我试图将一个产品数组转换成一个CSV文件，但它似乎没有计划。 CSV文件是一个长行，这里是我的代码：

for($i=0;$i

$sql = "SELECT * FROM products WHERE id = '".$prods[$i]."'";

$result = $mysqli->query($sql);

$info = $result->fetch_array();

}

$header = '';

for($i=0;$i

{

$row = $info[$i];

$line = '';

for($b=0;$b

{

$value = $row[$b];

if ( ( !isset( $value ) ) || ( $value == "" ) )

{

$value = "\t";

}

else

{

$value = str_replace( '"' , '""' , $value );

$value = '"' . $value . '"' . "\t";

}

$line .= $value;

}

$data .= trim( $line ) . "\n";

}

$data = str_replace( "\r" , "" , $data );

if ( $data == "" )

{

$data = "\n(0) Records Found!\n";

}

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

编辑

问题解决：

如果任何人正在寻找同样的事情，找到一个更好的方法：

$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");