首頁猿問如何在php的文本框中顯示日期時(shí)間

如何在php的文本框中顯示日期時(shí)間

PHP

ABOUTYOU 2022-01-02 16:20:39

當(dāng)我更新日期時(shí)間的值但沒有顯示時(shí)。編輯.php:-<label>Attendance Date  </label><?php if (!empty($f_edit_student['date_added'])) { $explodeImd = explode(" " ,$f_edit_student['date_added']); $date = $explodeImd[0]; } ?> <input type="datetime-local" value= "<?php echo $date; ?>"/>更新.php:-$student_no = $_POST['student_no'];$firstname = $_POST['firstname'];$middlename = $_POST['middlename'];$lastname = $_POST['lastname'];$course = $_POST['course'];$section = $_POST['section'];$status = $_POST['status'];$udate = date('Y-m-d H:i:s');$conn->query("UPDATE `student` SET `student_no` = '$student_no', `firstname` = '$firstname', `middlename` = '$middlename', `lastname` = '$lastname', `course` = '$course', `section` = '$section', `status` = '$status', `date_added` = '$udate' WHERE `student_id` = '$_REQUEST[student_id]'") or die(mysqli_error($conn));

查看完整描述

2 回答

吃雞游戲

TA貢獻(xiàn)1829條經(jīng)驗(yàn) 獲得超7個(gè)贊

如果您想存儲(chǔ)當(dāng)前日期時(shí)間，只需使用 MYSQL 的函數(shù)。

mysqli_query("INSERT INTO `student` (`date_added`) VALUES (now())");

反對(duì) 回復(fù) 2022-01-02

慕森卡

TA貢獻(xiàn)1806條經(jīng)驗(yàn) 獲得超8個(gè)贊

使用編輯查詢：

$udate = $_POST['udate'];

$conn->query("UPDATE `student` SET `student_no` = '$student_no', `firstname` = '$firstname', `middlename` = '$middlename', `lastname` = '$lastname', `course` = '$course', `section` = '$section', `status` = '$status', `date_added` = '$udate' WHERE `student_id` = " . $_REQUEST['student_id']) or die(mysqli_error($conn));

反對(duì) 回復(fù) 2022-01-02