Possible Duplicate:
convert date string to mysql datetime field
I have a DateTime column in MySQL database. I would like to convert Form text field data on POST (string) to DateTime before inserting into the database. I appreciate any suggestions.
-
This has been asked many many times. Please search Stack Overflow stackoverflow.com/search?q=mysql+php+strtotimeMichael Berkowski– Michael Berkowski2011-10-24 15:05:13 +00:00Commented Oct 24, 2011 at 15:05
Add a comment
|
4 Answers
Depends entirely on what format your POST data is in. Quick/dirty/probably-will-blow-up-and-steal-your-belongings method is
$date = date('Y-m-d H:i:s', strtotime($_POST['yourfield']));
Comments
date() function.
You can find the function in php.net
Comments
It depends on format of MySQL date time field and the format of the form field. Normally db datetime is Year-Month-day Hour:min:sec for example, "2011-10-24 14:25:20". Now to convert form submitted date string to datetime, do the following:
$date = strtotime($_POST['form_date']);
$DatabaseDate = date("Y-m-d H:i:s", $date);
Now you can use the above $DatabaseDate to insert datetime into database:
@mysq_query("INSERT INTO TEST_TABLE (id, date_test) VALUES (2, '$DatabaseDate')");
Hope it helps.
Comments
instead of strtotime($_POST['yourfield']) use the function mktime, in that way you dont need to worry about the string format