Home >Backend Development >PHP Tutorial >Use php to read excel and insert into mysql
Use php to read excel and insert into mysql
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-07-06 13:52:28780browse
How to read and then import more than 400,000 pieces of data in excel
I tried twice using phpexcel but failed.
Reply content:
How to read and then import more than 400,000 pieces of data in excel
I tried twice using phpexcel but failed.
Save excel as a csv file first, then read the csv and write it to mysql
It is too inefficient to directly process such a large excel.
fputcsv
Statement：
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
Previous article：Problems with const variables and connectorsNext article：Problems with const variables and connectors