使用php邮件向多封电子邮件发送消息

Question

I have a table below in MYSQL

Mmeber_Email---------------Member_Name------Data---
[e-mail]  --------  Mike ---------- 100 ------
[e-mail]  --------Jack -----------50 ----
[e-mail]  -------Jill ---------- 75 ------
[e-mail]  --------   John ---------- 10 ------

Now, I have managed to extract the data from the database using PHP. but i don't know how to email the data of each member on their respective email using PHP Mail function. How should i tackle the problem of sending emails to multiple recipients using the PHP mail function below i.e Mike Should get the email containing the message 100, Jack 5 and so on..

<?php
$to = "[e-mail]";
$subject = "My subject";
$txt = //data extracted from database using a common query comes here
$headers = "From: [e-mail]";

mail($to,$subject,$txt,$headers);
?>

Answer 1

You would need to loop through the results returned from MySQL. Here is an example:

while($row = mysqli_fetch_array($results)) { // start loop

    $to       = $row['member_email']; 
    $subject  = 'the subject'; 
    $message  = "Dear ". $row['member_name'] . "
";
    $message .= "Here is your data: " . $row['member_data'] . "
";
    $headers = 'From: [e-mail]' . "
" .
       'Reply-To: [e-mail]' . "
" .
       'X-Mailer: PHP/' . phpversion();

    mail($to, $subject, $message, $headers);
}

The data from your database is contained in the $row array setup by the while{} loop.

Make sure to pay attention to the details for mail in the docs.