php email multiples?

[dezkit]

whats the code so i can send to multiple people?

 

<?php
$to = "[email protected]";
$subject = "dasd";
$body = "sdadas";

if (mail($to, $subject, $body, $headers)) {
  echo "sadar has been sent.";
} else {
  echo "asddsa has not been sent.";
}
?>

[ohdang888]

query for the emails stored in a table...

 

while($row = mysql_fetch_assoc($result)){ 

 

send email stuff.

 

 

}

 

EDIT: you shouldn't include multiple emails an email sent on a newsletter.... That would give away everyone's email address to everyone on the list to see.

 

[dezkit]

oh, according to the edit you did for your post, what should i do then?

[dezkit]

admin.php

<?php
mysql_connect("mysql", "xxx", "xxx") or die(mysql_error());
mysql_select_db("newsletter") or die(mysql_error());

$result = mysql_query("SELECT * FROM users") 
or die(mysql_error());  

echo "<form action='admin2.php' method='post'><textarea name=body1 cols=45 rows=10></textarea><input type=hidden name=to1 value='";

while($row = mysql_fetch_array( $result )) {
echo $row['email'];
        echo ", ";
}

echo "'><br><input type=submit value=Submit></form>";

?>

 

 

admin2.php

<?php
$to = "$to1";
$subject = "xxxxxxx";
$body = "$body1";

if (mail($to, $subject, $body, $headers)) {
  echo "Newsletter has been sent.";
} else {
  echo "Newsletter has not been sent.";
}
?>

 

 

 

 

correct my code, will ya

[ohdang888]

the code i posted.

 

query to get the all the email addresses stored in a table

the WHILE will continue to loop until all results are gone through.

 

so place all the email code in between the while brackets

[dezkit]

meh, I don't understand still haha,

I posted a code above, can you or somebody please correct it. I am not a mysql wiz  :'(

[ohdang888]

what are you trying to do, mail a newletter?

[dezkit]

yeah.

[dezkit]

index.php

<?php
$ip = getenv("REMOTE_ADDR") ;
?>

<form action="newsletter.php" method="post">
Email: <input type="text" name="email">
<input type="hidden" name="ip" value="<? echo $ip ?>">
</form>

 

newsletter.php

<?php

$email = $_POST['email'];
$ip = $_POST['ip'];

// Make a MySQL Connection
mysql_connect("mysql", "dezkit", "xxxxxxx") or die(mysql_error());
mysql_select_db("newsletter") or die(mysql_error());

// Insert a row of information into the table "example"
mysql_query("INSERT INTO users 
(email, ip) VALUES('$email', '$ip' ) ") 
or die(mysql_error());  

echo "Thank you for registering for our newsletter!";

?>

 

admin.php (not password protected page, yet.)

<?php
mysql_connect("mysql", "dezkit", "xxx") or die(mysql_error());
mysql_select_db("newsletter") or die(mysql_error());

$result = mysql_query("SELECT * FROM users") 
or die(mysql_error());  

echo "<form action='admin2.php' method='post'><textarea name=body1 cols=45 rows=10></textarea><input type=hidden name=to1 value='";

while($row = mysql_fetch_array( $result )) {
echo $row['email'];
        echo ", ";
}

echo "'><br><input type=submit value=Submit></form>";

?>

 

admin2.php

<?php
$to = "$to1";
$subject = "xxxxxxx";
$body = "$body1";

if (mail($to, $subject, $body, $headers)) {
  echo "Newsletter has been sent.";
} else {
  echo "Newsletter has not been sent.";
}
?>

[dezkit]

I found the problem! i had a space after the "," !

 

I AM SO HAPPY, THIS IS MY VERY FIRST SCRIPT I DID IN MYSQL!

[$username]

You should mark this as solved.

[dezkit]

i always thought about that, but where is the link to press it?

[$username]

Looks like its gone.

 

http://www.phpfreaks.com/forums/index.php/topic,118758.60.html

 

That Sux it was nice to have.

[redarrow]

There no headers in your mail code.............

 

also you got to valadate the users input,,,,

 

your also using the users ip that bad programming pratice use a id....

 

 

also consider adding a CATCHA so bots dont spam

 

also add a flood protection so users dont post data all the time............

 

you also need to add mysql_real_escape_string() function to protect database from users..