xls

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
madu
Forum Commoner
Posts: 32
Joined: Sat Dec 25, 2010 3:19 am
Location: india

xls

Post by madu »

hi friends,,,,,
hi friends can you say how to import ms excel data into mysql,,,,,,,,,using php queries only,,,,,
User avatar
Darhazer
DevNet Resident
Posts: 1011
Joined: Thu May 14, 2009 3:00 pm
Location: HellCity, Bulgaria

Re: xls

Post by Darhazer »

madu wrote:hi friends,,,,,
hi friends can you say how to import ms excel data into mysql,,,,,,,,,using php queries only,,,,,
Use the PHPExcel library. The easiest way is if you save excel file as csv (with PHPExcel) and then you can either use LOAD DATA INFILE (if the database server is on the same machine) or use fgetcsv PHP function and create SQL queries
Post Reply