PHP page to insert records from CSV to Mysql with some validations

We need a PHP page to insert records from CSV to Mysql with some validations There are 6 fields in the CSV file. Procedure would be 1. User selects CSV file from browse button 2. The data is inserted (3 columns) into first Table A 3. Retrieve Auto generated Id from Table A and insert rest 3 columns in Table B 4. While inserting records in Table B check if records exist, if it does do not insert that particular record and show error in a PHP page about duplicate records You can use the following to load CSV file: MySQL has a feature LOAD DATA INFILE, which allows it to import a CSV file directly in a single SQL query, without needing it to be processed in a loop via your PHP program at all. Example: <?php $query = <<<eof LOAD DATA INFILE '$fileName' INTO TABLE tableName FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' (field1,field2,field3,etc) eof; $db->query($query); ?>