数据库到CSV(完成)试图将文件保存到服务器上的文件夹


Database to CSV(Done) trying to Save file to folder on server

我已经成功地将我的数据库导出为csv作为可下载文件。然而,我现在需要做的不是创建一个直接的。csv文件,而是将其保存到服务器上一个名为"csv"的文件夹中。这是我当前导出的代码。我需要帮助在保存它到服务器。我没有正确保存数据。

// output headers so that the file is downloaded rather than displayed
header('Content-Type: text/csv; charset=utf-8');
header('Content-Disposition: attachment; filename=data.csv');
// create a file pointer connected to the output stream
$output = fopen('php://output', 'w');
// output the column headings
fputcsv($output, array('tax_class_id','_product_websites'));
// fetch the data
mysql_connect('localhost:3036', 'x', 'x');
mysql_select_db('lato');
$rows = mysql_query('SELECT taxclass,productwebsite FROM product');
// loop over the rows, outputting them
while ($row = mysql_fetch_assoc($rows)) 
fputcsv($output, $row);
$filename = "data.csv"; // Trying to save file in server
file_put_contents("download/" . $filename, "$header'n$rows");

为什么写入流,读取它,然后尝试保存内容?我会用更小的方式来做:

//Open a file in write-mode (he creates it, if it not exists)
$fp = fopen('./my/path/on/server/data.csv', 'w');
// output the column headings
fputcsv($fp, array('tax_class_id','_product_websites'));
// fetch the data
mysql_connect('localhost:3036', 'x', 'x');
mysql_select_db('lato');
$rows = mysql_query('SELECT taxclass,productwebsite FROM product');
// loop over the rows, outputting them
while ($row = mysql_fetch_assoc($rows)) 
fputcsv($fp, $row);
//close the handler
fclose($fp);