logadas Posted January 4, 2011 Share Posted January 4, 2011 Hi, how to send an automated email to someone using PHP when ever a Ticket's date expires. The date filed in a table stored in MySQL databse. The Ticket table in MySQL has the following fields: 'ticket_id', 'price','purchase_date', 'expiry_date'. I have already tried with MySQL's Event-Handler feature and PHP's send email feature. Also this can not be done by database triggers as triggers are fired only when the trigger event happens(insert/update/delete) . So, I would be very grateful if anyone help this. Thanks. Loga Link to comment https://forums.phpfreaks.com/topic/223378-send-automated-email-from-phpmysql/ Share on other sites More sharing options...
BlueSkyIS Posted January 4, 2011 Share Posted January 4, 2011 what happened with MySQL's Event-Handler? another alternative is to use crontab to execute PHP scripts at set times/intervals. Link to comment https://forums.phpfreaks.com/topic/223378-send-automated-email-from-phpmysql/#findComment-1154700 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.