export data from csv or excel file to Mysql in PHP
Posted: Sat Apr 08, 2006 5:03 am
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
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