How would I transfer the contents of this text file into my database?

[Shpigford]

I have a client who was using a mailing list script that stored all the addresses in a .txt file with each address separated by a "%". Now I would like to transfer all of those addresses to a MySQL database. What do I need to do to loop through all the addresses and insert them into the database?

[devscripts]

1.fopen the file first sorry.

2. fread() the file contents
3. explode() it using % as separator
4. insert into database.

[devscripts]

heres sample taken from php.net fread

<?php
// get contents of a file into a string
$filename = "/usr/local/something.txt";
$handle = fopen($filename, "rb");
$contents = fread($handle, filesize($filename));
fclose($handle);
?>

now you can use explode here since you said emails separated by % so we do this..

$emails=explode("%",$contents);

and you get an array of

echo $emails[0];
echo $emails[1];

and so on. loop it to get all.

)