date(s) calculation problem

dennisfreud

Hi,

I am looking for general help here. I dont know how to start at this... maybe someone can point me in the right direction.

I need to calculate how many nights of a given time frame (variable dates) lie within certain ranges of times given to calcutate pricing for a hotel which has different prices depending on the season. (fixed dates).

So I have this table (MYSQL) which for example says:

from to price/night
01/01 03/31 100,-
04/01 12/20 120,-
12/21 12/31 160,-

How do I tackle (or at least attack) the problem to calculate the price of a stay in this hotel for, lets say Dec. 18th to Jan. 5th???

Obviously the dates which fix the pricing do not have/need the attribute (year) as they are always the same...

Can someone give me a jump start?

THX
Dennis
(from sunny Tenerife island)

bpat1434

I think the easiest way to do it would be to set up a loop which loops through each day individually and gets the value of that day.

That's really the only way I can think of doing it. Just grabbing the two timestamps of the dates they want, (with like a mktime() call) and then just adding days each loop. Alternatively you could use [man]strtotime/man and say "December 18th +1 day" or "+52 days" which would give you the proper day.

The only caveat is that you may have to worry about leap years. I'm not 100% sure that strtotoime() is going to recognize leap years (2012, 2016, etc.).

Hope that helps.

dennisfreud

Thanks so far...
What about the fact that the times in the pricing tables dont have a year attribute.
How will I know what dates to compare my timestamps from the dates given with?

Still not completely happy

Dennis

bpat1434

You can use [man]date/man to create your own date string. Or you could use the MySQL functions "DAY", "MONTH" to calculate whether that day of the month is in between two dates. You'd just have to give the date fields in the table a year (can be arbitrary, but pick a leap-year just-in-case; say 2000).