php - 如何使用 php 将 HTML 日期时间本地输入插入 MYSQL 表日期时间列？

Question

    <?php
include "session.php";
if(isset($_POST['permission'])) {
  $x = $_POST['x'];
  $reason = $_POST['reason'];
  $leaving = $_POST['leaving'];
  $returning = $_POST['returning'];



  $query = "INSERT INTO permissions (reason, leaving, returning, user, x) VALUES('$reason', '$leaving', '$returning', '$login_session', '$x')";
  $result = mysqli_query($db, $query);// or die('Error querying database!');
  if ($result === false) { die(mysqli_error($db)); }
  echo 'Thanks for Posting! Your request will be addressed as soon as possible!';
}

这段代码有什么问题？离开和返回列的类型为 DATETIME。这会引起问题吗？

<form method="post" action="" class="forms">
        Type: <select name="x" required>
          <option value="0">Leave</option>
          <option value="1">Other</option>
        </select>
        <input type="text" name="reason" placeholder="Reason" required><br>
        <input type="datetime-local" name="leaving"><br>
        <input type="datetime-local" name="returning"><br>
        <input type="submit" value="Request Permission" name="permission">
      </form>

Answer 1

要实现您想要的目标，请按照以下步骤操作。

1. 不要将数据库中的字段类型设置为“DATETIME”，而应使用长度约为 99 的简单 VARCHAR，以便轻松存储完整格式的日期和时间。
2. 输入类型“datetime-local”实际上不是必需的。只需使用输入类型“日期”即可，因为您没有捕获时间。

准备好上述修复后，请修改您的 PHP 代码，如下所示。如果需要，您也可以简单地复制/粘贴它。

<?php
    include "session.php";

    if(isset($_POST['permission'])) {
        $x = $_POST['x'];
        $reason = $_POST['reason'];
        $leaving = $_POST['leaving'];
        $returning = $_POST['returning'];

        $query = "INSERT INTO permissions (reason, leaving, returning, user, x) VALUES('$reason', '$leaving', '$returning', '$login_session', '$x')";
        $result = mysqli_query($db, $query);// or die('Error querying database!');

        if ($result === false) {
            die(mysqli_error($db));
        }

        echo 'Thanks for Posting! Your request will be addressed as soon as possible!';
    }
?>

现在要以所需格式检索此日期值，请使用以下代码。

$fetched_date = "04-09-2017" //Assuming that this Sunday, April 9, 2017 is the fetched date and stored in "04-09-2017"

现在，只需按照以下步骤将其转换为 2017 年 4 月 9 日星期日。

$fetched_date_uf = date_create($fetched_date);
$fetched_date_formatted = date_format($fetched_date_uf, 'l, F d, Y');

echo $fetched_date_formatted; //Sunday, April 9, 2017

引用this link PHP 日期时间格式。