Creating CSV from php

Question

如何在php中执行循环并将其添加到数组中?我从这里使用这个简单的代码- http://php.net/manual/en/function.fputcsv.php:

<?php
$list = array (
    array('aaa', 'bbb', 'ccc', 'dddd'),
    array('123', '456', '789'),
    array('"aaa"', '"bbb"')
);
$fp = fopen('file.csv', 'w');
foreach ($list as $fields) {
    fputcsv($fp, $fields);
}
fclose($fp);
?>

但是像这样创建列表，它应该添加来自my db:

的每一行

$data .= str_replace(","," ",$ftitle) . $delimiter .$ccrow['CourseCode']. $delimiter . str_replace(","," ",$ccrow['CourseName']) . $delimiter . $count . $delimiter . "n";
$list = array(array($data));

我得到它到我的文件，但它添加了所有在第一个单元格??

Answer 1

不知道你为什么需要这个:

$data .= str_replace(","," ",$ftitle) . $delimiter .$ccrow['CourseCode']. $delimiter . str_replace(","," ",$ccrow['CourseName']) . $delimiter . $count . $delimiter . "n";

你应该简单地这样做:

while(($ccrow = mysql_fetch_array($result))) {
    fputcsv($fp, $ccrow);
}

，它将正确地放置所有内容