Dreamweaver - PHP/MySQL date insert from dropdowns

Author

PHP/MySQL date insert from dropdowns

wozza

2004-04-08, 7:28 am

Hi

I'm completely new to PHP (normally we use ASP) but I need to create a
mini content management system which includes a requirement to upload
files and the only way I can go is PHP upload because of ISP
restrictions. And I only have a couple of days to get this working.

Anyway, part of the requirement is to allow start and end date input
for promotions. I want to do these as separate dropdowns for day,
month & year to avoid incorrect formatting etc. by the user. My
question is how do I merge these fields into a mysql compatible date
before inserting them into the record?

Any help would be appreciated. Thanks.

Warren

Joaquim Lopes

2004-04-08, 5:30 pm

You can use
[b]mktime(0, 0, 0, $month, $day, $year);[/b] which returns an Unix timestamp.
[b]date("M-d-Y", mktime(0, 0, 0, $month, $day, $year));[/b] which returns a
string formatted according to the given format string using the given integer
timestamp.
[b]$date = sprintf("%04d-%02d-%%02d", $year, $month, $day);[/b]

Hope this helps.