Sign in Get Started

cideigniter orLike()

Maryanne Webster 
$this->db->select('ae_users.employee_id, ae_users.emp_name, ae_users.emp_name2, ae_users.emp_name3');
		$this->db->from('ae_users');                
		$this->db->where_in('ae_users.employee_id',$employee_ids);
                $this->db->_protect_identifiers = FALSE; // stop CI adding backticks
                $order = sprintf('FIELD(ae_users.employee_id, %s)', implode(', ', $employee_ids));
                $this->db->order_by($order);
                $this->db->_protect_identifiers = TRUE; 
		$query =$this->db->get();
               // echo '<pre>'; print_r($this->db->last_query());exit;
		if ($query->num_rows()) {
			return $query->result_array();
		} else {
			return 0;
		}
View another examples Add Own solution
Log in, to leave a comment

4
5
FenrisVargr 100 points 

                                    $this-&gt;db-&gt;like('title', 'match'); $this-&gt;db-&gt;or_like('body', $match);
// WHERE `title` LIKE '%match%' ESCAPE '!' OR  `body` LIKE '%match%' ESCAPE '!'

4 (5 Votes)
0
3.78
9
Jammo82 105 points 

                                    $this-&gt;db-&gt;select('*')-&gt;from('my_table')
        -&gt;group_start()
                -&gt;where('a', 'a')
                -&gt;or_group_start()
                        -&gt;where('b', 'b')
                        -&gt;where('c', 'c')
                -&gt;group_end()
        -&gt;group_end()
        -&gt;where('d', 'd')
-&gt;get();

// Generates:
// SELECT * FROM (`my_table`) WHERE ( `a` = 'a' OR ( `b` = 'b' AND `c` = 'c' ) ) AND `d` = 'd'

