CakePHP adding array elements to an array

Question

I think I have my dumber-than-usual head on today.

I am trying to parse text from a textbox in a form to generate an array that I can pass to the find method in cakePHP.

I have used php regular expressions to generate an array of the terms entered (including "phrases included in speech marks" as single item)

This may look like this:

array(
(int) 0 => 'test',
(int) 1 => 'this out',
(int) 2 => 'now')

In the cakePHP cookbook it says that I have to get an array that looks like this (using above example):

array(
array('ProjectDocumentSectionVariable.variable_description  LIKE' => '%test%'),
array('ProjectDocumentSectionVariable.variable_description  LIKE' => '%this out%'),
array('ProjectDocumentSectionVariable.variable_description  LIKE' => '%now%'))

Try as I might, I end up with arrays that do NOT look like an array of arrays.

Typically I am ending up with this horrible looking thing:

array(
(int) 0 => array(
    'ProjectDocumentSectionVariable.variable_description LIKE' => '%test%'
),
(int) 1 => array(
    'ProjectDocumentSectionVariable.variable_description LIKE' => '%this out%'
),
(int) 2 => array(
    'ProjectDocumentSectionVariable.variable_description LIKE' => '%now%'
))

The code for the above is:

$i = 0;
            foreach($matches[1] as $match) :
                $searcharray['ProjectDocumentSectionVariable.variable_description LIKE'] = "%" . $match . "%";                  
                array_push($array_full,$searcharray);
                $i++;
            endforeach;

THis must be a common requirement, so I am hoping one of you guys could put me on the straight an narrow...

Thanks

Please edit to use actual model and field names - it helps to understand the question. Your bottom section and your 'hoping for this' section don't line up at all as far as names, which makes it confusing. Also - what is your "matches" array? And your $searcharray? — Dave
– Dave, Commented Nov 15, 2013 at 14:24
Yes, sorry Dave - less haste more speed. The matches array is the one that is shown at the top, coming out of the reg expression processing of textbox content.. $searcharray is set on the line it is first mentioned... I think. (It does seem to behave "properly" - but may be where I am going wrong!) — Paul Snell
– Paul Snell, Commented Nov 15, 2013 at 14:27

Dave · Accepted Answer · 2013-11-16 21:19:14Z

1

If you're trying to build a search query (not clear what your goal is), your conditions should all be in the same array within an OR or AND - something like this:

$searchResults = $this->find('all', array(
    'conditions' => array(
        'OR' => array(
            'ProjectDocumentSectionVariable.variable_description  LIKE' => '%test%',
            'ProjectDocumentSectionVariable.variable_description  LIKE' => '%this out%',
            'ProjectDocumentSectionVariable.variable_description  LIKE' => '%now%'
        )
    )
));

If you want to build it out in a foreach() loop, you can do it something like this:

$conditions = array('OR' => array());
$matches = array('test', 'this out', 'now');
foreach($matches as $match) {
    array_push($conditions['OR'], array('variable_description LIKE' => '%' . %match . '%'));
}

$searchResults = $this->find('all', array(
    'conditions' => $conditions
));

edited Nov 16, 2013 at 21:19

answered Nov 15, 2013 at 15:02

Dave

29.2k26 gold badges117 silver badges184 bronze badges

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

3 Comments

Paul Snell Over a year ago

Yes, I am trying to do that..Thanks for your time. the foreach loop above leaves a condition array with only one item - the last item in the $matches array... any other ideas?

Dave Over a year ago

updated - forgot you'll need it to be within an AND or an OR array.

Paul Snell Over a year ago

Thanks David, this did it. It was the setting up of the initial array with the or array and then pushing to that that flumoxed me! Brill. Thanks again.

mewc · Accepted Answer · 2017-08-20 02:24:38Z

0

its as simple as this:

 $array= array();
    foreach ( $colors as $c):
        $uniques[] = $c;   
    endforeach;

not having the [] will treat it as a regular variable. This will append it to the array

answered Aug 20, 2017 at 2:24

mewc

1,4671 gold badge18 silver badges27 bronze badges

Collectives™ on Stack Overflow

CakePHP adding array elements to an array

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related