php 保存 csv文件,使用PHP创建CSV文件并将其保存到目录中

我是PHP的新手.我正在创建一个脚本,它应该创建一个csv文件,其中包含我数据库中的一些数据,并将其保存到我服务器上的目录中.

我以某种方式完成了它,但这个文件总是下载.我不希望它下载.它应该保存到目录中.

以下是您的帮助的完整代码.

请帮帮我.

$MYSQL_HOST="localhost";

$MYSQL_USERNAME="root";

$MYSQL_PASSWORD="";

$MYSQL_DATABASE="paesana";

$MYSQL_TABLE="ds_orders";

mysql_connect( "$MYSQL_HOST", "$MYSQL_USERNAME", "$MYSQL_PASSWORD" ) or die( mysql_error( ) );

mysql_select_db( "$MYSQL_DATABASE") or die( mysql_error( $conn ) );

$filename="ePay";

$csv_filename = $filename."_".date("Y-m-d_H-i",time()).".csv";

header("Content-Type: application/vnd.ms-excel");

$today="2008-12-21";

$sql = "SELECT * FROM $MYSQL_TABLE where cDate='$today'";

$result=mysql_query($sql);

if(mysql_num_rows($result)>0){

$fileContent="Beneficiary Name,Beneficiary Account No,Beneficiary Bank Code,Transaction Amount,Narration\n";

while($data=mysql_fetch_array($result))

{

$fileContent.= "".$data['customer_id'].",".$data['oNum'].","."$today".",".$data['cShipService']." ".$data['cShipMethod'].",".$data['cEmail'].",".$data['ccType'].",".$data['cShipInstruct'].",".$data['cShipFname']." ".$data['cShipLname']."\n";

}

$fileContent=str_replace("\n\n","\n",$fileContent);

echo $fileContent;

}

header("content-disposition: attachment;filename=$csv_filename"); ?>