从HTML到PHP脚本插入/获取日期到MYSQL数据库

Question

Can you help me on what PHP code do I need in order to insert the date to the database from the HTML form. Here is the date format:

HTML FORM:

<form action="insertleave.php" method="post">
      <label>Date Filed:</label>
      <input type="date" name="datefiled">

      <label>Date of Leave:</label>
      <input type="date" name="leavedate">
</form>

PHP:

if( $_POST ){
    $config = parse_ini_file("phpconfig.ini");
    $conn = mysqli_connect($config['host'], $config['username'], $config['password'], $config['dbname']);

    if (!$conn){
        die("Connection failed: " . mysqli_connect_error());
    }

    -----CAN YOU PROVIDE ME WHAT THE CODE IS NEEDED HERE -----


    if (mysqli_query($conn, $sql)) {
       echo "OK!";
    } else {
       echo "Error: " . $sql . "<br>" . mysqli_error($conn);
  }
}
mysqli_close($conn);

Answer 1

You have to Format the the time as you defined/ create the field in the database. Because you select the DATE so the format id Y-m-d. Replace the table with your actual table name.

Your Query is:

$datefiled = date("Y-m-d", strtotime($_POST['datefiled']));
$leavedate = date("Y-m-d", strtotime($_POST['leavedate']));
$sql = "INSERT INTO table (DateFiled, LeaveDate) VALUES('$datefiled', '$leavedate')";