build query in array for cakephp 3

Question

I am writing an application with search functionalities. There are many filters to be applied so I want to build the filter query outside the find() function in CakePHP 3.4 Application

This is what I want to achieve

$start_year = $this->request->getQuery('start_year');
$end_year = $this->request->getQuery('end_year');
$keyword = $this->request->getQuery('keyword');
$make = $this->request->getQuery('make');

$query_builder = [];

if (!empty($keyword)) {
    $query_builder['keyword'] = $keyword;
}
if (!empty($make)) {
    $query_builder['make'] = $make;
}

if (!empty($start_year) && empty($end_year))
{
    $query_builder['year >'] = $start_year;
}

if (empty($start_year) && !empty($end_year)) {
    $query_builder['year <'] = $end_year;
}

if (!empty($start_year) && !empty($end_year)) {
    // how to written in BETWEEN query here on year column
}

$results = $this->Model->find()
    ->where($query_builder);

How to build query in array for IN BETWEEN query ?

ndm · Accepted Answer · 2017-08-27 14:04:49Z

1

if (!empty($start_year) && !empty($end_year)) {
    $query_builder['year >='] = $start_year;
    $query_builder['year <='] = $end_year;
}

edited Aug 27, 2017 at 14:04

ndm

60.6k9 gold badges73 silver badges113 bronze badges

answered Aug 26, 2017 at 10:03

Benfarhat

1837 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ndm Over a year ago

The second example will not work, binding values doesn't work like that anymore in CakePHP 3.x!

Collectives™ on Stack Overflow

build query in array for cakephp 3

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related