Import Excel data in to mysql with PHP

Discussion in 'PHP' started by dilip1030, Aug 11, 2010.

  1. dilip1030

    dilip1030 New Member

    Joined:
    Jun 14, 2010
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    Can somebody send me PHP code which will read an excel file and write the data of that excel file into database. It should also read multiple tabs of that excel file and perform the same operation.

    Thanks
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
  3. dilip1030

    dilip1030 New Member

    Joined:
    Jun 14, 2010
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    Well I could have done but what I need to do is I have to allow the user to upload an Excel file everyday and that data will be inserted in to the database. So as I cannot give the user access to PHPmyadmin or Cpanel I'm giving an option to him to upload the excel file through the interface that I'm developing currently.
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice