通过终端将PHP生成的CSV文件上传到SFTP服务器(Uploading a PHP generated CSV file to SFTP server via terminal)

 我有一个PHP文件，使用以下代码生成CSV文件： 
 
$filename = $file."_".date("Y-m-d_H-i",time());
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: csv" . date("Y-m-d") . ".csv");
header("Content-disposition: filename=".$filename.".csv");
print $csv_output;
 
 我没有包含创建内容的代码，因为它的工作正常。 我需要做的是使用终端运行此文件并将结果上传到sftp服务器。 我可以在终端连接到服务器。 
 
 我一直在终端中使用php命令生成生成的CSV。 但是，这不会像在浏览器中运行时那样生成CSV。 它做的是将CSV作为字符串生成。 
 
 有没有办法将CSV生成为像浏览器这样的文件，以便我可以在终端中获取它并将其上传到SFTP服务器？ 或者可以回显出PHP文件生成的字符串，并使用这种命令自己创建CSV： 
 
echo "boo,to,you">file.csv

I have a PHP file which generates a CSV file using the code below:
 
$filename = $file."_".date("Y-m-d_H-i",time());
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: csv" . date("Y-m-d") . ".csv");
header("Content-disposition: filename=".$filename.".csv");
print $csv_output;
 
I've not included the code which creates the content as it does it's job fine. What I need to do is use terminal to run this file and upload the results to an sftp server. I can connect to the server fine in terminal.
 
I have been using the php command in terminal to produce the resulting CSV. This however doesn't produce the CSV like it does when run in the browser. What it does do is produce the CSV as a string. 
 
Is there a way to either produce the CSV as a file like the browser so I can grab it in terminal and upload it to the SFTP server? Alternatively is it possible to echo out the string produced from the PHP file and create the CSV myself using this kind of command:
 
echo "boo,to,you">file.csv

原文：https://stackoverflow.com/questions/27508296