• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Active Record Class

#1
Until recently, I've always been able to use the Active Record class to access my databases. Now I have a query with a WHERE clause that looks like this: WHERE item = 1 AND (description LIKE '%keyword%' OR name LIKE '%keyword%'). I'm curious how I would use the where and like functions in the Active Record class to create this clause.
Thanks, Marci
Reply

#2
(12-16-2014, 09:30 PM)marci Wrote: Until recently, I've always been able to use the Active Record class to access my databases.  Now I have a query with a WHERE clause that looks like this:  WHERE item = 1 AND (description LIKE '%keyword%' OR name LIKE '%keyword%').  I'm curious how I would use the where and like functions in the Active Record class to create this clause.
Thanks, Marci

Hi,

Try these:

$this->db->where('item', 1);
$this->db->like('description', $keyword);
$this->db->or_like('name', $keyword);
Proprietor and Developer:

http://app-arsenal.com
http://senhosting.com
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.