Problems with timeouts with illegal characters appearing with Phpexcelreader
Source: Internet
Author: User
Illegal character and timeout problems using Phpexcelreader
Notice:iconv () [Function.iconv]: detected an illegal character in input string in D:\WebSite\htdocs\phpExcelReader\Excel \reader.php on line 1055
Fatal error:maximum execution time of seconds exceeded in D:\WebSite\htdocs\ex_cmk.php on line 38
My current is to import an Excel file into MySQL inside, tried several times can. This is not the case, ask the Friends of the lake, who knows
What does that mean? How to solve this problem? Excel files are relatively large.
I tried to reduce the number of rows, that is, there are more than 600 lines in the original file. I tried an interrupt setting to 200 lines because I had a file of almost 200 lines,
The import did not appear to be problematic. After the experiment, you can import but there is a problem
notice:undefined variable:formatstr in D:\WebSite\htdocs\phpExcelReader\Excel\reader.php on line 635
I still want to know what causes it.
I'm using Phpexcelreader. On this network, I didn't find the ability to upload attachments.
------Solution--------------------
The first is a iconv () character encoding conversion error.
The second maximum execution time of seconds is PHP execution timeout.
------Solution--------------------
Detected an illegal character in input string of D:\WebSite\htdocs\phpExcelReader\Excel\reader.php on line 1055
For this reason, it is estimated that special characters appear in Excel.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service