Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > thinkphp 用phpExcel导出,数据多导不出来

thinkphp 用phpExcel导出,数据多导不出来

WBOY
Release： 2016-06-06 20:11:53
Original
889 people have browsed it

我的框架是Thinkphp 我用phpExcel导出数据，大概只能导出500条，多了就会内存溢出。因为我导出数据不在一个数据表里，需要循环多个表，各位大神有没有什么好的解决方案，或者是phpExcel需要配置什么可以解决这个问题

回复内容：

我的框架是Thinkphp 我用phpExcel导出数据，大概只能导出500条，多了就会内存溢出。因为我导出数据不在一个数据表里，需要循环多个表，各位大神有没有什么好的解决方案，或者是phpExcel需要配置什么可以解决这个问题

你把php 的 最大存储 修改看看

我解决的方案是分段导出，但是你的500条就内存溢出应该优化代码为主，多次查询的字段需要加索引

https://segmentfault.com/q/1010000004388...

Related labels：
php phpexcel thinkphp
source：php.cn
Previous article：php怎么实现下载文件？ Next article：PHP这种写法有什么优点？
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
Latest Articles by Author
Latest Issues
PHP arrays obtained from URL parameters do not behave as expected I have a URL parameter that contains the category ID and I want to treat it as an array li...
From 2024-04-06 22:09:02
0
1
1428
Where should I place CustomLog directive in apache I'm using php:7.2-apachedocker. I need to disable health check url login access log. Based...
From 2024-04-06 22:03:59
0
1
990
What is the format of the variables in the return value? I am a new learner of php. I found a piece of code: if($x<time()){return[false,'error']...
From 2024-04-06 21:55:20
0
1
778
Problems encountered when using opentbs to generate odt files: values ​​of the same key are displayed in the same row instead of separate columns. I'm using a library called OpenTbs to create odt using PHP, I'm using it because columns a...
From 2024-04-06 20:18:18
0
1
483
Group MySQL results by ID for looping over I have a table with flight data in mysql. I'm writing a php code that will group and displ...
From 2024-04-06 17:27:56
0
1
406
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template