Outbound Emails

Manat

Hello all,

If I have a table full of emails and names, how do I do outbound email every month telling users of site updates, of all users in our table that requested info.

Thanks
MK

jannoy

i dunno if this is what you are requesting

process your database connections and database selection here

if $query['requested_info']=="YES" {
$mail_to=$query['email'];
$mail_subject="your subject here";
headers = "Content-type: text/html; charset=iso-8859-1\r\n";
$headers .= "From:blah@whatever.com\r\n";
include ("email/email.htm");
$mail_body=your email content file;
or whatever your content here
$mail_body="blah blah blah blah"

if (mail($mail_to,$mail_subject,$mail_body,$headers)){
echo "success";}

}

Manat

Hi,

well I know how to send event-based email to one person. But if I have an already large email database table, how do I take all of them and mass send an email to everyone in my db table?

And have this done once a month? As far as being able to do this in-house, what is the maximum emails you can send at once.
I have a 1-tier architecture. One server with my mysql db, apache and all php and .html files. I has two processors and 1gig of RAM. I know, 1-tier sucks, we are in the works of an upgrade.

But for now, is this possible?

Manat

Anyone?

lazzerous

Manat,

You can just list the email addresses, seperated by commos to send to more than one person at once:

<? 

// process your database connections and database selection here 
// I'll assume you're putting the emails into an array called $emails

$emails = array();
$mail_to = "";
for ($i=0; $i<sizeof($emails); $i++)
  {
  $mail_to .= $emails[$i] . ", ";
  }

$mail_subject="your subject here"; 
$headers = "Content-type: text/html; charset=iso-8859-1\r\n"; 
$headers .= "From:you@email.com\r\n"; 

$mail_body="The is the content of my email" 

if (!mail($mail_to,$mail_subject,$mail_body,$headers))
  { 
  echo "mail failure.";
  }
?>

-=Lazz=-

Manat

Yes, but with my 1-tier infrastructure, will I be able to handle it?
Let's say 1000 outbound emails, or 3000 outbound emails sent out all at once.

Thx

lazzerous

give it a try

jannoy

what i see is that you want to send email every month ? right? so one alternative solution is that use Cronjob, and set your time delay to mail so that there will be an interval between sending emails individual.