3 ways to download remote files with PHP and performance considerations

When exporting Excel today, I always have to test the exported Excel file. Frequent downloading and opening are very troublesome.

I just want to write a piece of code to export Excel on the server side==>Download the Excel file to the local==>and open it.

Here is the PHP solution for downloading remote files as a reminder. The third method takes into account performance issues when the file is too large.

3 options:

-rw-rw-r-- 1 liuyuan liuyuan 470 Feb 20 18:12 test1_fopen.php

-rw-rw-r-- 1 liuyuan liuyuan 541 Feb 20 18:06 test2_curl.php

-rw-rw-r-- 1 liuyuan liuyuan 547 Feb 20 18:12 test3_curl_better.php

Option 1, suitable for small files

Directly use fopen()/file_get_contents() to obtain the file stream and use file_put_contents() to write

//an example xls file form baidu wenku

$url = 'http://bs.baidu.com/wenku4/%2Fe43e6732eba84a316af36c5c67a7c6d6?sign=MBOT:y1jXjmMD4FchJHFHIGN4z:lfZAx1Nrf44aCyD6tJqJ2FhosLY%3D&time=1392893977 &response-content-disposition=attachment;%20filename=%22php%BA%AF% CA%FD.xls%22&response-content-type=application%2foctet-stream';

$fp_input = fopen($url, 'r');

file_put_contents('./test.xls', $fp_input);

exec("libreoffice ./test.xls", $out, $status);

Option 2: Get content through Curl

//an example xls file form baidu wenku

$ch = curl_init($url);

curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

file_put_contents('./test.xls', curl_exec($ch));

curl_close($ch);

exec("libreoffice ./test.xls", $out, $status);

There is a problem with the first and second solutions, that is, the file will be read into the memory before being written to the local disk. When the file is large, it may exceed the memory and crash

Even if your memory is set to be large enough, this is unnecessary overhead

The solution is: directly give CURL a writable file stream to let it solve this problem by itself (via the CURLOPT_FILE option), so you must first create a file pointer for it.

//an example xls file form baidu wenku

$fp_output = fopen('./test.xls', 'w');

$ch = curl_init($url);

curl_setopt($ch, CURLOPT_FILE, $fp_output);

curl_exec($ch);

curl_close($ch);

exec("libreoffice ./test.xls", $out, $status);

Related labels：

download document Remotely

source：php.cn

Previous article：[PHP] small example to show dynamic type change_PHP教程 Next article：php amqp message queue RabbitMQ exchange type direct connection (3)_PHP tutorial

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

3 ways to download remote files with PHP and performance considerations_PHP tutorial