Getting data posted in between two dates

Question

How can I retrieve data from the database by querying records between two dates using CodeIgniter s activerecord

User · Answer

This worked for me    this- gt db- gt where  RecordDate  gt      2018-08-17 00 00 00     this- gt db- gt where  RecordDate  lt      2018-10-04 05 32 56

User · Answer

This worked great for me   this- gt db- gt where  sell date BETWEEN     date  Y-m-d   strtotime  start date       and     date  Y-m-d   strtotime  end date

User · Answer

May this helpful to you      With Join of Three Tables  public function get details beetween dates                  from    this- gt input- gt post  fromdate             to    this- gt input- gt post  todate              this- gt db- gt select  users first name  users last name  users email  groups name as designation  dailyinfo amount as Total Fine  dailyinfo date as Date of Fine  dailyinfo desc as Description                       - gt from  users                       - gt where  dailyinfo date  gt      from                      - gt where  dailyinfo date  lt      to                      - gt join  users groups   users id   users groups user id                       - gt join  dailyinfo   users id   dailyinfo userid                       - gt join  groups   groups id   users groups group id                         this- gt db- gt select  date  amount  desc                    - gt from  dailyinfo                    - gt where  dailyinfo date  gt      from                   - gt where  dailyinfo date  lt      to                        q    this- gt db- gt get              array  userDetails      q- gt result            return  array

User · Answer

Try This    this- gt db- gt where  sell date BETWEEN     date  Y-m-d   strtotime  start date       and     date  Y-m-d   strtotime  end date           Hope this will work

User · Answer

If you want to compare SQL dates  you can try this    this- gt db- gt select     this- gt db- gt from  table name     this- gt db- gt where   date columnname  gt   date     from         this- gt db- gt where   date columnname  lt   date     to          That worked for me  PHP and MySQL

User · Answer

query    this- gt db               - gt get where  orders  array  order date  lt     gt  first date  order date  gt     gt  second date                 - gt result array

User · Answer

This looks like what you need    this- gt db- gt where  order date  gt      first date    this- gt db- gt where  order date  lt      second date   return  this- gt db- gt get  orders

User · Answer

Just simply write BETWEEN    startDate   AND    endDate    in where condition as  - gt where  date BETWEEN    startDate   AND    endDate

User · Answer

if your date filed is timestamp into database then this is the easy way to get record  this- gt db- gt where  DATE RecordDate   gt     date  Y-m-d  strtotime  startDate      this- gt db- gt where  DATE RecordDate   lt     date  Y-m-d  strtotime  endDate

User · Answer

if you want to force using BETWEEN keyword on Codeigniter query helper  You can use where without escape false like this code  Works well on CI version 3 1 5   Hope its help someone   if  empty  tglmin   amp  amp   empty  tglmax             this- gt db- gt group start             this- gt db- gt where  DATE create date  BETWEEN     tglmin    AND     tglmax         false            this- gt db- gt group end

[php] Getting data posted in between two dates

Examples related to php

Examples related to sql

Examples related to codeigniter

Examples related to activerecord