|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
 AT&T devCentral & BlackBerry(r) Webcast Series: BlackBerry and GPS -Build Location Awareness into your BlackBerry Applications, July 10th-1:00PM EST. Register Today!
|
|
#1
August 5th, 2004, 02:12 PM
|
|||
|
|||
|
import
I want to import a csv file to mysql. Is there something that can do this?
I have a table called reports in a database called reports. I have a csv file called test.csv. How can I import this from a webpage? It would be nice to just type into a field box on a webpage the file name and click submit and then it goes and grabs the file and imports it to the table. can this be done????
|
|
#2
August 20th, 2004, 03:06 AM
|
||||
|
||||
|
RE: import
fgetcsv() will get a line and parse it for CSV fields.
You can open the file and iterate through it, use fgetcsv to process the incoming data and then connect and load it up into your database. I heard rumors that phpMyAdmin can do this too, but I don't know for sure as I've no experience with it. There's I've seen a few nice classes at phpclasses.org. -Tim
|
|
| Viewing: Codewalkers Forums > Other > Tutorials > import |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
