Script that recognises the name of a column in a CSV file and matches it to the correspondent column, with the same name, in a MySql database

[Sarah Raniero]

Hi,

we are using PHP and MySql for our application.

we have many CSV files with different fields' order and some fields are empty, for example:

- CSV1 has the following fields order: name, description, date, address, phone
- CSV2 has the following fields order: address, description, name, date
- CSV3 has the following fields order: name, address

To upload these data in our database (and then online), we now need to have all the CSVs' fields always in the same order, so for example: name, descrition, phone, address, date. To do this we need to manually move the columns in the CSVs.

My question is: if the CSV files have the columns in a different order (but with the same field names), is it possible to match a CSV column to its right position in the database,
without having to edit manually the position of the columns in the CSV?

So basically a script that recognise the name of a column in a CSV file (for ex. address) and match it (and its content) to the correspondent column in our MySql database.

Many thanks,
Sarah