How to do checking before importing the csv file by php?
I have a csv file which contains the information with the columns (id, name, telephone , email) and have the database with the same columns. I have the php file which can import the csv into the database. Now,i want to update the information by batch, how can i match the id, name between csv file and database so as to avoid wrong data input (suppose the data in database is correct but that in csv is wrong).
At the end, the php can show the message that your csv data is incorrect! Thanks! Anyone can help?