2. PHPRunner General questions
  3. Email date based.
This topic is locked

Email date based.

 		12/4/2007 11:49:13 AM
PHPRunner General questions
H
 hassanprogrammer author

Hello,

I am trying to have the database send an email 7 days before a particualr date. What I mean is that I have a field in the database called date car to be take for service. I would like to have an email sent to a particular email 7 days before that date and 1 day before that day to a particualr email as a reminder. Can anyone guide or let me know how that can be done. Thanks <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=6976&image=1&table=forumtopics' class='bbc_emoticon' alt=':rolleyes:' />
Sergey Kornilov admin 12/4/2007

You need to write the script that check the date and send the email if required. Setup a cron job to run this script on timely fashion.
H
 		hassanprogrammer author 12/4/2007

You need to write the script that check the date and send the email if required. Setup a cron job to run this script on timely fashion.



Oh you mean this is to be done outside of phprunner. I got no way to do this using phprunner.
D
 		danielesimone 4/4/2009



Oh you mean this is to be done outside of phprunner. I got no way to do this using phprunner.


This Possibility would be very useful, in substance SENDING AN EMAIL ALERT TO THE USER AUTOMATICALLY ABOUT THE TASK TO DO, BIRTHDAY CONGRATULATION, ARRIVAL OR ANYTHING LIKE THIS.Sorry there is by the Time being no Replay by Jane or anybody else if it is possibile to do it inside of PHPRunner.Most needed Alerts and very common are used in CLASSIFIEDS for Example, but not only. I need it very much in my Project too.
Sergey Kornilov admin 4/4/2009

It's not possible without external scheduler like cron. PHP page is only executed when someone opens in in browser. To run a certain PHP script on timely fashion you need an external scheduler.
M
 		mmponline 4/5/2009

Also note that PHP Language (Not PHPRunner) does not handle sending bulk e-mails very well. I've tried some scripts and it normally send small packets of 10 or so e-mails, but just do nothing with a lot of mails. I did some research on the net and it was clear that using PHP for lots of mails is not the way to go.
I plan to investigate the cron job method.
Regards