Php Large Volume Of E-mail

rashid100

Hi,

Can any body tell me that how to send large volume e-mails like more than 10000 emails at once time through mysql database in PHP.

Thanks

djjjozsi

rashid100;10972191 wrote:
Hi,

Can any body tell me that how to send large volume e-mails like more than 10000 emails at once time through mysql database in PHP.

Thanks

In my opinion 10 000 email is too huge to send in a session!
Find a dedicated server to handle mailing lists/ newletters.
...or...
You should create a table to store outgoing emails, and use CRON (with 2 minutes refresh) to repeatedly call a .php program to send X (up to 100) emails in a session from this table. And use a text file or a table to save the last ID where you need to continue the process.
I usually build some logic into newletter senders, to group the email addresses:
send only X from @server_a.com , X from @server_b.com in a session, to make sure your address won't be blocked for mass mail!

rashid100

Thank you very much for reply do you have any example so I can get some idea

djjjozsi

ok, in a nutshell:
-table to store email messages:
messages table:
m_id (PK),
subject,
htmlmessage,
lastemailid (value related to your email_addresses table)
active (actual newsletter to send, you set this status in your admin panel)

-sql query to get messages to send in limit?
where do you need to continue your sending:

"select * from messages WHERE active=1"

You can retrieve $lastemailid in your php program, you have $subject and $htmlmessage. Now you have to get email addresses from the table ( email_addresses )
-Get the email messages beginning from $lastemailid:

$sql="select * from email_addresses ea WHERE emailid>$lastemailid  ORDER BY emailid LIMIT 100";

These results insode the cycle can be sent out ( examples to go through your results is on php.net mysql_fetch_assoc() )

-method to send:
You should not use the simple mail() function in this program, phpmailer is highly recommended.

bradgrafelman

Also note that there is a PEAR class designed to handle this scenario: Mail_Queue.

Sops21

djjjozsi;10972197 wrote:
ok, in a nutshell:
You should not use the simple mail() function in this program, phpmailer is highly recommended.

I second the recommendation for using phpmailer. I've used it on several ocasions and its much better than using mail().

If you have some budget, you might consider using someone like sengrid.com to help you send out you mail. You can use their api to send out the mail. As a plus you don't have to worry about getting your IP blacklisted because you will be using theirs.

Just a thought