codeigniter:使用php在mysql中的两个日期之间获取数据 [英] codeigniter : getting data between two dates in mysql using php

问题描述

我想在mysql中的两个日期之间检索数据.

I want to retrieve data between two dates in mysql.

从日期开始:01/04/2015 迄今为止:01/05/2015

from date : 01/04/2015 to date : 01/05/2015

但是我无法通过单个变量获取这些日期；

but i cant get date these in single variable;

我如何获得如下所述:

$fdate=01;
$fmonth=04;
$tdate=01;
$tmonth=05;
$year=2015;

我在模型中的代码:

function date_range($fdate,$fmonth,$tdate,$tmonth,$year)
        {
            $this->db->select('*');
            $this->db->where('DAY(order_date) >=',$fdate);
            $this->db->where('MONTH(order_date) >=',$fmonth);
            $this->db->where('YEAR(order_date) >=',$year);
            $this->db->where('DAY(order_date) <=',$tdate);
            $this->db->where('MONTH(order_date) <=',$tmonth);
            $this->db->where('YEAR(order_date) <=',$year);
            return $this->db->get('orders');
        }

有时它会正确返回结果，有时它不会返回结果，但是我在提到的两个日期之间的mysql中有数据.

some times it return results properly, and some times it not return result, but i had an data in mysql between mentioned two dates.

我在此代码上犯了什么错误，请帮助我

what mistake i make on this code please help me

推荐答案

您可以使用

$this->db->where("YOUR COLUMN BETWEEN DATE_FORMAT(COLUMN1,'%d/%m/%Y') AND DATE_FORMAT(COLUMN2,'%d/%m/%Y'"));

这篇关于codeigniter:使用php在mysql中的两个日期之间获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！