email queue processing backend

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
skolar
Forum Newbie
Posts: 11
Joined: Mon May 09, 2005 12:36 pm

email queue processing backend

Post by skolar »

Hi, i'm kind of new to this so i would greatly appreciate some help.

I'm trying to set up an email processing system that runs in the background. The code needs to be run on an event-driven basis and needs to send information stored in a mysql database. Basically, when a user updates our database, we need to automatically send an email out to a list of users. I could do this with a while loop inside the php, but this would cause the user to wait on the loop to exit, which would be painfully slow. Also, we need to make sure that emails go out successfully.

I've tried working with phplist, but i could not figure out how to send emails to a defined list from inside my php scripts. I dont want to manually send emails. Also, need to be able to add people to lists very simply, just by adding their info to a mysql table, not subscription based.

Can someone help me? I know there is software out there to do this, but i cant seem to find what i need.

I've also been considering setting up a cron job to run every 5 minutes. The job would inspect a mysql table for unsent emails and send them. Is this crazy?
User avatar
patrikG
DevNet Master
Posts: 4235
Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK

Post by patrikG »

moved to PHP Code.
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post by John Cartwright »

viewtopic.php?t=32422&highlight=mass+email is a start.

Please familiarize yourself with our search engine found here
Post Reply