Data loss in excel database import (good or bad)

: This article mainly introduces the problem of data loss (when the excel file is imported into the database). If you are interested in the PHP Tutorial, please refer to it. Recently, the excel file import resume function has been developed. when importing an excel file, the data inserted into the database is often incomplete (only part of the data ), therefore, data in the obtained excel table is printed before insertion,

Rich text objects (consisting of unformatted text, control words, and control symbols, such as fonts in excel, including,, and so on) are printed ), this is the root cause of insertion failure.

Solution: type conversion to string

Before change:

After modification:

The problem has been solved. it is so simple that I hope it can help you!

The above introduces the problem of data loss (when the excel file is imported into the database, good or bad), including some content, hope to be helpful to friends who are interested in PHP tutorials.