Sending massive amount of emails

[Pain]

Hello. I have a problem. 

 

I am trying to send approximately 1200 emails at once. Each email has to be retrieved from the database. 

<?php
...
$query = mysql_query("SELECT * FROM mass_subscribers");
while($row = mysql_fetch_assoc($query)) {
   $email = $row['email'];
   $name = $row['name'];
 
   $mail = new SendGrid\Mail();
   $mail->
   setTo($email)->
   setFrom('me@yahoo.com')->
   setSubject($subject)->
   setText($message)->
   setHtml($message);
  
   $sendgrid->web->send($mail);
}
...
?>

 

Problem is the loop gets executed 1200 times which causes 500 error. Is there any way around this? Thank you, any advice appreciated guys.

Edited November 28, 2013 by Pain

[banfw001]

Could you not import your email addresses into a list array, then send the email from the list array

[Pain]

Are you referring to the php's list() function?

Can you explain this in more detail please? Thank you.

Edited November 28, 2013 by Pain

[Pain]

I did put all the emails into an array. 

$email = array();
$name = array();
 
 
 $query = mysql_query("SELECT * FROM test");
 while($row = mysql_fetch_assoc($query)) {
 
            $name[] = $row['name'];
            $email[] = $row['email'];
 
 
 
         }
 
$email = implode(",", $email);
$name = implode(" ", $name);

This is now the main problem as the email gets sent to the first recipient in the database only.

 
$mail = new SendGrid\Mail();
             $mail->
             addTo($email)->
             setFrom('test@test.com')->
             setSubject($subject)->
             setText($message)->
             setHtml($message);
  
             $sendgrid->web->send($mail); 

PHPs built-in mail () function works properly, but i have to use sendgrid for this one. I'm lost:/

Edited November 28, 2013 by Pain

[jazzman1]

Can I see the format of all emails after imploding?

while($row = mysql_fetch_assoc($query)) {
 
            $name[] = $row['name'];
            $email[] = $row['email'];
 
 
 
         }
 
$email = implode(",", $email);

echo $email; 

[Pain]

Email@yahoo.com,email2@yahoo.com,email3@yahoo.com etc.

[jazzman1]

Try to add manually more than one email.

Something like -

<?php
$mail = new SendGrid\Mail();
$mail->
  addTo('foo1@bar.com','foo2@bar.com','foo3@bar.com')->
  setFrom('me@bar.com')->
  setSubject('Subject goes here')->
  setText('Hello World!')->
  setHtml('<strong>Hello World!</strong>');

// send emails
  $sendgrid->
  web->
  send($mail);

?>