Categories
Tutorial

How to use BETWEEN in CakePHP – Quick Slice

Pssst… Wanna know how to use a SQL BETWEEN statement in CakePHP without having to use an anonymous function? Here ‘ya go.

$Query = $Table
    ->find()
    ->where([
        'date BETWEEN :start AND :end'
    ])
    ->bind(':start', '2020-01-01', 'date')
    ->bind(':end',   '2020-12-31', 'date');

(Shamelessly stolen from Stack Overflow)

Hope you enjoyed your slice of Cake 🍰