email from database

Question

mpc123 15 Junior Poster in Training

13 Years Ago

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);
?>

php

2 Contributors
1 Reply
84 Views
7 Hours Discussion Span
Latest Post 13 Years Ago Latest Post by nonshatter

Reply to this topic

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.

nonshatter 26 Posting Whiz · Answer 1 · 2010-09-24T21:32:09+00:00

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.