Data entry

bschwarz

How can I get a list of email addresses all into a database.. they don't have an end character or anything, can I somehow run a foreach with every LINE in the text file?

hessian

$file = file("Path/file");
foreach($file as $email)
{
$sql = "INSERT into emails (email) VALUES ('$email');";
...query.
}

bschwarz

I'm trying the following, but its saying that its an invalid argument for the foreach?

<?
	$file = "list.txt";
	if(!($fp = fopen($file, "r"))) die ("cannot open $file");
	$contents = fread ($fp, 1024);
	include("include.php");
	foreach($contents as $email){
		$query = "INSERT INTO (email) VALUES('$email');";
		$result = MYSQL_QUERY($query, $conn); 
	      	if(!$result){ 
	           	die(MYSQL_ERROR()); 
	      	}	
	}
	fclose($fp);
	print $contents;
?>

bschwarz

woops I can see I screwed the query.. but thats not the part that is screwing up.

bschwarz

^ bump.
sorry for the bump.. but I ain't entering 2000 email addresses by hand.

kevinc

You're not looping through each line. You need to actually read the lines inside some form of loop.

For example:

$file = fopen("emails.txt","r");
while(!feof($file)) {
   $email = fgets($file,1024);
   $query = "insert into emails(email) values('$email')";
   mysql_query($query);
}
fclose($file);

That should do it.

Hope it helps.

Kevin

bschwarz

Yep yep, I got it now.
Thanks for the help on that, you've saved my keyboard a good ol' bashing 😉