SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    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???


  2. #2
    Programming Team silver trophybronze trophy
    Mittineague's Avatar
    Join Date
    Jul 2005
    West Springfield, Massachusetts
    198 Post(s)
    3 Thread(s)

    csv import

    Maybe you're looking for LOAD DATA INFILE ??
    There are many scripts online, google - "php csv importer"


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts