Working Material

      $this -> data [ 'department' ] = $this -> db -> query ( " SELECT * FROM blog " ) -> result ();

  if ( ! empty ( $startdate ))         {             $this -> db -> where ( 'DATE(pickupman_received_date) >=' , $startdate );             }         if ( ! empty ( $enddate ))         {                   $this -> db -> where ( 'DATE(pickupman_received_date) <=' , $enddate );               }