PHP and schedules tasks/events

Hi all,

I am in need to schedule reminder emails and was wonder how to do this
via PHP / mySQL

For example, I would like to give my user the ability to sign-up for
an event and have an email reminder generated X amount of time before
the event.

I appreciate any feedback on how to do this...

Thanks!

Don Wieland
D W D a t a C o n c e p t s
~~~~~~~~~~~~~~~~~~~~~~~~~
donw@dwdataconcepts.com
Direct Line - (949) 305-2771

Integrated data solutions to fit your business needs.

Need assistance in dialing in your FileMaker solution? Check out our
Developer Support Plan at:
http://www.dwdataconcepts.com/DevSup.html

Appointment 1.0v9 - Powerful Appointment Scheduling for FileMaker Pro
9 or higher
http://www.appointment10.com

For a quick overview -
http://www.appointment10.com/Appt10_Promo/Overview.html


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP and schedules tasks/events

On Fri, Apr 16, 2010 at 4:20 PM, Don Wieland wrot=
e:
> Hi all,
>
> I am in need to schedule reminder emails and was wonder how to do this vi=
a
> PHP / mySQL
>
> For example, I would like to give my user the ability to sign-up for an
> event and have an email reminder generated X amount of time before the
> event.
>
> I appreciate any feedback on how to do this...
>
> Thanks!
>
> Don Wieland
> D W =A0 D a t a =A0 C o n c e p t s
> ~~~~~~~~~~~~~~~~~~~~~~~~~
> donw@dwdataconcepts.com
> Direct Line - (949) 305-2771
>
> Integrated data solutions to fit your business needs.
>
> Need assistance in dialing in your FileMaker solution? Check out our
> Developer Support Plan at:
> http://www.dwdataconcepts.com/DevSup.html
>
> Appointment 1.0v9 - Powerful Appointment Scheduling for FileMaker Pro 9 o=
r
> higher
> http://www.appointment10.com
>
> For a quick overview -
> http://www.appointment10.com/Appt10_Promo/Overview.html
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

Run a cronjob at midnight and send the email. Track who it got sent
to, so you don't duplicate it. Easy peasy!

--=20

Bastien

Cat, the other other white meat

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP and schedules tasks/events

On Apr 16, 2010, at 1:26 PM, Bastien Koert wrote:

> Run a cronjob at midnight and send the email. Track who it got sent
> to, so you don't duplicate it. Easy peasy!

This is fine if the email is to be sent at midnight.

I am looking for more refinement.

For example:

A user signs up for an event - 4/16/2010 @ 10:45am

There is an option:

Send me a reminder email X minutes/hours/days/weeks/months/years prior
to the Event.

so:

30 minute(s) = email sent at 4/16/2010 @ 10:15am
2 hour(s) = email sent at 4/16/2010 @ 8:45am
3 day(s) = email sent at 4/13/2010 @ 10:45am
1 week(s) = email sent at 4/9/2010 @ 10:45am
1 month(s) = email sent at 3/16/2010 @ 10:45am
1 year(s) = email sent at 4/16/2009 @ 10:45am

This is really what I need...

Don Wieland
D W D a t a C o n c e p t s
~~~~~~~~~~~~~~~~~~~~~~~~~
donw@dwdataconcepts.com
Direct Line - (949) 305-2771

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP and schedules tasks/events

--0015174c3c1a7a95c604846163ea
Content-Type: text/plain; charset=ISO-8859-1

On Fri, Apr 16, 2010 at 5:15 PM, Don Wieland wrote:

