Send an HTML email to all users in database
Posted: Wed May 21, 2008 12:23 am
Hi guys,
Firstly, awesome forums. Going to be spending a lot of time here I think. Anyways, I'd like to get your input and suggestions on how to go about sending a newsletter to my database of users.
I have a community web site running phpBB 3, and members also have a second login for adding content to my site using a CMS that I built for the job.
I would like to send out a newsletter to all the email addresses in my phpBB users table, and also those in the other users table.
Up until now I have been using phplist. But it doesn't share the same database. Every time I want to send an email, I have to update the list of users in phplist by exporting all the email addresses from phpBB and inserting them into phplist. It's a pain.
I really want to do something more automated than this. Now I know how to create and send AN HTML email using PHP. No Sweat. I was going to try just running a do / while loop until it had run through all the users. But my friend told me that my php script would time out before it sent to everyone. He said that there was a more suitable method for sending emails in large batches like this.
So my question is.. How does one go about sending a newsletter to all users in a database without taxing the system or having your PHP script timeout?
Obviously I'd have to send in batches etc etc.. but thing that I'm unsure about is what do I use to send the emails if my script is just going to time out?
Any help is greatly appreciated.
Kind Regards
Scott
Firstly, awesome forums. Going to be spending a lot of time here I think. Anyways, I'd like to get your input and suggestions on how to go about sending a newsletter to my database of users.
I have a community web site running phpBB 3, and members also have a second login for adding content to my site using a CMS that I built for the job.
I would like to send out a newsletter to all the email addresses in my phpBB users table, and also those in the other users table.
Up until now I have been using phplist. But it doesn't share the same database. Every time I want to send an email, I have to update the list of users in phplist by exporting all the email addresses from phpBB and inserting them into phplist. It's a pain.
I really want to do something more automated than this. Now I know how to create and send AN HTML email using PHP. No Sweat. I was going to try just running a do / while loop until it had run through all the users. But my friend told me that my php script would time out before it sent to everyone. He said that there was a more suitable method for sending emails in large batches like this.
So my question is.. How does one go about sending a newsletter to all users in a database without taxing the system or having your PHP script timeout?
Obviously I'd have to send in batches etc etc.. but thing that I'm unsure about is what do I use to send the emails if my script is just going to time out?
Any help is greatly appreciated.
Kind Regards
Scott