Reoccuring event

Pests

Whats the best way of doing a reoccuring event every day at a certaim time, every week, month, year, ect. Perhaps not all of these at once, but the idea is the same.

Right now I have support for just an event that happeneds once by saving the date/time value in the format of time().

devinemke

what do you want to do exactly? run a certain script at a timed interval? if so then look at cron.

Pests

Think of it like a calander. Every wednesday will be highlighted, or the 15th of each month, ect.

devinemke

below is a list of every date for the next 30 days with all of the Wednesdays in <font color="red">red</font>:
<br>
<br>

<?
$timestamp = time();
$timestamp_plus_30 = $timestamp + 2592000;
while ($timestamp < $timestamp_plus_30)
{
	$date = date('Y-m-d l', $timestamp);
	$day = date('l', $timestamp);
	if ($day == 'Wednesday') {$date = '<font color="red">' . $date . '</font>';}
	echo $date . '<br>';
	$timestamp += 86400;
}
?>

Pests

Works out one of the problems. Now I need to get a list of events that happeneds today. I can easily pull out the normal events, but how would I find if the current date lands on a reaccuring event?

tekky

you will most likely need to create an events table that contains
ONLY reccurring events, and then do something like

SELECT * FROM recevents WHERE everyxday = $day or everyxmonth = $month or everynumweek = int($daynum/7)

Yah it will be a bit complicated but I suspect it would solve your problem.. you would just need to decide how many differetn types of reccuring events you have... ie. every 3rd week every 3rd wednesday every 2nd month etc etc and code your query to handle them...

[edit-- or instead of a seperate table you could add a "is_reccuring" column into your data table and then SELECT * FROM dates WHERE is_reccuring = 1 and (blah = blah or bleh = bleh or etc = etc) -- if you get the idea --]

Pests

Yeah, I see how that could work kinda. Hmm. Maybe ill look into how other apps do it.

Any other suggestions?

dreams4000

Tekky has it the easiest way I think. Some kind of status for the event in the database and pulling it based on that status is going to be the easiest on coding and database setup.

Pests

Either way, how would I store the data in the database for a reoccuring event?

Pests

Hmm, after investingating IPB it seems that is how they store it in the DB. I just need to figure out how to find out what days fall within the "recurrence".

tekky

you will need columsn in the DB for something like recurring_weekly, recurring_monthly, recurring_daily etc etc to cover the extent of every 3rd Xday every 14th, every may etc etc and then a check to confirm if it falls on those days (item stored in the column would vary dpending on the column ie: recurring_weekly would contain the day it recurs on each week, reucciny monthly would contain the day of the month it recurrs on.... and so on and so on...

atleast thats how I see it