php - 无法在我的数据库中正确输入日期类型数据

Question

每件事都被正确输入，但日期被提交到数据库，如 0000-00-00。请帮忙！！我试图在将其发布到 dob 之前回显我的日期，并且它在插入表格时是正确的。但是当我检查我的数据库时，dob 列会更新为 0000-00-00。

这是代码：

<?php
if (isset($_POST['submit'])) { 
    echo "<pre>";
    var_dump($_POST);
echo "</pre>";}
$username = $_POST['username'];
$password = $_POST['password'];
//$salary = $_POST['salary'];
 $birthdate =  $_POST['year'] . '-' . $_POST['month']. '-' .$_POST['day'];
 echo $birthdate."<br>";

 
 
if(!empty($username)){
	if(!empty($password)){
		if(!empty($birthdate)){
		$servername = "localhost";
$usernamei = "root";
$passwordi = "password";
$databasei = "regis";

// Create connection
$conn = new mysqli($servername, $usernamei, $passwordi, $databasei);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
else {
	 echo $birthdate;
	$sql = "INSERT INTO iocl (user_name, password,dob)
	values ('$username','$password','$birthdate')";
	if($conn->query($sql)){
		echo "new record is inserted sucess";
	}
	else{
		echo "error: ".$sql."<br>".$conn->error;
	}
	$conn->close();
}}}}
	
    ?>

标签： phpmysql