[Resolved] Inserting Date

[ghjrbrasil]

I have a form that asks a user to insert a specific date. The MySQL field type is the regular date (0000-00-00) and below a part of the date form code:

<td width="30%"><input type="text" name="dia" value="<?php echo $dia ?>" size="1">
<input type="text" name="mes" value="<?php echo $mes ?>" size="1">
<input type="text" name="ano" value="<?php echo $ano ?>" size="3"></td>
<?php
$data='"$ano"-"$mes"-"dia"';
echo "$data";
?>

What I wanted to do is have three input boxes, one for day, month and year (in the brazilian order d/m/y). Then the input from these three boxes would be organized in the MySQL order and submitted to the database.

Well, it didn't work hehe, and this whole date thing really is confusing me... could anyone shed some light here?

thanks,
greg

[DeltaRho2K]

How are you getting the variables to begin with? If in the URL, then you may want to add the following to the top of your code:

extract($_GET);

Then:

// Echo the variables to make sure they are there and contain data.
echo $mes."-".$dia."-".$ano;

// Format to YYYY-MM-DD format
$FormattedDate = date("Y-m-d", mktime(0,0,0,$mes,$dia,$ano));
echo $FormattedDate;

Also, if you are getting any errors, post them here...

[ghjrbrasil]

Worked like a charm, thanks...

I wasn't very familiar with the date function. Need to do some more reading 🙂

once again, thanks.
greg

[DeltaRho2K]

No problem... The date() function very useful, and I have been working with it extensively making calendar script... You can do a lot of cool te maniuplation with it, and I still have a lot to learn about it too... Have fun learning with it.