Login

02-28-2010, 02:48 AM

[eluser]invision[/eluser]
Controller

Code:
&lt;?php

class Page extends Controller {

  function Page(){

    parent::Controller();

    session_start();

  }

  function index(){

    // say 'home' is the value of the slug in my sql table

    $data['page_data'] = $this->MPages->getPageBySlug('home');

    $data['title'] = "Welcome";

    $data['main'] = 'public_home';

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

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

  }

  function aboutus($page) {

    $this->pages($page); //no need to copy / paste the code, just call the function that has it

  }

  function pages($slug){

    $data['page_data'] = $this->MPages->getPageBySlug($slug);

    $data['title'] = $data['page_data']['title'];

    $data['main'] = 'public_page';

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

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

  }

}

Model:

Code:
&lt;?php

class MPages extends Model{

    function MPages(){

        parent::Model();

    }

    function getPageBySlug($slug){

        $data = array();

        $this->db->where('slug',$slug);

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

        $Q = $this->db->get('pages');

        if ($Q->num_rows() > 0){

          $data = $Q->row_array();

        }

        $Q->free_result();    

        return $data;    

    }

}

Views:

Code:
&lt;?php

// public_page.php

echo auto_typography($post_data['title']);

echo auto_typography($post_data['body']);

Code:
// template.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

&lt;html &gt;

&lt;head&gt;

&lt;meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /&gt;

&lt;title&gt;&lt;?php echo $title; ?&gt;&lt;/title&gt;

&lt;link href="/serconia/includes/css/main.css" rel="stylesheet" type="text/css" /&gt;

&lt;/head&gt;

&lt;body class="twoColFixLtHdr"&gt;

<div id="container">

  <div id="header">

    <h1>&lt;?php echo $title;?&gt;</h1>

  </div>

  <div id="sidebar1">

    &lt;?php $this->load->view('nav'); ?&gt;

  </div>  

  <div id="mainContent">

   &lt;?php $this->load->view($main);?&gt;

  </div>

    <br class="clearfloat" style="clear:both" />

  <div id="footer">

    <p>Copyright 2008 Your Company Inc</p>

  </div>

</div>

&lt;/body&gt;

&lt;/html&gt;

Many thanks for all your help again Smile