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.
  • 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.