title: PHP Upload CSV to update database records but exclude duplicate
body: <p>I'm trying to figure out the best way to do this. I have a database with around 500 records/rows in MySQL and I need to update it daily. The problem is the file I upload will be Excel file (I probably need to convert it to CSV before upload?). Also I need to only upload records that don't exist yet in the current MySQL Database. The Unique field is named "MemberID".</p>
  
  <p>What is the best way to achieve this? If I insert each rows (so I can check first if the record/row should be inserted to the Database) one by one like using a loop, will that be a slow process for uploading 500 records?</p>
  
  <p>I'm new to PHP from VBA Programming and I only know how to insert records one at a time. Your suggestions is most appreciated.</p>