Invalid characters in PHPexcelreader are related to timeout.
Source: Internet
Author: User
Invalid PHPexcelreader characters and timeout Notice: iconv () [function. iconv]: DetectedanillegalcharacterininputstringinD: \ WebSite \ htdocs use PHPexcelreader illegal characters and timeout problems
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 30 seconds exceeded in D: \ WebSite \ htdocs \ ex_cmk.php on line 38
Currently, I have imported an EXCEL file into MYSQL, and I have tried it several times. This is not the case. may anyone in the world know this?
What does the above mean? How can we solve this problem? The excel file is relatively large.
I tried to reduce the number of rows, that is, the original file contains more than 600 rows. I tried setting an interrupt to 200 rows, because I have a file with more than 200 rows,
There is no problem with the import. After the test, you can import the data, 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 why.
I am using phpexcelreader. this is available on the network. I have not found the function for uploading attachments.
------ Solution --------------------
The first is an error in iconv () character encoding conversion.
The second Maximum execution time of 30 seconds indicates that PHP execution times out.
------ Solution --------------------
Detected an illegal character in input string in D: \ WebSite \ htdocs \ phpExcelReader \ Excel \ reader. php on line 1055
This is probably because a special character exists 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