Combining Variables to form a date.

tywin

Have a form where a user inputs 3 different fields

ex : <input size="1" maxlength=2 name="month" >/<input size="1" maxlength=2 name="day"> /<input size="1" maxlength=2 name="year">

I want to take these 3 fields and input them into my mysql database as a date.

$fulldate = date("Y-m-d",strtotime(???));

Does anyone know how to combine these 3 fields and format as a date?

Thanks!

NiXXeD

Well, are you using the date type in sql? If so, you could just combine all 3 strings with a - ($year . '-' . $month . '-' . $day) But you might want to use a 4 digit year, so you don't have to worry about whether its in 19xx or 20xx... If you're using a unix timestamp type date, I believe there is a function to do that. Search www.php.net for the specific funtion (just search for 'date' and it should find it).

tywin

It's a MySQL database so it has to be formatted as yyyy-mm-dd.

NiXXeD

Ok, so like I said, just make sure its a 4 digit date, and just concatenate the strings together. Do you know how to use the _POST vars? How does your form get the data to your script? This should be quite easy...

tywin

The form has this: <form name="RRForm" onSubmit="return sendMail()" METHOD="GET" ACTION="MailTo.php">

Are you saying concatinate my 3 fields then use that combined field with the date function?

$totaldate = $year;
$totaldate .= $month;
$totaldate .= $day;

then do $finaldate = date("Y-m-d",strtotime($totaldate));

tywin

Think I got it. As long as they enter in 2 digit months, days, and the 4 digit year.

lobster

My Form:

I have 3 form fields dateday, datemonth, dateyear

Do I place this at the bottom of the form page? or in a hidden input field? or in the additin.php file? I have tried several different things and it is not working.

<? $date = ($dateyear . '-' . $datemonth . '-' . $dateday); ?>

I'm stuck.

lobster

I placed this before my database query:

   $combine = $dateyear;
   $combine .= $datemonth;
   $combine .= $dateday;

   $date = $combine;

and it worked!