Text File - Mysql

[klassicd]

Im trying to dump data from a text file to mysql. The data is formated in this way:

"[e-mail]","carol","kellerhals","109 veeder dr","las vegas","NV","89128","702-254-2061","45"
"[e-mail]","a.","cohen","6794 e. bonanza rd","las vegas","NV","89110","702-463-6569","55"
"[e-mail]","eleanor","aube","22 cedar lane","new paltz","NY","12561","845-255-2983","50"

I could parse it and just run a while loop but I know MySql has some sort of function to insert data from text files like that. Perhaps someone could show me some sample code?

If you dont know perhaps helping me with parsing it. Can i use a method like the one below?

$filename = "/home/htdocs/html/file.txt";  

$fd = fopen ($filename, "r");  

$textFileString = fread ($fd, filesize ($filename)); 
fclose ($fd); 
$pinsArray = explode("\n", $textFileString);  

foreach($pinsArray as $pin) {  

    echo "Preform function here"; 
}

[examancer]

maybe not what you are looking for, but phpMyAdmin will automatically do this.

[klassicd]

I already tried and i got abunch of weird errors.

Warning: chmod failed: No such file or directory in /home/retired/www_public/dbtmp/ldi_check.php on line 33

Warning: Cannot add header information - headers already sent by (output started at /home/retired/www_public/dbtmp/ldi_check.php:33) in /home/retired/www_public/dbtmp/libraries/ob.lib.php on line 53

Then phpmyadmin produces this strange error:

Error

SQL-query :

LOAD DATA LOCAL INFILE '' INTO TABLE email_list FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY '\r\n'

File '' not found (Errcode: 2)

[hcaz32000]

Hey,

I thnk I might be able to help. An easy way to do it in phpmyadmin or shell is to use a code that is like this

Insert (table name) Values
("[e-mail]","carol","kellerhals","109 veeder dr","las vegas","NV","89128","702-254-2061","45")

You have to do that for each vaule. That's the easiest way I can think of. It will make thinks alot easier.

Cya,

[ltm]

You can use the command LOAD DATA . It read records from a file on your server and loads then in bulk into the table.

Syntax:

LOAD DATA LOCAL INFILE '<file name goes here>' INTO TABLE <table name here> FIELDS TERMINATED "\t" LINES TERMINATED BY "\n";

The command can be directly typed from the command prompt.

-hope this helps!