Time

[boionfire81]

So yeah, this might just be going to far in depth. But unique, creative, and user-responsive design is what I am aiming for. So here's the question.

How can I determine the "time/day" through php from only mysqli input to show given information based on such. (i.e. not geolocation, but strict database).

A complete list of locations, timezones, and time offsets is already done. (Just need to shrink from 2 tables to 1).

I have no clue with timing.

What I want to do 4 things

1) An exact time (mostly for fluff actually).

2) Determine day/night time. (mostly design, but some store closing, bar open stuff)

3) Determine the day of the week (Simply to give a unique "clubbing" experience)

4) Determine the season (Used for my farming mod)

I imagine exact date/time would be a simple select `offset` from locations where location = $ir['located']. And then a $truetime= time() - `offset`

I could be right or wrong on that. Just guessing from what I've learned so far. Now using the above settings. Me = no clue!

 

[Coly010]

Php has this built in. Just look at the Date() method.

http://php.net/manual/en/function.date.php