Re: PHP to edit files

coyoteboyuk@xxxxxxxxxxx wrote:
I'm looking at creating a website that basically saves times and dates
and emails specific people (all taken from a mysql database) when
times have passed. I suppose something like a birthday reminder site,
but not quite.
All I'd like to know is: Is this possible

Very possible, not even that complicated.

and how much of an
undertaking is it to get the emails out at specific times, instead of
run as a batch at fixed times from a linux cron script.

At specific times: hardly doable with PHP. Something has to trigger the
script. With the proper access, you might schedule loads and loads of
different cronjobs at specific times, but that's hardly a workable solution.

As it's about email, the "specific" time doesn't really matter though, you
can't predict how long an e-mail will take to arrive.

I'd just schedule a cronjob every 15 minutes or so, that queries the
database for tasks to perform. That should do it. If cronjobs aren't
possible, you could trigger it on site visits. If you've got a popular page,
you don't want to trigger it verey time. Add a possibility you will trigger
the script. Possibility = 1 / (average visitors per interval)

Grtz,
--
Rik Wasmus


.

Relevant Pages

  • RE: Newbie help emailing a blob field
    ... Haven't read all of this but to get the new info join to the table from the ... > application that emails a message to the assigned people when the ... I've tried an instead of on the trigger with no luck. ... > left outer join InVision_dta.dbo.tblUserDefDate tblUserDefDate ...
    (microsoft.public.sqlserver.programming)
  • Re: Send Weekly And End Of Month Automatic Emails
    ... thinking of what is the best way to trigger the emails at the required ... database not being open on that day. ... way to trigger the process at the specified time intervals. ... you could create a maco to do the mailing ...
    (comp.databases.ms-access)
  • Re: Comparing dates
    ... Is the "entry date" a DATETIME or SMALLDATETIME column? ... > I have a trigger that sends emails based on updating a table. ... I need to modify the trigger so it compares ...
    (microsoft.public.sqlserver.programming)
  • fetch mail to certain directories?
    ... thing missing is that emails for users in the MySQL database are fetched ... I thought I could use fetchmail for retrieving ... the mails and maildrop as mda, but I don't really know how my the mda line ...
    (comp.unix.bsd.freebsd.misc)
  • massive email
    ... I'm trying to make a newsletter application in php ). ... This application is supposed to look in a MySQL database and generate a ... list of emails and first names. ...
    (comp.lang.php)