Saturday, July 14, 2012

Importing a deliminator-ed .txt or .csv file to MySQL DB, in PHP, directly from web form

Its a common & handy thing to import data, directly into database- by a Website Admin user. Its much more efficient process for the Admin to insert data into table. Else- its kinda boring and irritating procedure to insert into table from 'Add User Form' or Phpmyadmin or whatever.
Import from File MySQL Sample Command

6. Now after a successful import every-time, we can read from this temporary table and populate our actual table & then make this temporary table empty.
- thats all.
Please comment in case of any issue.