Inserting date into MySQL

Anon

I have a form where users should type a date in dd/mm/yyyy format.
After the form is submited, I insert the data into a MySQL table, with an DATETIME field for the date. How should I format the date in order to insert it well? If I insert it directly it is bad inserted.

I have tried with 12/06/2002 and I have inserted: 10/12/1999

Anon

Best format is "YYYY-MM-DD"
e.g. 2002-07-25

Cheers

Anon

The field which contains the date is called 'data_ingres'.
Before inserting it I do this:
$ingres=date($data_ingres, "Y-m-d");
And finally I insert $ingres to the database.

This happens to insert '10/12/1999' instead of '12/06/2002'.

siwis

Why not simply create 3 drop downs, one for month, one for day and one for year:
$year
$month
$day

Then on submission declare:
$inges = $year. "-" .$month. "-" .$day;

This would rule out anybody from trying to break your code by specifying invalid number, or typing the date in a different format to what your script is expecting.

MySQL data field should be of type "date".

Anon

the date function will accept the timestamp for the date. so your function

ingres=date($data_ingres, "Y-m-d");

will not work. what you can do is change it to time stamp after splitting your date string first

$array = explode( "/",$date_ingres);
$timestamp = mktime(0,0,0,$array[mm],$array[dd],$array[yyyy]);

ingres=date($timestamp, "Y-m-d");

just replace the mm,dd.yyy with the respective index depending on the date format.

Hope that helps

steven