cakephp condition with LIKE operator: how to handle multiple values

cakephp-1.3
capsula picture capsula · Dec 30, 2011 · Viewed 12.1k times · Source

Hi I'm trying to do a condition like this:

array("Curriculum.name LIKE" => $array,"Curriculum.surname LIKE" => $array,)

But cakephp output is the following:

WHERE ((`Curriculum`.`name` LIKE IN ('%jon%','%x%')) OR (`Curriculum`.`surname` LIKE IN ('%jon%','%x%'))

Any idea in how to achieve this?

Answer

deceze picture deceze · Dec 30, 2011 
foreach ($array as $name) {
    $conditions['or'][] = array('Curriculum.name LIKE' => "%$name%");
    $conditions['or'][] = array('Curriculum.surname LIKE' => "%$name%");
}

Related questions

404 Not Found The requested URL was not found on this server

I'm having small troubles and was wondering if someone can help me over the hump. I pulled a copy of a website down from Hostgator and I'm trying to set it up on my local machine using WAMP but, I …

Read More
TypeError: $(...).on is not a function

I am using jQuery litebox. After adding JS and CSS files I got this error TypeError: $(...).on is not a function at this line in js file "return $('body').on('click', 'a[rel^=lightbox], area[rel^=lightbox]', function(e) {" …

Read More
Set Response Status Code

I have an API call for which I need to be able to run some checks and potentially return various status codes. I don't need custom views or anything, I just need to return the proper code. If the user …

Read More