Inserting Date in MySQL after formatting it from HTML

[kdshah]

Hi all,

I am getting date in string format (for eg. 12/11/2002) from HTML form. I want to add this date into MySQL database in a field of type Date.

I may even want to format this date (say add 1 month to it so as to make it..1/11/2003 )..How to go about doing this in PHP ?

 

[sleipnir214]

Given a string that can be interpreted as a date, something like this should work:

$variable_to_insert = date ('Y-m-d", strtotime($_POST['datafield_from_input_form']));

Please read

http://www.php.net/manual/en/function.date.php

and

http://www.php.net/manual/en/function.strtotime.php

for more information. ______________________________________________________________________
TANSTAAFL!