SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Hybrid View

  1. #1
    SitePoint Enthusiast
    Join Date
    Jul 2006
    Posts
    81
    Mentioned
    0 Post(s)
    Tagged
    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???

    Thanks

  2. #2
    Programming Team silver trophybronze trophy
    Mittineague's Avatar
    Join Date
    Jul 2005
    Location
    West Springfield, Massachusetts
    Posts
    17,154
    Mentioned
    190 Post(s)
    Tagged
    2 Thread(s)

    csv import

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


Bookmarks

Posting Permissions

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