Multiple Like clauses with where condition in CodeIgniter

By -
Many time we stuck in some situation if we want add multiple like queries with where condition,
So for this, you should use Grouping where clause, see below example:

$this->db->where('status','1');
$this->db->group_start();  //group start
$this->db->like('contact_name',$filter_key);
$this->db->or_like('contact_email',$filter_key);
$this->db->or_like('contact_number',$filter_key);
$this->db->or_like('company_name',$filter_key); 
$this->db->group_end();  //group end
$query = $this->db->get('contacts');

Comments

Post a Comment

Popular posts from this blog

Creating Protected routes in ReactJS

By -
Protected routes are very important for any web application. Below are the code to create authenticated routes that only certain users can access based on their authentication roles. import   React , {  Component  }  from   'react' ; import  {  BrowserRouter   as   Router ,  Route ,  Switch ,  Redirect  }  from   'react-router-dom' ; import   commonService   from   './core/services/commonService' ; import   './App.css' ; import   Loader   from   './views/Loader/Loader' ; // Containers const   FrontEndLayout  =  React . lazy (()  =>   import ( './containers/FrontEndLayout/FrontEndLayout' )); const   UserLayout  =  React . lazy (()  =>   import ( './containers/UserLayout/UserLayout' )); const   loading  = ()  =>   < Loader   /> ; class   App   extends   Component  {    render (){      return  (        < Router >            < React.Suspense   fallback = { loading () } >    
Read more

Redirect http to https in codeigniter

By -
Follow below steps to redirect you non-http site to https without using .htaccess Change Configuration: go to application/config/config.php and enable hooks to true              $config['enable_hooks'] = TRUE; Create new file hooks.php if not exist other wise open file and paste code           $hook['post_controller_constructor'][] = array(                                 'function' => 'redirect_ssl',                                 'filename' => 'ssl.php',                                 'filepath' => 'hooks'                                 ); Now create a new folder hooks if not exist under application folder and then create new file ssl.php and add below code to ssl.php  <?php function redirect_ssl() {     $CI =& get_instance();     $class = $CI->router->fetch_class();     $exclude =  array('client');     if(!in_array($class,$exclude)) {       $CI->c
Read more