Create array from for-loop cakePHP

Question

I'm making a very simple search-function in cakePHP, and want to populate an array from a for-loop with arrays dynamically.

I'm thinking of creating an array to set put as second parameter int the find()-function.

This is my static result:

$result = $this->Book->find('all', array('conditions' => 
      array("Book.book_title LIKE" => "%war%"),
      "OR" => 
      array("Book.book_title LIKE" => "%and%"),
      "OR" =>
      array('Book.book_title LIKE' => "%peace%")
));
$this->set('searchResult', $result);

My first intuition was to do so:

$search = $this->request->query['q'];
$words = explode(" ", $search);
$count = count($words);

And then create a for-loop from this, but the "OR =>" is causing me a lot of trouble to integrate. Can anybody help me to make this for loop?

Thanks in advance, Jesper.

mark · Accepted Answer · 2014-06-10 12:04:18Z

2

Why making life so complicated? Use OR once as main key and a simple array of arrays below it:

$conditions = array(
    'OR' => array(
        array('Book.book_title LIKE' => '%term1%'),
        array('Book.book_title LIKE' => '%term2%'),
        ...
    )
)

The nested arrays are necessary to avoid reusing the same array key (which does not work in PHP).

If it is coming from an exploded search query term, use foreach to keep things DRY (dont repeat yourself)

$terms = explode(' ', $his->request->query('q'));
foreach ($terms as $term) {
    $conditions['OR'][] = array('Book.book_title LIKE' => '%' . $term . '%'),
}

answered Jun 10, 2014 at 12:04

mark

21.8k3 gold badges54 silver badges75 bronze badges

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

1 Comment

Jesper Bruun Hansen Over a year ago

Yes, this was exactly the kind of wisdom i needed. Thanks for clarification :)

Collectives™ on Stack Overflow

Create array from for-loop cakePHP

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related