Welcome Guest, Not a member yet? Register   Sign In
how to import csv file in mysql database
#1

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

[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.
#3

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

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

[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.
#6

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




Theme © iAndrew 2016 - Forum software by © MyBB