i want to export the data from a csv or exel file to mysql data base in php plz provide me the solution or code for this
three approaches can be there
a.) first upload a file through php code and then tranferring the data to mysql database.
b.)second the file is still on the client and i dont want the file on the server i just wants its data to be imported to mysql database.
c.)I upload the file through some ftp tool to the server and from there i am entering the data to mysql database.
speedy assistance is soliciated
Thanx
export data from csv or excel file to Mysql in PHP
Moderator: General Moderators
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
Take a look at phpclasses.org. They have quite a few classes there.
You can upload the data in a .csv into a table using phpMyAdmin.