Working with Dates

Anon

Question...Created HTML input forms for client to list upcoming events, however, instead of yyyy-mm-dd, my employer wants the client able to input dates in a more trad manner. This would be fine if the aging process to avoid displaying past events weren't dependent upon the other format...ex: getdate.....select * from table where date >= getdate.......Do I use some sort of code to switch the HTML input mm-dd-yyyy to PHP yyyy-mm-dd before holding in table and the switch back for calendar display once the select has been performed ? or are there other approaches ? Any information or code snippets would be greatly appreciated....Thanks in advance.

Anon

Personally, I save all dates in the database as timestamps. This enforces consistancy and allows me to use all of the built in date functions in php.

I usually allow users to enter dates via drop-down menus for month(MM), day(DD), and year(YY).

I then use "checkdate($MM, $DD, $YY)" to make sure they selected a valid combination (no Feb 31st).

I then concatenate the three variables together with slashes so that I can use that directly in my querry string to add to the database.

-- Rich Rijnders
-- Irvine, CA US

Anon

I always convert dates into a unix timestamp with $time = mktime(0,0,0,$month,$day,$year); After that you can manipulate the dates any which way you want with the date command. eg: date("M d, Y", $time);