Upload .CSV file and use its contents to create a db table
I'm building a multi language website and would like some help with a problem
When the user wishes to update or add a new language I give them the option to download the db table as a .csv file, which I have got working
what i'd like to do now is create a from with an upload file field which then reads the .csv file and recreates the db table.
creating the form to upload the file is not a problem, but its once the file is uploading how to handle it and create the sql to create the table with the new values.
would anybody have any links or resources to where I might be any to find a solution???