3.78 (9 Votes)
0
Are there any code examples left?
Find Add Code snippet
New code examples in category PHP
SHOW MORE
Create a Free Account
Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.
Sign up
Develop soft skills on BrainApps
Complete the IQ Test
Relative searches
codeigniter where group start group by query in codeigniter group by in codeigniter 3 codeigniter grouping set codeigniter group_by orderby codeigniter get order by ase in codeigniter order by in codeigniter 4 using codeigniter group_by group where and or where in codeigniter group start codeigniter codeigniter get_where order by or group start and group end in codeigniter how to use order by in codeigniter group in codeigniter codeigniter group_start codeigniter groupby codeigniter group query group by name in codeigniter group byname in codeigniter codeigniter where or group order by in codeigniter in query manual order by in codeigniter order by clause in codeigniter codeigniter orderby group_start in codeigniter order codeigniter group by codeigniter database group_by codeigniter group by in codeigniter 4 orderby clause codeigniter group_start codeigniter 4 group by in codeigniter query set group by codeigniter codeigniter order_by order by in codeigniter dsc group start and group end in codeigniter codeigniter 4 group by group_by in codeigniter group by clause in codeigniter group by having in codeigniter group by where codeigniter codeigniter get_where in where condition in codeignter where and order by \in codeigniter limit query codeigniter codeigniter not like query codeigniter db like select codeigniter codignitor select order codeigniter 3 group by with where clause in codeigniter limit in codeigniter query builder group by with order by in codeigniter codeigniter selecting data codeignite where in db where clause in codeignitor 4 ccodeigniter select code igniter order by id order by in sql php codeigniter query sum codeigniter like query in codeignite codeigniter database sum $this- db- insert codeigniter query builder between codeigniter query builder codeigniter orderby join query in ci4 where_in codeigniter code igniter query in model codeigniter query build like codeigniter query build where like group by codeigniter 3 insert query in codeigniter codeigniter get where query group by order by in codeigniter order by sql codeigniter codeigniter delete where codeigniter delete status codeignitor query builder update query in codigniter codeigniter query builder order by codeigniter query builder in codeigniter query builder select codeigniter update code ignoter query group query codeigniter insert codeigniter update codeigniter where or in codeigniter query insert data where ci code igniter update or like codeigniter like in codeigniter codeigniter where not update in codeigniter query db insert codeigniter or_not_where codeigniter where_like in codeigniter select codeigniter 3 order_by in codeigniter order system in codeigniter codeigniter set query codeigniter database group by codeigniter order_by desc codelgniter database get query $this- db- table join in ci4 group by in codeigniter codeigniter db select where does codeigniter 3 db replace create new entries does codeigniter db replace create new entries codeigniter 4 query builder where or how to insert database in codeigniter 3 ci select where query sql query in codeigniter for and clause codeigniter database update query codeigniter update db codeigniter db get get compiled select codeigniter order by query in codeigniter in statement codeigniter 3 alternative to mysql like codeigniter update query builder codeigniter codeigniter query like condition codeigniter+$this-&gt;db -&gt;where( codeigniter update query how to implements this or_like($field[, $match = ''[, $side = 'both'[, $escape = NULL]]]) codeigniter Model insert bydefult data desc in codeigniter how to use $builder-&gt;orWhere codeigniter like query in ci4 codeigniter dbbuilder codeigniter inner join get all query database codeigniter select between values codeigniter codeigniter 3 query builder join codeigniter 3 where codeigniter select like this- db- where codeigniter in query in codeigniter $query = $this- db- get() 'select' =&gt; in codeigniter? which query batch insert is generated how i can found in codeigniter codeigniter 3 model get_by codeiniter set codeigniter sum query codeigniter where like query codeigiter update querry builder limit in codeigniter 3 get database pyarangodb how to write match query in codeigniter codeigniter gike where like codeigniter ci delete query codeigniter insert query example $this- db- get() in codeigniter how to use like in codeigniter codeigniter build query like in codeigniter query codeigniter or_where mcodeigniter mysql insert codeigniter 3 get_compiled_select codeigniter get_compiled_select codeigniter db query builder not working codeigniter select where_in codeigniter group by query get select option boolean database codeigniter codeigniter4 insert error WHERE name != 'Classes' codeigniter codeigniter r query builder order by codeigniter query codeigniter db order by codeigniter 3 db where conditionals codeigniter db where like ci db limit db- insert in codeigniter codeigniter or like query codeigniter 4 getwhere result offset starting codeigniter query get_where with order by in codeigniter get where codeigniter query ordery by codeigniter select where query codeigniter query limit codeigniter where_in php insert query in ci codeigniter where raw codeigniter limit 1 query where a name is like in codeigniter codeginiter select where is not in the selected request cocdeigniter where in code igniter query buildere delete query codeigniter query builder code igniter db where codeigniter save dta orlike codeigniter codeigniter model-&gt;where get codeigniter query codeigniter $this-&gt;db-&gt;where how to see the query from query builder coeigniter php this db select where codeigniter sum codeigniter codeigniter order by update codeigniter get &quot; not \&quot; codeigniter model get &quot; to query $this-&gt;db-&gt;or_like close ) query builder codeigniter join table codeigniter db query builder codeigniter db like query join tabel query builder codeigniter update query in codeigniter 3 codeigniter db-&gt;where select query in codeigniter 3 update in codeigniter 3 query_id in codeigniter where do codeigniter $this-&gt;db-&gt;select('a.*'); $this-&gt;db-&gt;from('supplier_product a'); codeigniter where not like codeigniter query and where $this- db- where or codeigniter codeigniter 3 rquery codeigniter 3 diff update query codeigniter 3 update this db group by codeigniter where or values codeigniter select field in codeigniter codeigniter mysql query builder with limit ci select query codeigniter database query builder codeigniter 3 where in codeigniter select query with where clause $builder-&gt;replace() array codeigniter $builder-&gt;replace() codeigniter get where and where set in codeigniter where not in codeignoter select all query in codeigniter inner join codeigniter or based mysql query in codeigniter codeiginter where in dele codeigniter 3 codeigniter db delete codeigniter insert bd codeigniter limit codeigniter select query order_by codeigniter 4 left join codeigniter codeigniter query builder where and order replace into where codeigniter codeignioter updaet table mysq builder codeigneter right join codeigniter array extract how to call a database of a group in codeigniter codeigniter delete dv join codeigniter 3 $this- db- limit codeigniter $.get() codeigniter codeigniter 3 unsetdata codeigniter write raw mysql insert query codeigniter mysql query insert into db- update in codeigniter codeigniter limit 1 codeigniter db select where and codeigniter db select and codeigniter db select or codeigniter where_not_in codeigniter database independent query codeigniter plateform independent query query in codeignator to check the record one by one in raw codeiginter where code igniter and where wherein codeigniter codeitgniter WHERE IN codeigniter like query builder get data limit result codeigniter codeigniter get whre codeigniter get query codeigniter insert into database query ci select in codeigniter join codeignitre inset in coeginter query codeigniter db insert code igniter where in codeigniter where array codeigniter hoin codeigniter 3 db-&gt;update ci where in query codeigniter array kebalikan dari replace &quot;$this-&gt;db-&gt;where($&quot; codeigniter limit 10 codeigniter 3 order by where like in codeigniter codeigniter 3 database query select one column in codeigniter query builder select one row in slw codeigniter 3 codeigniter where select statement codeigniter codeigniter where query and where codeigniter php get where codeigniter cideigniter orLike() update codeigniter query codeigniter db query search update in codeigniter codeigniter 3 limit with field from another table codegniter limit or like query in codeigniter like % % query in codeigniter codeigniter where in db codeigniter order_by code igniter get value is not codeigniter query codeigniter row and table data insert order by in codeigniter 3 codeigniter $this-&gt;db-&gt;insert codeigniter or_like sql codigniter join where codeigniter limit in codeigniter where in array codeigniter select * from nama_program where nama_program codeigniter codeigniter this db get codeigniter from date to to selct sellect query this db query codeigniter update codeingter sum and order by ar function codeigniter db not in sort get_where codeigniter codeigniter join codeigniter query equal codeigniter query builder query string codeigniter like this-&gt;db where and $this-db limit get_where codeigniter query with sort like query in codeigniter find or create codeigniter codeiginter left join codeigneter select codeigneter get select select_sum in codeigniter with join limit table codeigniter codeigniter 2.3 db replace codeigniter and where clause query where codeigniter where not codeigniter codeigniter builder where codeigneter get where get codigniter order_by codeigniter get query in codeigniter $this-&gt;db-&gt;query(&quot;SELECT * codeigniter save query codeignitor delete code giniter select codeigniter get where $this-&gt;db-&gt;select()-&gt;from('table ') $this- db- select in codeigniter select from as codeigniter delete query in codeigniter 3' Where this or this in codignitoru codeigniter 3 query codeiginter delete get data codeigniter or like codeigniter 3 codeigniter group by query builder join codeigniter codeigniter query group by where group codeigniter how to write orderby in join query codeigniter like codeigniter $this-&gt;db-&gt;insert codeigniter insert in codeigniter codeigniter 3 join codeigniter update data db where where() in codeigniter what i where() in codeign codeigniter query groupings codeigniter insert codeigniter model limit offset query in postgresql limit codeigniter where in codeigniter codeingiter queryies 3 select codeiginter like or where use model query $this- db- select join in codeigniter where array in codeignitor codeigniter where in query where array in codeigniter set query in mysql codeigniter codeigniter where data where_in codeigniter 3 codeigniter find codigniter find all update query in codeigniter select top 10 records in codeigniter by custom database object set in ci where id &gt; 2 codeigniter get where codeigniter update query codeigniter get_where codeigniter 3 AND WHERE in codeigniter query 3 code igniter 3 this -&gt;db -&gt; get_where () codeigniter 3 query builder query builder codeigniter codeigniter insert update codeigniter.com query builder insert codeigniter.com query builder codeigniter query builder codeigniter insert query model getwhere codeigniter get compiled query codeigniter codeigniter 3 insert query codeigniter order by ASC codeigniter get delete codeigniter codeigniter db update codeigniter delete query codeigniter 3 insert optional chaining php codeignitor get where in codeigniter where in array update codeigniter where in array codeigniter update codeigniter where id in update codeigniter where id array update how to get data from model ascending codeigniter all() codeigniter how to control update data into database check type field the same or not then execute codeiginter limit codeigniter mysql how to select data 100000 report in 5 table faster using codeigniter 3 sample code for display ordered items based on another table ordered id using codeingniter get_where codeigniter where_not_in codeigniter example codeigniter delete not in codeigniter MYSQL IN in codeigniter model order by in ci query order by codeigniter codeigniter query result using builder where or codeigniter codeigniter select group by codeigniter if single id have multiple items how to get from database in codeigniter order by in codeigniter codeigniter like query where not in codeigniter get all data in desc in codeigniter codeigniter order by where and codeigniter codeigniter where order by
Made with love
This website uses cookies to make IQCode work for you. By using this site, you agree to our cookie policy

Welcome Back!

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign in
Recover lost password
Or log in with
Not registered?
Sign up takes less than a minute

Create a Free Account

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign up
Or sign up with
By signing up, you agree to the Terms and Conditions and Privacy Policy. You also agree to receive product-related marketing emails from IQCode, which you can unsubscribe from at any time.
Creating a new code example
Code snippet title
Source