Uploading a CSV file to mysql database from a webform

Discussion in 'PHP' started by tanyania, Jun 28, 2011.

0
  1. #1
    Hi Everyone,

    I am going crazy trying to search for solutions to this problem so I thought I'd ask here for help!

    I am trying to upload a csv file through a web form and enter that info into a database. Seems like it should be pretty simple and it should be available out there but I've been losing my mind searching for this.

    Please let me know if you have any help or if you can point me in the right direction!

    Thanks
     
    tanyania, Jun 28, 2011 IP
  2. AdsMakeSense

    AdsMakeSense Active Member

    Messages:
    389
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    70
    #2
    Here is a script I found from a quick search (not my script):

    Source: programmingfacts.com/import-csvexcel-data-mysql-database/
     
    AdsMakeSense, Jun 28, 2011 IP
  3. smartyseo

    smartyseo Member

    Messages:
    164
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    28
    #3
    This is very informative post.i took leaf out of these .
    Thanks for sharing this post.
     
    smartyseo, Jun 28, 2011 IP
  4. kajol

    kajol Well-Known Member

    Messages:
    523
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    108
    #4
    Use LOAD DATA INFILE option instead of using insert into statement.
     
    kajol, Jun 28, 2011 IP