PHP - MYSQL：从xml文件更新mysql

Question

I need to enter data into a mysql database from an xml file. I have no problem with regard to entering and updating data.

my problem is with the deletion of data in the database when no longer exists in the xml file.

how do I know which data do not exist anymore in the xml file and delete them in the db?

Thanks!

Answer 1

if you have a common identifier, exists in both XML and db, it's a piece of cake:

1. read all the identifiers from the table into array
2. read XML records one by one and update rows in a db, deleting successfully updated identifiers from the array
3. delete records that remained in array