php and mysql dates

jdc44

I'm having trouble with a couple of forms that are using php and dates. I'm getting dates from users in a form and inserting them into a mysql database, but my dates keep showing up as 12/31/1969.

$date_from_form = '04/27/2005';

$date_from_form = stringtotime($date_from_form);
$date_from_form = date('Y/m/d', $date_from_form);

Then I do my insert into my table.

Any ideas what I'm doing wrong?

Thanks.

JohnC

devinemke

$date_from_form = '04/27/2005';
$date_for_mysql = date('Y-m-d', strtotime($date_from_form));

Weedpacket

[man]strtotime()[/man] doesn't handle dates in that format because it's ambiguous. Is 12/11/2006 the eleventh of December or the twelfth of November? And how is strtotime() supposed to know?

You'll need to either adopt an unambiguous date format or parse the date string yourself (using explode, substr or sscanf).

jdc44

Yes, It was the date format. It has to be yyyy-mm-dd for mySql.

The $date = date('Y-m-d', strtotime($date_entered)); doesn't work. This works for dates going into oracle, which I'm more familiar with, but something about mySql doesn't like it.

I used:
list($month, $day, $year) = explode("/", $date_entered);
$date_entered = "$year-$month-$day";

That did the trick.

Thanks to all for your help.