How to search data using multiple where Codeigniter

Question

I have some issue when I want to search some data from my database using Codeigniter. I want to select data where the level is 0 and 3 with status 1

    tb_user_data :  
         ----------------------------------
        | username | name | level | status |
         ----------------------------------
        | abb      | ab   | 0     | 1      |
        | abc      | aa   | 1     | 1      |
        | aac      | bb   | 2     | 1      |
        | acc      | cc   | 3     | 1      |
         ----------------------------------

script select data 

$data["adm"] = $this->db->where("level", "0")
                        ->or_where("level", "3")
                        ->where("status", "1")
                        ->get('tb_user_data')->result_array();

when I try to search it by the name, the script doesn't working. Or I got some wrong script or anything else?

thank you

doesn't work is the WORST thing a programmer should say to a other programmer.. the code doesn't include the name search .. try adding `andWhere("name", [name])` — Raymond Nijland, Feb 15 '18 at 09:15
just write the syntax inline in one function `where('(a or b) and c')` — Faytraneozter, Feb 15 '18 at 09:17
you can ->where_in clause in codeigniter. see below link it will be helpful for you https://stackoverflow.com/questions/11023318/using-mysql-where-in-clause-in-codeigniter — Gufran Hasan, Feb 15 '18 at 09:17
By the way you can debug your sql before see the result using `$this->db->last_query();` — Faytraneozter, Feb 15 '18 at 09:19

score 1 · Accepted Answer · answered Feb 15 '18 at 09:19

1

Try this:

$data["adm"] = $this->db->where_in('level', array('0','3'))
                        ->where("status", "1")
                        ->get('tb_user_data')->result_array();

answered Feb 15 '18 at 09:19

Ankit Singh

1,502
1
11
22

Welcome @ImamNur. Accept as answer if it helps you. :) – Ankit Singh Feb 15 '18 at 09:23

How to search data using multiple where Codeigniter

1 Answers1