使用PHP获取两个日期之间的MySQL数据 [英] get mysql data between two dates using php
本文介绍了使用PHP获取两个日期之间的MySQL数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试获取两个日期之间的数据,日期在MySQL中存储为DATETIME
,并显示为2016-04-02 04:55:03
I am Trying to fetch Data between two dates, date was stored as DATETIME
in mysql and showing as 2016-04-02 04:55:03
要获取日期,我将引导日期时间选择器与如下所示的输入表单一起使用
to get dates I am using bootstrap datetimepicker with input form like below
<div class="input-group date" id="datetimepicker1">
<input type="text" class="form-control" id="checkin" name="from_date" data-date-format="dd/mm/yyyy" placeholder="Select Start Date">
<span class="input-group-addon"><i class="glyphicon glyphicon-calendar"></i></span>
</div>
<div class="gap-small"></div>
<div class="input-group date">
<input type="text" class="form-control datechange" id="checkout" name="to_date" data-date-format="dd/mm/yyyy" placeholder="Select End Date">
<span class="input-group-addon"><i class="glyphicon glyphicon-calendar"></i></span>
</div>
我正在使用AJAX将这些值发送到PHP.
and i am using AJAX to send these values to PHP.
在结果页面中:
var_dump($_POST)
结果:
array(3) { ["from_date"]=> string(10) "30/03/2016" ["to_date"]=> string(10) "05/04/2016" ["search_place"]=> array(1) { [0]=> string(0) "" } }
我正在获取from_date
和to_date
现在,当我尝试在日期之间检索时,以下sql语句无法正常工作
now when i am trying to retrive between from and to dates its not working below is my sql statement
$sql="SELECT * FROM mytable WHERE evedate BETWEEN '" . $from_date . "' AND '" . $to_date . "'";
推荐答案
$sql="SELECT * FROM mytable WHERE evedate BETWEEN concat(str_to_date('".$from_date."','%d/%m/%Y')) AND concat(str_to_date('".$to_date."','%d/%m/%Y')
正在工作
这篇关于使用PHP获取两个日期之间的MySQL数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文