如何在数据库中插入日期值[关闭]

This is my html code. I am trying to insert a date value in a database but I can't see it how it is possible.

<select name="date">
  <option value="selected"> Day </option>
  <option value="1">1</option>
  <option value="2"> 2 </option>
  <option value="3"> 3 </option>
  <option value="4"> 4 </option>
</select> 

<select name="date">
  <option value="selected"> Month </option>
  <option value="jan"> jan </option>
  <option value="feb"> feb </option>
  <option value="mar"> mar </option>
  <option value="april"> april </option>
</select> 

<select name="date">
  <option value="selected"> year </option>
  <option value="1990"> 1990 </option>
  <option value="1991"> 1991 </option>
  <option value="1992"> 1992 </option>
  <option value="1993"> 1993 </option>
</select>

It's very easy just use serialize() and unserialize(). and also [] this array sign in you name like it . here is example:

<select name="date[]">
                    <option value="selected"> Day </option>
                    <option value="1">1</option>
                    <option value="2"> 2 </option>
                    <option value="3"> 3 </option>
                    <option value="4"> 4 </option>
                </select> 

                <select name="date[]">
                    <option value="selected"> Month </option>
                    <option value="jan"> jan </option>
                    <option value="feb"> feb </option>
                    <option value="mar"> mar </option>
                    <option value="april"> april </option>
                </select> 

               <select name="date[]">
                    <option value="selected"> year </option>
                    <option value="1990"> 1990 </option>
                    <option value="1991"> 1991 </option>
                    <option value="1992"> 1992 </option>
                    <option value="1993"> 1993 </option>
                </select>

and add this name key in serialize() function and unserialize your database value using unserialize() function.

insert

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

View

$date = unserialize($date);
            echo $date[0]."/ ".$date[1]."/ ".$date[2];

You can do it in several ways.

Way 1: You can provide different names to select inputs like-

<select name="dd">
    <option value="selected"> Day </option>
    <option value="1">1</option>
    <option value="2"> 2 </option>
    <option value="3"> 3 </option>
    <option value="4"> 4 </option>
</select> 

<select name="mm">
    <option value="selected"> Month </option>
    <option value="jan"> jan </option>
    <option value="feb"> feb </option>
    <option value="mar"> mar </option>
    <option value="april"> april </option>
</select> 

<select name="yy">
    <option value="selected"> year </option>
    <option value="1990"> 1990 </option>
    <option value="1991"> 1991 </option>
    <option value="1992"> 1992 </option>
    <option value="1993"> 1993 </option>
</select> 

After submitting the form you can receive the values in php as follows.

$date = $_POST['dd'].'/'.$_POST['mm'].'/'.$_POST['yy'];

Way 2: You can name them as array as follows.

<select name="date[]">
    <option value="selected"> Day </option>
    <option value="1">1</option>
    <option value="2"> 2 </option>
    <option value="3"> 3 </option>
    <option value="4"> 4 </option>
</select> 

<select name="date[]">
    <option value="selected"> Month </option>
    <option value="jan"> jan </option>
    <option value="feb"> feb </option>
    <option value="mar"> mar </option>
    <option value="april"> april </option>
</select> 

<select name="date[]">
    <option value="selected"> year </option>
    <option value="1990"> 1990 </option>
    <option value="1991"> 1991 </option>
    <option value="1992"> 1992 </option>
    <option value="1993"> 1993 </option>
</select> 

In php you can receive them as follows

$date = $_POST['date'][0].'/'.$_POST['date'][1].'/'.$_POST['date'][2];

Note: I recommend you to use input field with type date or use a date picker in text input field.