data batch check and insert, because each record needs to be compared with the data already existing in the database, compare the insertion of OK, compare the generated error messages of non-OK, and export an excel file after all execution.
in the past, la was used to check one by one, but the efficiency is very slow, because every time you insert a piece of data, you have to execute a sql statement to verify it.
then pull out the associated data at one time and verify it in php, filter the data that can be inserted to generate an array, and insert it with insert at one time.
efficiency is fast, but will there be any problems?