比较Codeigniter和MySQL中的两个日期 [英] Compare two dates in Codeigniter and MySQL
本文介绍了比较Codeigniter和MySQL中的两个日期的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何在Codeigniter查询函数中获取两个日期之间的值?这是我的模型和示例代码.
How can I get values between two dates in Codeigniter query function? Here is my model and sample code.
function get_promo() {
$today = date('Y-m-d');
$query = $this->db->query('SELECT FROM tbl_event WHERE event_id = $id AND event_startdate <= $today
AND event_enddate >= $today');
return $query;
}
但这不起作用,这是我收到的错误
But it doesn't work, here is the error I got
A Database Error Occurred
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM tbl_event WHERE event_id = 36 AND event_startdate <= 2011-06-09 ' at line 1
SELECT FROM tbl_event WHERE event_id = 36 AND event_startdate <= 2011-06-09 AND event_enddate >= 2011-06-09
Filename: C:\xampp\htdocs\hotel\system\database\DB_driver.php
Line Number: 330
推荐答案
我认为您需要在约会前后(即"2011-06-08")进行qoutes.试试这个
I think you need qoutes around your date (i.e. '2011-06-08'). try this
function get_promo() {
$today = date('Y-m-d');
$query = $this->db->query(
"SELECT FROM tbl_event WHERE event_id = {$id} AND event_startdate <= '{$today}'
AND event_enddate >= '{$today}'");
return $query;
}
如果您的列event_startdate
和event_enddate
是DATETIME
类型,但是您只对日期部分感兴趣,则可以执行`DATE(event_enddate)提取日期部分
If your columns event_startdate
and event_enddate
are DATETIME
type but you are only interested in the date part you can do `DATE(event_enddate) to extract the date part
这篇关于比较Codeigniter和MySQL中的两个日期的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文