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 |