add join in datatables using codeigniter

By -
Sets join statement variables. If you want DataTables to include data from another table, you can define an a table along with its columns and foreign key relationship.
$this->datatables->join('states', 'cities.state_id = states.id', 'left');
$this->datatables->select('cities.id,cities.name,states.name as state_name')
->from('cities'); 

Comments

Post a Comment

Popular posts from this blog

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

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 ...
Read more