duanfu7004 2016-03-28 07:14
浏览 64
已采纳

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

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:

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);
  • 写回答

3条回答 默认 最新

  • dongquming3255 2016-03-28 07:20
    关注

    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')";
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?