How to implement php data export

php中世界最好的语言
Release: 2023-03-26 16:32:02
Original
2635 people have browsed it

This time I will show you how to implement PHP data export, and what are the precautions for PHP data export implementation. The following is a practical case, let's take a look.

It is very easy to use at first, but when the data that needs to be exported reaches tens of thousands, it will directly cause the problem of insufficient memory.

Then I found several solutions.

Front-end solution

PHP cooperates with SheetJS/js-xlsx to export a large amount of Excel data

The advantage of this solution is that it does not require additional interfaces, but it does Depends on front-end developers.

Export to csv

This solution is faster and fully back-end implemented. The disadvantage is that the csv format has relatively high requirements on the export form. It requires pure data and cannot There are rich text forms such as images.

The following mainly introduces how to export csv

Introduction to php official documentation

<?php
$list = array (
  array(&#39;aaa&#39;, &#39;bbb&#39;, &#39;ccc&#39;, &#39;dddd&#39;),
  array(&#39;123&#39;, &#39;456&#39;, &#39;789&#39;),
  array(&#39;"aaa"&#39;, &#39;"bbb"&#39;)
);
$fp = fopen(&#39;file.csv&#39;, &#39;w&#39;);
foreach ($list as $fields) {
  fputcsv($fp, $fields);
}
fclose($fp);
?>
Copy after login

Export complete example

<?php
$name = &#39;test&#39;;
header ( "Content-type:application/vnd.ms-excel" );
header ( "Content-Disposition:filename=".$name.".csv" );
header (&#39;Cache-Control: max-age=0&#39;);
//打开PHP文件句柄,php://output 表示直接输出到浏览器
$fp = fopen(&#39;php://output&#39;, &#39;a&#39;);  
// 写入BOM头,防止乱码
fwrite($fp, chr(0xEF).chr(0xBB).chr(0xBF)); 
// 生成的测试数据
function test()
{
  for ($i=0; $i < 150000; $i++) {
    yield [&#39;name&#39;, $i, &#39;男&#39;];
  }
}
// 表头
$headers = [&#39;名字&#39;, &#39;年龄&#39;, &#39;性别&#39;];
fputcsv($fp, $headers);
foreach (test() as $value) {
  fputcsv($fp, $value);
}
fclose($fp);
?>
Copy after login
In laravel Used in conjunction with chunk, all data can be easily and quickly exported.

I believe you have mastered the method after reading the case in this article. For more exciting information, please pay attention to other related articles on the php Chinese website!

Recommended reading:

Detailed explanation of the use of php namespace

thinkphp5 migrateDetailed explanation of database migration usage

The above is the detailed content of How to implement php data export. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!