我无法在我的数据库中存储日期 [英] I am unable to store date in my database

问题描述

我正在设计网页并使用表单方法存储数据。

< form method =POST action =filldata.php> 
< div>< input type =datename =calendarid =datesettername =selectdate>< / div> 
 
< div>< select id =mySelectonchange =myFunction（）name =chosenlot> 
< option value =----->时段
< option value =9to11> 9到11 
< option value =11to1> ; 11到1 
< option value =2to4> 2到4 
< / select>< / div> 
 
 
< input type =textplaceholder =Enter Nameid =enamename =enameclass =alignleft> 
 
< div>< select id =mySelectbranchonchange =myFunction3（）name =branch> 
< option value =----->选择部门
< option value =b1>计算机工程
< option value =b2>机械工程
< option value =b3>电气工程
< option value =b4> Electronics&电信工程
< option value =b4>信息技术
< / select>< / div> 
 
< div>< select id =mySelectaudionchange =myFunction2（）name =auditoriumclass =alignright> 
< option value =----->选择Auditorium 
< option value =audi1> Audi 1- Block A 
< option value =audi2 >奥迪2挡A 
<选项值=audi3>奥迪3挡B 
< / select>< / div> 
< input type =submitvalue =Book Auditoriumid =bookonclick =book（）; name =submit> 
< / form> 

php code：

<？php 
 
需要menu.php; 
 
函数NewUser（$ conn）
 {
 $ date = $ _ POST ['selectdate']; 
 $ time = $ _POST ['chosenlot']; 
 $ name = $ _POST ['ename']; 
 $ dept = $ _POST ['branch']; 
 $ audi = $ _POST ['the auditorium']; 
 $ data =INSERT INTO预订（日期，时间段，名称，部门，音频）VALUES（'$ date'，'$ time'，'$ name'，'$ dept'，'$ audi'） ; 
 
 $ result = mysqli_query（$ conn，$ data）; 
} 

它由几个输入框（文本框（输入类型=文本））和日期选择器（输入类型=日期）组成。因此，当单击提交按钮时，除了日期之外，所有数据都将被存储

该字段保持空白。所有其他文本变量都存储在数据库中。



它给出了这个通知：

注意：未定义的索引：selectdate在.......... 

我尝试过：



我以为这是因为你不能通过post方法发送日期类型到php或者php不能通过post方法直接存储日期类型。



i浏览并使用此行：

 $ date = date（'d / m / Y'，strtotime（str_replace） （'。'，' - '，$ _ POST ['selectdate']）））; 
 

然后存储在数据库中的日期是01/01/1970，我尝试了几种不同的方法，但每一个时间是1970/01/01类型

解决方案

conn）
{

date =

_POST [ 'selectdate'];

I am designing a web page and for storing the data i am using the form method.

<form method="POST" action="filldata.php">
<div><input type="date" name="calendar" id="datesetter" name="selectdate"></div>

<div><select id="mySelect" onchange="myFunction()" name="selectslot" >
<option value="-----">Time Slot
  <option value="9to11">9 to 11
  <option value="11to1">11 to 1
  <option value="2to4">2 to 4
</select></div>


<input type="text" placeholder="Enter Name" id="ename" name="ename" class="alignleft" >

<div><select id="mySelectbranch" onchange="myFunction3()" name="branch" >
<option value="-----">Select Department 
  <option value="b1">Computer Engineering
  <option value="b2">Mechanical Engineering 
  <option value="b3">Electrical Engineering
  <option value="b4">Electronics & Telecommunication Engineering
  <option value="b4">Information Technology
</select></div>

<div><select id="mySelectaudi" onchange="myFunction2()" name="auditorium" class="alignright" >
<option value="-----">Select Auditorium 
  <option value="audi1">Audi 1- Block A
  <option value="audi2">Audi 2- Block A
  <option value="audi3">Audi 3- Block B
</select></div>
<input type="submit" value="Book Auditorium" id="book" onclick="book();" name="submit" >
</form>

php code:

<?php

require "menu.php";

function NewUser($conn)
{
	$date=$_POST['selectdate'];
	$time = $_POST['selectslot'];
	$name = $_POST['ename'];
	$dept =  $_POST['branch'];
	$audi =  $_POST['auditorium'];
	$data = "INSERT INTO bookings (date,timeslot,name,dept,audino) VALUES ('$date','$time','$name','$dept','$audi')";
	
	$result=mysqli_query($conn,$data);
}

it consists of few input boxes (text boxes(input type=text)) and a date picker(input type=date). so when submit button is clicked all data is stored except that of date
that field remains blank. All other text variables are stored in database.

it gives this notice:

Notice: Undefined index: selectdate in..........

What I have tried:

I thought this was because you cannot send date type via post method to php or maybe php cannot directly store date type via post method.

i browsed and used this line instead:

$date=date('d/m/Y', strtotime(str_replace('.', '-',$_POST['selectdate'])));

but then the date which was stored in database was 01/01/1970 , i tried few different methods but every time it was of type 1970/01/01

解决方案

conn) {

date=

_POST['selectdate'];

这篇关于我无法在我的数据库中存储日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！