CODEWITHSUNDEEP
cakephp
prabhu
prabhu

Reputation: 3

How to convert sql query to cakephp query and use in controller

SELECT count(*) FROM payments WHERE status='Success' and createddate BETWEEN '2020-05-05' AND '2020-05-06'

$numcount= TableRegistry::get('Payments')->find('all', array(
    'conditions' => array('status'=>'Success','and' => array(
    array('createddate <= ' => $date1,
        'createddate >= ' => $date2
    )
))))->count();

Please help. Thanks in advance. I tried but the code doesn't work.

Upvotes: 0

Views: 52

Answers (1)

Greg Schmidt
Greg Schmidt

Reputation: 5099

You've got your dates backwards. Also, you don't need an extra 'AND' in your conditions, they're all AND by default.

$numcount= TableRegistry::get('Payments')->find('all', array(
    'conditions' => array(
        'status' => 'Success',
        'createddate >=' => $date1,
        'createddate <=' => $date2
    )
))->count();

Upvotes: 1

Related Questions