mysql - Use PHPEXCEL to import 5000+ items of data from an excel file into the database. The local database is normal, but only 15 items are imported online. No errors are reported. What is the problem?-PHP Chinese Network Q&A

Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)

mysql - Use PHPEXCEL to import 5000+ items of data from an excel file into the database. The local database is normal, but only 15 items are imported online. No errors are reported. What is the problem?

大家讲道理 2017-05-27 17:38:55

884

Use PHPEXCEL to import 5,000 items of data from the excel file into the database. The local database is normal, but only 15 items are imported online. The EXCEL file can be converted into an array normally, but only 15 items are imported, and the execution time is set to setlimittim 0.
Which part is the problem? ? Thanks to everyone who answered.

大家讲道理

光阴似箭催人老，日月如移越少年。

reply all (2)

世界只因有你2017-05-27 17:40:55 2 floor

How many pieces of data are there when you convert excel content into data in the local test environment? Or you have a field that is empty, but the data table setting is not empty, so the data cannot be inserted into the database