[SOLVED] Input date

[aashcool198]

i want to input date using html form. the input will be stored in date format in database. what input field should i use so that user can fill date.

Please someone tell me that code.

[947740]

As I see it, there are several options.  I know of several javascript scripts that popup and let you choose the date.  Or could just use a textfield and put the requested format next to it (like mm/dd/yy).

 

When you process that with the php script, you will want to format the date accordingly.  Using $date = strtotime($_POST['date']) and then take the date("n/j/Y",$date) will give you a good format.  Then you just insert into the database.

[aashcool198]

i input date as:

  Quote

<input type="date" name="date">

 

and retrieve it using

 

  Quote

$date = strtotime($_POST['date']);

$deadline = date("n/j/Y",$date);

 

and add in database:

 

  Quote

$add_deadline = "INSERT INTO goals_deadline (goal_id, deadline)

VALUES ('$goal_id','$deadline')";

$result = mysql_query ($add_deadline) or die(mysql_error());

 

 

But the date is not inserted in database.  echo $deadline;  is giving the correct value but it is not inserted in database while the $goal_id is being inserted every time.

 

Please Help!

 

 

[thebadbad]

There's no date type for input fields, use text instead:

 

<input type="text" name="date" />

 

And try inserting a date in the standard format instead (YYYY-MM-DD), your current format is not recognized by MySQL:

 

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

[aashcool198]

Hey! thanks a lot to both of you!