> On Apr 16, 2010, at 1:26 PM, Bastien Koert wrote:
>
> Run a cronjob at midnight and send the email. Track who it got sent
>> to, so you don't duplicate it. Easy peasy!
>>
>
> This is fine if the email is to be sent at midnight.
>
> I am looking for more refinement.
>
> For example:
>
> A user signs up for an event - 4/16/2010 @ 10:45am
>
> There is an option:
>
> Send me a reminder email X minutes/hours/days/weeks/months/years prior to
> the Event.
>
> so:
>
> 30 minute(s) = email sent at 4/16/2010 @ 10:15am
> 2 hour(s) = email sent at 4/16/2010 @ 8:45am
> 3 day(s) = email sent at 4/13/2010 @ 10:45am
> 1 week(s) = email sent at 4/9/2010 @ 10:45am
> 1 month(s) = email sent at 3/16/2010 @ 10:45am
> 1 year(s) = email sent at 4/16/2009 @ 10:45am
>
> This is really what I need...
>
>
> Don Wieland
> D W D a t a C o n c e p t s
> ~~~~~~~~~~~~~~~~~~~~~~~~~
> donw@dwdataconcepts.com
> Direct Line - (949) 305-2771
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
What about making ics files available for download? Users could easily
import the event into the calendar of choice, and they could also (using the
calendar software they're already familiar with) set the alarm. For
instance, I can set the calendar on my cell to ring my phone to alert me to
events (my preference over email reminders for important events because I
sometimes get flooded with email.)

Your scripts could generate the files containing event info and then
automatically start the download.

This allows the users to determine the mode of alarm that works best for
them in their native calendar app, and you're still greatly facilitating the
process by providing all of the info so they merely have to drag and drop
for many apps.

I realize you asked specifically for a server-side email alarm solution (I
apologize for the tangent if your needs preclude this type of approach), but
I thought I'd toss out the idea as this approach has proved more effective
and efficient for websites I maintain.

Adam

--
Nephtali: PHP web framework that functions beautifully
http://nephtaliproject.com

--0015174c3c1a7a95c604846163ea--

Re: PHP and schedules tasks/events

you can setup a schedule table in db
and have a cron php script check the db every time
and send email if the current time is around the scheduled_at time
and close the schedule after you send the email

On Fri, Apr 16, 2010 at 5:35 PM, Adam Richardson wro=
te:
> On Fri, Apr 16, 2010 at 5:15 PM, Don Wieland wro=
te:
>
>> On Apr 16, 2010, at 1:26 PM, Bastien Koert wrote:
>>
>> =A0Run a cronjob at midnight and send the email. Track who it got sent
>>> to, so you don't duplicate it. Easy peasy!
>>>
>>
>> This is fine if the email is to be sent at midnight.
>>
>> I am looking for more refinement.
>>
>> For example:
>>
>> A user signs up for an event - 4/16/2010 @ 10:45am
>>
>> There is an option:
>>
>> Send me a reminder email X minutes/hours/days/weeks/months/years prior t=
o
>> the Event.
>>
>> so:
>>
>> 30 minute(s) =3D email sent at 4/16/2010 @ 10:15am
>> 2 hour(s) =3D email sent at 4/16/2010 @ 8:45am
>> 3 day(s) =3D email sent at 4/13/2010 @ 10:45am
>> 1 week(s) =3D email sent at 4/9/2010 @ 10:45am
>> 1 month(s) =3D email sent at 3/16/2010 @ 10:45am
>> 1 year(s) =3D email sent at 4/16/2009 @ 10:45am
>>
>> This is really what I need...
>>
>>
>> Don Wieland
>> D W =A0 D a t a =A0 C o n c e p t s
>> ~~~~~~~~~~~~~~~~~~~~~~~~~
>> donw@dwdataconcepts.com
>> Direct Line - (949) 305-2771
>>
>> --
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
> What about making ics files available for download? =A0Users could easily
> import the event into the calendar of choice, and they could also (using =
the
> calendar software they're already familiar with) set the alarm. =A0For
> instance, I can set the calendar on my cell to ring my phone to alert me =
to
> events (my preference over email reminders for important events because I
> sometimes get flooded with email.)
>
> Your scripts could generate the files containing event info and then
> automatically start the download.
>
> This allows the users to determine the mode of alarm that works best for
> them in their native calendar app, and you're still greatly facilitating =
the
> process by providing all of the info so they merely have to drag and drop
> for many apps.
>
> I realize you asked specifically for a server-side email alarm solution (=
I
> apologize for the tangent if your needs preclude this type of approach), =
but
> I thought I'd toss out the idea as this approach has proved more effectiv=
e
> and efficient for websites I maintain.
>
> Adam
>
> --
> Nephtali: =A0PHP web framework that functions beautifully
> http://nephtaliproject.com
>

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php