Posted By

pruntrut on 06/15/12

Tagged

php
codeigniter

Versions (?)

Last Edited at 06/15/12 12:00am

Statistics

Viewed 875 times

Favorited by 0 user(s)

Related snippets

Codeigniter grouping OR conditions using active record database library

/ Published in: PHP

when someone trying to or two conditions using active record database library in codeigniter

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

$this->db->from('posts');
 
$this->db->where('id', $id);
$this->db->where('(`title` LIKE \'%'.$title.'%\' OR `body` LIKE \'%'.$body.'%\' OR `author` LIKE \'%'.$author.'%\')', NULL, FALSE);
 
// Query:
 
// SELECT * FROM (`posts`) WHERE (`title` LIKE '%ach%' OR `text` LIKE '%ach%' OR `author` LIKE '%ach%') AND `id` = '12'