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

Stop video playing when Bootstrap modal is closed

By -
If you want add a video to a Bootstrap Modal and either dismiss or close the modal  while the video is playing the video will keep on playing when you open again. So you can adjust this behaviour by adding in some JavaScript that acts to stop the video if either the modal window is clicked to close or the background is clicked to dismiss the modal. Add below JavaScript code in your files <script> jQuery(' #keredariModal ').on('hidden.bs.modal', function (e) { // do something... jQuery(' # keredariModal video ').attr("src", jQuery(" # keredariModal video ").attr("src")); }); </script>    Note: Please replace your Model ID
Read more