Member Avatar for mpc123

Im looking email members from a database where the emails are stored but also in a seperate table would be the information I want to send to them . I have this code of which i could use manually but

1. how do i get the multiple recipients to go in automatically rather than manually.
2. subject and message of the email from another table

Would be nice if you could help.

<?php
// multiple recipients
$to  = 'aidan@example.com' . ', '; // note the comma
$to .= 'wez@example.com';

// subject
$subject = 'Birthday Reminders for August';

// message
$message = '
<html>
<head>
  <title>Birthday Reminders for August</title>
</head>
<body>
  <p>Here are the birthdays upcoming in August!</p>
  <table>
    <tr>
      <th>Person</th><th>Day</th><th>Month</th><th>Year</th>
    </tr>
    <tr>
      <td>Joe</td><td>3rd</td><td>August</td><td>1970</td>
    </tr>
    <tr>
      <td>Sally</td><td>17th</td><td>August</td><td>1973</td>
    </tr>
  </table>
</body>
</html>
';

// To send HTML mail, the Content-type header must be set
$headers  = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";

// Additional headers
$headers .= 'To: Mary <mary@example.com>, Kelly <kelly@example.com>' . "\r\n";
$headers .= 'From: Birthday Reminder <birthday@example.com>' . "\r\n";
$headers .= 'Cc: birthdayarchive@example.com' . "\r\n";
$headers .= 'Bcc: birthdaycheck@example.com' . "\r\n";

// Mail it
mail($to, $subject, $message, $headers);
?>
  • 2 Contributors
  • 1 Reply
  • 85 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by nonshatter
Member Avatar for nonshatter

In order for the recipients to be generated dynamically, you will need to do a query to fetch the recipients:

<?php

$query = mysql_query("SELECT email_address FROM table WHERE date = someonesbirthdate");

// while there are result email addresses, add them to the recipients lists
while ($results = mysql_fetch_assoc($query))
{
    // multiple recipients array
    $to[]  = $results['email_address'] . ', ';
}
?>

The same would be required for the subject content. Just query the database and while results exist, put them into the a subject variable or array.

Edited by nonshatter because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.