[RESOLVED] Time difference help

fontener

😕
Ok, so I'm using the following function to calculate time difference in weeks..

function calc_time_diff($ts1, $ts2, $time_unit)
	{
	$ts1 = intval($ts1);
	$ts2 = intval($ts2);
	if ($ts1 && $ts2) {
		$time_lapse = $ts2 - $ts1;
		$seconds_in_unit = array(
		'seconds' => 1,
		'minutes' => 60,
		'hours'   => 3600,
		'days'    => 86400,
		'weeks'   => 604800,
		);

	if ($seconds_in_unit[$time_unit]) {
		return floor($time_lapse/$seconds_in_unit[$time_unit]);
	}
}	
return false;
}

$ts1 is the timestamp I have stored in the database when x is added
$ts2 is the current time using time()
and $time_unit is weeks

there is another column in the database that gives the 'active' status of x using an enum('true','false')

Basically, what I need is to show how many weeks has passed until x is declared 'inactive'... so let's say I add x on 5/1/2010 and make it inactive on 6/1/2010... it says 4 weeks even if today's date is 7/1/2010..

currently, it would display 8 weeks in the above example...

but if it is made 'active' again let's say 8/1/2010 and 'inactive' again on 8/8/2010.. i need it to continue from the 4 weeks and make it 5 weeks..

THANKS! I really appreciate any help in the matter

fontener

I'm assuming I'll need to use a static variable ??? somehow.. but I know what assuming leads to..

johanafm

If I understand you correctly, the following should give:
1 week active
1 week inactive
2 weeks active
3 weeks inactive

1 week active

4 weeks

And if this is so, how do you store activity periods in the DB? Are they in the same table as the user, or are they kept in a separate table (they should be).
All you (probably) need to store in the active table is user_id, start_date, end_date.

SELECT SUM(DATEDIFF(end_date, start_date - INTERVAL 1 day))
FROM active
WHERE user_id = ...

The INTERVAL 1 day is needed since DATEDIFF('2010-01-01', '2010-01-01') equals 0, but should be interpreted as a 1 day active period.
Converting days to weeks should be trivial.

As for static vars

function foo() {
	static $i = 5;	// first time function is run, assign 5 to $i.
	return ++$i;	// on each call, increment by 1 and return.
}


for ($i = 0; $i < 3; ++$i) {
	$result = foo();		// returns 6, 7, 8 on each respective run
}
echo $result; # 8

fontener

I knew there had to be a much easier way to go about that.. now all I can think is "duh"... appreciate the help