This script imports the csv data to the mysql database.
- csv file is uploaded using ajax uploader
- Then we click the import button to import to database
The new table is created. Then heading of the csv file is taken as column name and then the csv rows are inserted into the mysql table.
Feel free to contact me to modify the script according to your needsVery simple steps to install on your server
Review and Rating
- Addition:Create table once and use this table afterwards
- Bug fix
- Added client side and server side csv file upload validation
- for those whose first column has no heading (adding random column generation )
- getting first row for ';' fixed
- Added Separator with the file import
- Initial release