预览 CSV to SQL importer 等待分享

This script imports the csv data to the mysql database.csv file is uploaded using ajax uploader Then

  1. 0daydown
    [​IMG]
    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
    Logic

    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.
    Support

    Feel free to contact me to modify the script according to your needs​
    Very simple steps to install on your server [​IMG]
    Demo


    username: admin
    password: admin

    Review and Rating

    [​IMG]
    Change Log

    Version 1.5

    - Addition:Create table once and use this table afterwards

    Version 1.4

    - Bug fix

    Version 1.3

    - Added client side and server side csv file upload validation

    Version 1.2

    - for those whose first column has no heading (adding random column generation )
    - getting first row for ';' fixed

    Version 1.1

    - Added Separator with the file import

    Version 1.0

    - Initial release