Send Email From Db!!!!

obrienkev

Hi all,

I have set up a database containing a persons email address.
In my PHP webpage I want to allow the user the option of emailing that person.

I have it set up so that when the user ticks the check box (corresponding to a person in the database) , and hits Submit an email will be automatically sent to that person stored in the DB.

How do I do this??

Will something like this work.... (can't test it on my server cos php needs 2b upgraded!)

$email=implode(',',$rep); // $rep is name of checkbox

echo '<h2>Thank you '.ucwords($name).' for your email</h2>';
mail($email, $subject, $content, $headers);

What do I set $email variable to???

Thanks very much for your help.

Kevin.

bastien

What value does $rep have? the email addy? or the id of the user?

If the id, then run a query and get the email addy and put that into the $email var.

If its the email addy is in the $rep var, the

$email = $_GET['rep'];

obrienkev

I'm not sure what I'm going to set the value of $rep to.????

Can I do it like this???.......
<input type="checkbox" name="rep[]" value='.$row['email'].'>

'email' is the name of the DB field.

Is this right to send the email???
mail($rep, $subject, $content, $headers);

Thanks for your help.

Kevin.

bastien

Kevin,

You can set the value to whatever you want as long as it related to being able to get the email address for that user. Whether you use the email address or the user's id is immaterial. It might be better to use the ID to to avoid showing the emails to others, though you'd then have to get the emails from the db based on the id....

As to what you have shown with the email as the value...sort of...you will need to change the array from a comma separated one to one that separates with a semi-colon

easiest way to do that is to implode the array with the semi-colon

$rep=$_POST['rep'];

//count the elements in the array if 0 or 1 implode will fail
$count = count($rep);

if ($count ==1){
  $emails = $rep;
}elseif($count==0){
  echo "no persons chosen, can't send emails.";
}else{
   $emails = implode(";",$rep);
}

mail($emails, $subject, $body [,$optional_headers]);