dongsou3041 2014-12-16 15:40
浏览 99
已采纳

通过终端将PHP生成的CSV文件上传到SFTP服务器

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
  • 写回答

1条回答 默认 最新

  • donglin6659 2014-12-17 08:41
    关注

    Just redirect the php output to a temporary file and upload the file.

    php yourscript.php > /tmp/file.csv
    echo "put /tmp/file.csv" | sftp user@example.com
    

    If you want to do it without the temporary file, you cannot do with just the (OpenSSH) sftp as it cannot read contents to upload from the stdin. Neither the (OpenSSH) scp can.


    You can of course produce the file from PHP code itself, if that suits your task better.

    Just use the file_put_contents():

    file_put_contents("/tmp/file.csv", $csv_output);
    

    See How to write into a file in PHP?


    The suggestion by @MarcB should work, if the remote server is *nix (understands the cat) and allows a shell access.

    php yourscript.php | ssh user@example.com 'cat > file.csv'
    

    Though obviously that's not "SFTP upload" anymore.


    When producing a file, do not use the the header(). Headers make sense in webserver environment only, not when you use the PHP as a scripting language in a shell.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥60 pb数据库修改或者求完整pb库存系统,需为pb自带数据库
  • ¥15 spss统计中二分类变量和有序变量的相关性分析可以用kendall相关分析吗?
  • ¥15 拟通过pc下指令到安卓系统,如果追求响应速度,尽可能无延迟,是不是用安卓模拟器会优于实体的安卓手机?如果是,可以快多少毫秒?
  • ¥20 神经网络Sequential name=sequential, built=False
  • ¥16 Qphython 用xlrd读取excel报错
  • ¥15 单片机学习顺序问题!!
  • ¥15 ikuai客户端多拨vpn,重启总是有个别重拨不上
  • ¥20 关于#anlogic#sdram#的问题,如何解决?(关键词-performance)
  • ¥15 相敏解调 matlab
  • ¥15 求lingo代码和思路