How to save Excel sheet data into MYSQL database using php?

twinkle2010

New Member

Join Date: Jun 2010

Posts: 1
#1

How to save Excel sheet data into MYSQL database using php?

Jun 18 '10, 06:38 AM

Hi I am a new web programmer.I got an issue that reads the excel sheet data and store it to MYSQL database using php. I dont have any idea on that. can you help me?
Tags: None
dlite922

Recognized Expert Top Contributor

Join Date: Dec 2007

Posts: 1586
#2

Jun 18 '10, 07:43 AM

use file to read the file, explode or regular expressions to search for your data, then use mysql queries to do inserts.

If you don't know any of these, you must learn how to program in PHP first.

Dan
Comment

Comment