[RESOLVED] Variables and dates

phpSimon

Hi all

I'm working with a couple of date variables to get data from a MySQL database.

$from = date("Y-m-01",strtotime("+$monthnumber months"));
$to =  date("Y-m-t",strtotime("+$monthnumber months"));

In the above case, where $monthnumber is zero:

$from = 2009-12-01
$to = 2009-12-31

When $monthnumber is incremented by one:

$from - 2010-01-01
$to = 2010-01-31

... and so on.

This works perfectly when I want to start my reporting loop THIS month.

However, if I want the start month to be LAST month I'm not sure how best to set $from and $to.

If I set $startmonth to 11, what would be the CORRECT way to do the following? (Note this example does not work) :

$from = date("Y-$monthstart-01",strtotime("+$monthnumber months"));
$to =  date("Y-$monthstart-t",strtotime("+$monthnumber months"));

I've tried a few mktime excercises but don't seem to be able to find the correct syntax.

Thanks

johanafm

The first argument to date() is a string telling date() how to format the date. What you want is

date('Y-m-d');

The second argument is a timestamp to decide what date should be used. No argument means current time is used.

// using mktime to get a timestamp for 2009-11-01 00:00:00
date('Y-m-d', mktime(0, 0, 0, 11, 1, 2009));

// using strtotime
/*	starting the string with + or - gives a date relative to the second argument sent to
	strototime (or current time if no second argument). */
// One month ago
date('Y-m-d', strtotime('-1 month'));

// using absolute date with strtotime
date('Y-m-d', strtotime('november 1 2009'));

But, date returns a string, and if you allready know the year, month and day, why bother with it?

$year . '-' . $month . '-' . $day;

phpSimon

Thank you.

I still can't quite see how to put the right command together.

If $monthstart is 11:

$from = date('Y-m-d', mktime(0, 0, 0, $monthstart, 1, 2009));
$to = date('Y-m-t', mktime(0, 0, 0, $monthstart, 1, 2009));

will give me 2009-11-01 and 2009-11-30 which is fine for the first time around, but how do I apply strtotime +$monthnumber months to this, at the same time, in the 2nd and 3rd iterations of the loop?

If it helps, if $monthstart is 11, $from and $to should be:

1)
2009-11-01 and 2009-11-30
2)
2009-12-01 and 2009-12-31
3)
2010-01-01 and 2010-01-31

Thanks again.

johanafm

$monthstart = 11;
$max = 4;		// or whatever you need...
for ($i = 0; $i < $max; ++$i)
	echo date('Y-m-d', mktime(0, 0, 0, $monthstart + $i, 1, 2009));

$start = mktime(0, 0, 0, $monthstart, 1, 2009);

for ($i = 0; $i < $max; ++$i)
	echo date('Y-m-d', strtotime('+' . $i . ' month', $start));

phpSimon

Perfect! I didn't think of adding to $monthstart in mktime !

Thank you, that's exactly what I needed.

Simon