如何输入数据库的当前日期 [英] How to input the current date of the database

问题描述

<?php //Booking Request index file that sends data from the form to the database 
		
		include 'connection.php';	
		
		// Assigning Variables
		
		$evename = $_POST['event_name'];
		$evedescrip = $_POST['event_description'];
		$evetype = $_POST['event_type'];
		$fac = $_POST['name_of_facility'];
		$startdate = $_POST['event_start_date_time'];
		$enddate = $_POST['event_end_date_time'];
		$evecood = $_POST['event_coordinator'];
		$bookdate = date('d-m-y');
		 
		
		// Variable that executes request to send data to database
		$sql = "INSERT INTO booking_requests (`event_name`,`event_description`,`event_type`,
		`name_of_facility`,`event_start_date_time`,`event_end_date_time`,`event_coordinator`,`booking_request_date`)
				VALUES('$evename','$evedescrip','$evetype','$fac','$startdate','$enddate','$evecood',$bookdate)";

		// Statement stating whether the execution is successful
		if (!mysqli_query ($link,$sql)){
		die ('Error: ' . mysqli_error($link));
		} 
		else 
		echo ('Entry successfully submitted');
?>

变量$ bookdate输入进入数据库，但它输入像0000-00-00什么错了，我错过了什么？

The variable $bookdate does input into the database but it inputs like 0000-00-00. Whats wrong, what I am i missing?

推荐答案

evename =

evename =

_POST [' event_name'];

_POST['event_name'];

evedescrip =

evedescrip =

这篇关于如何输入数据库的当前日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！