How to use CodeIgniter's like() with multiple columns? [duplicate]

Question

Here is my selection code from db:

$q = $this->db->like('Autor1' or 'Autor2' or 'Autor3' or 'Autor4', $vyraz)
    ->where('stav', 1)
    ->order_by('id', 'desc')
    ->limit($limit)
    ->offset($offset)
    ->get('knihy');
                    
return $q->result();

Where $vyraz = "Zuzana Šidlíková";

And the error is:

Nastala chyba databĂˇzy

Error Number: 1054

Unknown column '1' in 'where clause'

SELECT * FROM (\knihy`) WHERE `stav` = 1 AND `1` LIKE '%Zuzana Ĺ idlĂkovĂˇ%' ORDER BY `id` desc LIMIT 9

Filename: C:\wamp\www\artbooks\system\database\DB_driver.php

Line Number: 330

Can you help me solve this problem?

This question is similar to: How to use like, or_like and get_where together in Codeigniter 3. If you believe it’s different, please edit the question, make it clear how it’s different and/or how the answers on that question are not helpful for your problem. — mickmackusa
– mickmackusa ♦, Commented Apr 17 at 17:23
See Convert SELECT query containing equals comparison and 3 OR LIKE conditions to CodeIgniter active record syntax and Code Igniter - MySQL query using where and like and CodeIgniter active record query with multiple OR LIKE conditions and AND WHERE conditions and Search database table where each word of a search term is at least a partial match for one of multiple columns with CodeIgniter's active record — mickmackusa
– mickmackusa ♦, Commented Apr 17 at 17:30
And Wrap multiple LIKE conditions in parentheses with CodeIgniter's query building methods and Combining where and like statements by using the CI activerecords and Grouping WHERE clause logic with CodeIgniter active record query and Use CodeIgniter's active record to get records which contain a search value in one of several columns — mickmackusa
– mickmackusa ♦, Commented Apr 17 at 17:33
And CodeIgniter SELECT query with WHERE clause containing equals, IN, and LIKE as well as AND and OR is not returning correct results and Display database search results as an HTML table with CodeIgniter and Codeigniter active record query with a WHERE clause containing a mix of LIKE and non-LIKE conditions — mickmackusa
– mickmackusa ♦, Commented Apr 17 at 17:37

No Results Found · Accepted Answer · 2012-08-29 18:38:44Z

1

Your syntax is wrong for what you're trying to do, but still technically valid, because this:

'Autor1' or 'Autor2' or 'Autor3' or 'Autor4'

...is actually a valid PHP expression which evaluates to TRUE (because all non-empty strings are "truthy"), which when cast to a string or echoed comes out as 1, so the DB class is looking to match on a column called "1".

Example:

function like($arg1, $arg2)
{
    return "WHERE $arg1 LIKE '%$arg2%'";
}

$vyraz = 'Zuzana Šidlíková';
echo like('Autor1' or 'Autor2' or 'Autor3' or 'Autor4', $vyraz);

// Output: WHERE 1 LIKE '%Zuzana Šidlíková%'

Anyways, here's what you need:

$q = $this->db
    ->like('Autor1', $vyraz)
    ->or_like('Autor2', $vyraz)
    ->or_like('Autor3', $vyraz)
    ->or_like('Autor4', $vyraz)
    ->where('stav', 1)
    ->order_by('id', 'desc')
    ->limit($limit)
    ->offset($offset)
    ->get('knihy');

edited Aug 29, 2012 at 18:38

answered Aug 29, 2012 at 18:18

No Results Found

103k38 gold badges199 silver badges232 bronze badges

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

5 Comments

No Results Found Over a year ago

What do you mean "not working"? More information - as much as possible. Same error message? Not producing the query you want? Not returning results you expect? Exactly what do you mean?

No Results Found Over a year ago

I see no reason why that would be true, are you 100% sure you aren't just running your original code again? Try commenting out parts of it to see where the problem comes from. Do you understand the error I pointed out?

Geril Over a year ago

I am absolutely sure that I run your new code. I tried it with die(); adding die(); on different position unlit error disappeared and problem is in querry

No Results Found Over a year ago

I can't understand why this code would produce the same exact query as your original broken/invalid code. What specifically was the part you commented out that got the error to disappear?

Geril Over a year ago

You was right I have problem in different part of code :) THANKS A LOT! :)

Collectives™ on Stack Overflow

How to use CodeIgniter's like() with multiple columns? [duplicate]

1 Answer 1

5 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Linked

Related