Reputation: 1
We are running a webinar. I want to send reminder email to all those registered on my site 3 days before the webinar.
The registrant details are in my MySQL and it is a PHP website.
How do I do that?
Any help would be highly appreciated!
Thanks,
Upvotes: 0
Views: 9518
Reputation: 6499
PHP doesn't have built-in schedulers.
You should consider using cron
on unix/linux
or
Schedulers
on Windows
or
There are some online crons available.
which will call your php-scripts. (which will internally do the task of mailing)
Note: the links above refer to drupal sites, but explanations given there with regards to cron and schedulers are applicable in pure-php.
Upvotes: 0
Reputation: 72580
PHP can't do that by itself as it is not a program running constantly on a server. It is only run when a user requests a web page. You would need to set up a cron job on the server that calls a PHP script to do the emails.
First, your database would need a field that says whether you have already sent the email or not. Your PHP email script would check if it is 3 days or less until the event, and you have not already sent an email to that person, then send it.
Then you would call that script from a cron job. You can run PHP from the command line, or alternatively use something like curl
or wget
to fetch the URL as if you were running the script in a web browser. (That would also mean you can run the cron job from another computer if necessary.)
Upvotes: 4
Reputation: 3146
You could set a cronjob to run a reminder script at a specific time 3 days before your webinar. Your script would loop through your user data and send email using some variation of php's mail function.
Not sure what your server type is but if you are running cPanel here is a link to their docs on how to set up a cron job: http://docs.cpanel.net/twiki/bin/view/AllDocumentation/CpanelDocs/CronJobs
Let us know which of the above you're not sure about and we can provide some more info.
Upvotes: 1