CodeIgniter Forums
how to import csv file in mysql database - Printable Version

+- 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: how to import csv file in mysql database (/showthread.php?tid=29316)



how to import csv file in mysql database - El Forum - 04-05-2010

[eluser]php beginner[/eluser]
how to import csv file in mysql database


how to import csv file in mysql database - El Forum - 04-06-2010

[eluser]Imran Tariq[/eluser]
You should follow the following steps.
1. Upload a CSV file to your server.
2. Manipulate it (using fopen() and fgetcsv()).
3. Generate a query for each record.
4. Execute that query.

Hope it will help.


how to import csv file in mysql database - El Forum - 04-06-2010

[eluser]php beginner[/eluser]
thanks for reply but my problem is solve


how to import csv file in mysql database - El Forum - 02-20-2014

[eluser]kiddev[/eluser]
can you give me a source code of your work?



how to import csv file in mysql database - El Forum - 02-20-2014

[eluser]Imran Tariq[/eluser]
Just to let you know that I have converted my code snippet in an advance shape in which you can associate CSV columns to MySQL Table fields. I will be able to post my code in a couple of days.


how to import csv file in mysql database - El Forum - 02-20-2014

[eluser]kiddev[/eluser]
ok ill wait for it, but can you make it quick. thanks