+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: I wanna import my excel or csv files into my mysql database. (/showthread.php?tid=7452)
I wanna import my excel or csv files into my mysql database. - El Forum - 04-09-2008
[eluser]Unknown[/eluser]
I wanna import my excel or csv files into my mysql database.
Is there anyone who tell me how to do.and paste the code here?
Thanks in advance...
I wanna import my excel or csv files into my mysql database. - El Forum - 04-10-2008
[eluser]Unknown[/eluser]
do you have the privileges to install some app like phpmyadmin in your server?
I wanna import my excel or csv files into my mysql database. - El Forum - 04-10-2008
[eluser]GSV Sleeper Service[/eluser]
http://dev.mysql.com/doc/refman/5.0/en/load-data.html
I wanna import my excel or csv files into my mysql database. - El Forum - 04-10-2008
[eluser]Unknown[/eluser]
I mean is there any CI library can import excel files to database....
I wanna import my excel or csv files into my mysql database. - El Forum - 04-10-2008
[eluser]mironcho[/eluser]
I don't know about CI library, but take a look at:
phpExcelReader
fgetcsv function
CSV actually is easy to parse without any additional tools...
I wanna import my excel or csv files into my mysql database. - El Forum - 04-14-2008
[eluser]MadZad[/eluser]
Ditto mironcho's comment - if you can get CSV input, that would be waaaaaaaaaaaaay easier than Excel input.
We already had a copy of Excel Parser Professional by Algera purchased, so that's what I used for reading Excel format, with good results.
I wanna import my excel or csv files into my mysql database. - El Forum - 04-14-2008
[eluser]obobo[/eluser]
Also check out simple cvs import
I just finished using it on a project and it worked fine.
Just upload the php file and the .csv to your server,
edit the php file with your db info and the name of the csv file
run the script and you're done.
I wanna import my excel or csv files into my mysql database. - El Forum - 04-14-2008
[eluser]MadZad[/eluser]
Oh yes, and perhaps the first thing to decide is just how militant you want to be about scrubbing the input. Who has access to the upload utility, and could they have a value in one of the cells like "'); drop database; --"? Always beware of little Bobby Tables.
I wanna import my excel or csv files into my mysql database. - El Forum - 07-28-2011
[eluser]MadZad[/eluser]
For what it's worth, years later we're leaving Excel Parser Pro with our upgrade to PHP 5.3 and CI 2.0, due to the Zend Optimizer complication.
Going with PHPExcel.