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.

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.