数据库到CSV（完成）尝试将文件保存到服务器上的文件夹 [英] Database to CSV(Done) trying to Save file to folder on server

问题描述

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

I've have been successful in exporting my database to csv as a downloadable file. However what I now need to do is instead of creating a straight .csv file that's downloaded I need it to just save to a folder called "csv" on the server. Here is my code for the current export. I need help in the saving it to server. I'm not saving the data correctly.

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

推荐答案

为什么在流中写入，读取它，保存内容？
我会以更小的方式做：

Why do write in streams, read it and than try to save the content? I would do it in a smaller way:

//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); 

这篇关于数据库到CSV（完成）尝试将文件保存到服务器上的文件夹的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！