php - 如何从 PHP 将日期插入 MySQL

Question

我无法将日期(甚至我的整个表格)插入 mySQL。这是我的代码:

    if($_SERVER["REQUEST_METHOD"]=="POST")
{
    $con = mysqli_connect('localhost','root','','e-Laundrydb');
    $tglPickup = $_POST['tglPickup'];
    $barang = $_POST['inputItems'];
    $waktuPickup = $_POST['waktuPickup'];

    $query_order = "INSERT INTO order(Barang,Tanggal_Pengambilan,Waktu_Pengambilan) VALUES('$barang','$tglPickup','$waktuPickup');";

    $result = mysqli_query($con,$query_order);

    if($result == false)
    {
        echo "<script>alert('INSERT IS NOT SUCCESS');</script>";
    }
    else
    {
        echo "<script>alert('INSERT SUCCESS');</script>";
    }
}

我在我的 php 中使用了 input type="date"。这是我在数据库中的表: Table Order

我找不到问题出在哪里。我更新了代码并按照您的建议进行操作，但仍然一无所获:(又是代码:

if($_SERVER["REQUEST_METHOD"]=="POST")
{
    //include('config/koneksi.php');
    $con = mysqli_connect('localhost','root','','e-laundryDB');
    //INSERT KE TABLE ORDER
    $tglPickup = date('Y/m/d', strtotime($_POST['tglPickup']));
    $barang = $_POST['inputItems'];
    $waktuPickup = $_POST['waktuPickup'];

    $query_order = "INSERT INTO 'order'(Barang,Tanggal_Pengambilan,Waktu_Pengambilan) VALUES('$barang','$tglPickup','$waktuPickup')";

    $result = mysqli_query($con,$query_order);

    if($result == false)
    {
        echo "<script>alert('INSERT IS NOT SUCCESS');</script>";
    }
    else
    {
        echo "<script>alert('INSERT SUCCESS');</script>";
    }           



mysqli_close($con);
}

Answer 1

您必须将日期格式设置为“YYYY-MM-DD HH:ii:ss”。因为 mysql 将这种格式用于日期。

检查您在查询中传递的日期格式，可能存在此问题。

谢谢。