importing txt file content

[einSTein]

i want to import wa txt file contains 5000 mail to mysql dabase but i need an easy way not to insert the 5000 mail line by line

[skaykay]

Insert one record manually using phpmyadmin, and see what SQL statement is generated to enter the record. Then do a search and replace in your text file to make all the 5000 lines as per a similar structure. Copy and paste this code in Phpmyadmin->SQL

[sebulbus]

If you have a CSV style formatting in your file it should be easy enough to load with LOAD DATA INFILE.
And even if it's not, I'm sure you can craft a simple PHP script to reformat the text document line after line.
Post us a line of your document, obscure the data, maybe we can give a hint.

[Jake Arkinstall]

Or, if you want, you could store every line in your file to an array, and use a foreach statement to loop through the emails and add the query to a string, for example:

<?
$email_string = file_get_contents("emails.txt");
$email_array = explode("\n", $email_string);
$query_string = "INSERT INTO `emails` (`email`) VALUES ";
foreach($email_array as $line => $email_address){
    if($line > 0){
        $query_string .= ", ";
    }
    $query_string .= "('".$email_address."')";
}
mysql_query($query_string);

Or if you don't want to run the query, but just see it (to check it over), echo $query_string instead of querying it.

[sebulbus]

LOAD DATA INFILE is supposed to work a lot faster and be used for loading a large number of records in a DB, as opposed to inserting each one.
At 5k records, say processing and inserting each and every one takes 1ms, and you still have a 5s processing time. Some hosters timeout their PHP scripts at 2s.