我想在用户点击提交按钮时自动保存日期。

这是我试过的代码

<input type="hidden" name="record_date" value="<?php echo date("d-m-Y");?>" class="form-control"/>

它没有显示任何错误，我已经成功地将数据提交到数据库。 但当我检查数据库时，它显示0000-00-00

值数据

数据库

CREATE TABLE IF NOT EXISTS `record` (

  `record_id` int(10) NOT NULL AUTO_INCREMENT,
  `student_id` varchar(10) NOT NULL,
  `supervisor_id` varchar(50) NOT NULL,
  `record_title` varchar(255) NOT NULL,
  `record_date` date,
  `record_note` varchar(255) NOT NULL,
  `record_comment` varchar(255) NOT NULL,

  PRIMARY KEY(record_id),
  FOREIGN KEY (student_id) REFERENCES student(student_id),
  FOREIGN KEY (supervisor_id) REFERENCES supervisor (supervisor_id)
); 

if(ISSET($_POST['submit'])){
        $student_id= $_POST['student_id'];
        $supervisor_id = $_POST['supervisor_id'];
        $record_title = $_POST['record_title'];
        $record_date = $_POST['record_date'];
        $record_note = ($_POST['record_note']);

        mysqli_query($conn, "INSERT INTO `record` 
                                VALUES('', '$student_id', '$supervisor_id', 
                                        '$record_title' ,'$record_date', 
                                        '$record_note', '')") 
            or die(mysqli_error());