Results 1 to 2 of 2
Aug 16, 2007, 04:56 #1
- Join Date
- Jul 2006
- 0 Post(s)
- 0 Thread(s)
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???
Aug 16, 2007, 08:38 #2
- Join Date
- Jul 2005
- West Springfield, Massachusetts
- 191 Post(s)
- 2 Thread(s)
Maybe you're looking for LOAD DATA INFILE ??
There are many scripts online, google - "php csv importer"► STOP using mysql - migrating to procedural mysqli !!
► How to be a Great Online Community Member
► Member of the Month for July 2014 - Patche
► Free SitePoint book - Thinking Web: Voices Of The Community
► On Our Radar This Week: ---
Big Change Coming Late August What you need to do to prepare for our migration to Discourse