How to send Email on (repeating) time intervals in php

[riaz123]

Actually my requirement is that, I have to send email after some (pre-defined) time interval (which is set by Admin through admin panel etc) like "After every week" or "every fortnight" or "every month" or "daily".

I have inserted all data i.e users email info etc and the time interval after which email notification is to be sent in Database.

Now I am required to run a script in cron job to send email notifications to users with their respective (repeating) time interval (set by admin and stored in DB). I am confused how to do so.
So can anyone kindly help me out to resolve this problem. Thanks in advance.

[egami]

php by itself can't do any cron jobs..
but you can set the cron to run a php script as little as every minute of the day.

For more information on cron jobs, do a google search.

your PHP script would have something to the effect of..

1. The current time
2. Search for all queries to run at current time with in a few seconds of 'the current time'
3. run your email routines against those queries that return.

[rytec]

To make a php script for example in Linuxserver, doe sit need to have the php extension? or would this be a totaly normal script in linux which also can do a query to the mysql dbase?
which way is better?

[egami]

you would run it as root, but you call php application, and then the file..


example:

/5 * * * * root php /var/www/html/dome.php