problem with form date picker

[ukscotth]

Hi,

 

Im having some troubles with a date picker on a form.  It enters the date into the date field like this : 21 Sep 2011

 

I want to be able to insert it into a date field in the mysql database but it just enters it as 0000-00-00

 

Any ideas ?

 

Many thanks,

 

Scott.

[micah1701]

<?php
$date_from_date_picker = "21 Sep 2011";
$mysql_friendly_date_string = date("Y-m-d", strtotime( $date_from_date_picker ) );

?>

 

also, you can probably configure the datepicker to give you the format you want too.  but thats a different forum 

[premiso]

Use the DateTime class and see if it will handle the conversion. Particularly, the CreateFromFormat function.