How can I get rid of this logic from the view?

Code:

public function list_celebrities($limit=NULL)

 {

  $this->db->select('...');

  $this->db->from('sincity_celebrities');

  $this->db->join('sincity_events_celebrities', 'sincity_events_celebrities.celebrity_id = sincity_celebrities.id', 'LEFT OUTER');

  $this->db->where('type !=', 'DJ');

  $this->db->group_by("sincity_celebrities.id"); 

  $this->db->order_by("sincity_events_celebrities.id DESC"); 

  $this->db->limit($limit);

  $query = $this->db->get();

  foreach($query->result() as $row)

   {

     $this->result[]=array('id'=>$row->id,'name'=>$row->name, 'facebook'=>$row->facebook, 'photo'=>$row->photo, 'twitter'=>$row->twitter, 'website'=>$row->website, 'type'=>$row->type, 'EID'=>$row->EID);

   }

   return $query;

 }

Code:

foreach($celebrities as $celebrity){ echo $celebrity->photo;}

Code:

if($celebrity->EID!=NULL)

     {

          echo $celebrity->EID;

     }

Code:

// Your other $this->db stuff...



$query = $this->db->get();



return $query->result_array();

Code:

// Your other $this->db stuff...



$query = $this->db->get();



return $query->result_array();

Code:

&lt;?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Test_model extends CI_Model

 {

  public $event_list=array();

  public function list_results()

   {

    $this->db->limit('5');

    $query = $this->db->get('sincity_events');

    return $query->result_array(); 

   }

 }

Code:

&lt;?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');



class Test extends CI_Controller {



 public function index()

  {

   $this->load->model('test_model');

   $data['results'] = $this->test_model->list_results();

   $this->load->vars($data);

   $this->view_things();



  }

 

 public function view_things()

   {

    $this->load->view('test_view');

   }

}?&gt;

Code:

<ul>

&lt;?php foreach ($results as $item):?&gt;

<li>&lt;?php echo $item['title'];?&gt;</li>

&lt;?php endforeach;?&gt;

</ul>

Code:

private function view_things() {}

// OR

function _view_things() {}

Code:

public function edit($page)

  { 

   $this->load->model('page_content_model');

   if($this->page_content_model->check_page($page))

    {

      $results = $this->page_content_model->load_page_components($page);

     foreach($results as $val)

      {

       foreach($val as $column=>$value)

        {

         $data['page_data'][] = array($column=>$value);

        }

      }

     $this->load->library('validations/'.$page,'',$page);

     $this->$page->validate();

     $this->load->vars($data);

     

     $this->load->view('header_view');

     $this->load->view($page);

     $this->load->view('footer_view');  

    }

   else

    {

     redirect(base_url().'not_found', 'location', 301);

    }

  }

Code:

&lt;?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');



 class Sincity_content_booths  

  {

   public function validate() 

    {

     $CI =& get_instance();

     foreach(array('main_title', 'paragraph', 'col_one_title', 'col_one_text', 'col_two_title','col_two_text', 'col_three_title', 'col_three_text', 'second_title', 'photo_one',  'photo_two', 'photo_three') as $key)

      {

       $data[$key] = $CI->input->post($key); 

      }

     $CI->load->vars($data);

     if($CI->input->post('form_submit'))

      {

       ////Photo Management

       $CI->posted_photo = array('photo_one', 'photo_two','photo_three');

       foreach($CI->posted_photo as $photo)

          {

           

           if(strlen($_FILES[$photo]['name'])>0)

            {

             $config['upload_path'] = SITE_PATH."images/booths/";

             $CI->photo_name = time().rand(1,10000000);

             $config['file_name'] = $CI->photo_name.".jpg";

             $config['allowed_types'] = 'gif|jpg|png';

             $field_name = $photo;

             $CI->load->library('upload');

             $CI->upload->initialize($config);

             if ( ! $CI->upload->do_upload($field_name))

              {

               $error[] = array('error' => $CI->upload->display_errors());

              }

             $config_resize['source_image'] = $config['upload_path'].$CI->photo_name.".jpg";

             $config_resize['overwrite'] = TRUE;

             $config_resize['create_thumb'] = FALSE;

             $config_resize['height'] = 132;

             $config_resize['width'] = 326;

             $config_resize['maintain_ratio'] = TRUE;

             

             $CI->load->library('image_lib', $config_resize);

             $CI->image_lib->clear();

             $CI->image_lib->initialize($config_resize); 

             if ( ! $CI->image_lib->resize())

              {

               $CI->image_lib->display_errors();

              }

             else 

              {

               $data[$photo]=$CI->photo_name;

              }

            }

          }

         

       //// End photo management

       $CI->form_validation->set_rules('main_title', 'Title', 'required');

       $CI->form_validation->set_rules('paragraph', 'Page Text', 'required');

       if($CI->form_validation->run() == TRUE)

        {

         $CI->load->model('page_update_model');

         $CI->page_update_model->sincity_content_booths($data);

         redirect(base_url().'manage_pages', 'location', 301);

        }

      }

    }

  }