Welcome Guest, Not a member yet? Register   Sign In
Help with planning a CI project
#6

[eluser]invision[/eluser]
So far, so-so Smile

I'm going to focus on Pages in this reply.

Controller:
Code:
<?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 pages($slug){
    $data['page_data'] = $this->MPages->getPageBySlug($slug);
    $data['title'] = $data['page']['title'];
    $data['main'] = 'public_page';
    $this->load->vars($data);
    $this->load->view('template');  
  }
  
}

Model:
Code:
<?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;    
    }

}

Now going to: http://www.site.com/index.php/page/ shows my Home Page perfectly.

However I have created a page 'Location' as a record in my 'pages' table.
I was hoping to visit this by going to http://www.site.com/index.php/page/about-us/location/ but sadly this doesn't work. I get a 404 Error.

Could someone guide me where I'm going wrong with the above code?
I'm new to this, so as much help as you can give is so much appreciated.


Many thanks.


Messages In This Thread
Help with planning a CI project - by El Forum - 02-26-2010, 11:58 AM
Help with planning a CI project - by El Forum - 02-26-2010, 12:55 PM
Help with planning a CI project - by El Forum - 02-26-2010, 01:21 PM
Help with planning a CI project - by El Forum - 02-26-2010, 01:49 PM
Help with planning a CI project - by El Forum - 02-26-2010, 01:52 PM
Help with planning a CI project - by El Forum - 02-27-2010, 12:22 PM
Help with planning a CI project - by El Forum - 02-28-2010, 02:10 AM
Help with planning a CI project - by El Forum - 02-28-2010, 02:12 AM
Help with planning a CI project - by El Forum - 02-28-2010, 02:14 AM
Help with planning a CI project - by El Forum - 02-28-2010, 02:18 AM
Help with planning a CI project - by El Forum - 02-28-2010, 02:30 AM
Help with planning a CI project - by El Forum - 02-28-2010, 02:32 AM
Help with planning a CI project - by El Forum - 02-28-2010, 02:35 AM
Help with planning a CI project - by El Forum - 02-28-2010, 02:35 AM
Help with planning a CI project - by El Forum - 02-28-2010, 02:37 AM
Help with planning a CI project - by El Forum - 02-28-2010, 02:40 AM
Help with planning a CI project - by El Forum - 02-28-2010, 02:43 AM
Help with planning a CI project - by El Forum - 02-28-2010, 02:44 AM
Help with planning a CI project - by El Forum - 02-28-2010, 02:46 AM
Help with planning a CI project - by El Forum - 02-28-2010, 02:48 AM
Help with planning a CI project - by El Forum - 02-28-2010, 02:54 AM
Help with planning a CI project - by El Forum - 02-28-2010, 02:56 AM
Help with planning a CI project - by El Forum - 02-28-2010, 02:56 AM
Help with planning a CI project - by El Forum - 02-28-2010, 02:59 AM
Help with planning a CI project - by El Forum - 02-28-2010, 03:03 AM
Help with planning a CI project - by El Forum - 02-28-2010, 03:04 AM
Help with planning a CI project - by El Forum - 02-28-2010, 03:07 AM
Help with planning a CI project - by El Forum - 02-28-2010, 03:08 AM
Help with planning a CI project - by El Forum - 02-28-2010, 03:09 AM
Help with planning a CI project - by El Forum - 02-28-2010, 03:12 AM
Help with planning a CI project - by El Forum - 02-28-2010, 03:15 AM
Help with planning a CI project - by El Forum - 02-28-2010, 03:16 AM
Help with planning a CI project - by El Forum - 02-28-2010, 03:17 AM
Help with planning a CI project - by El Forum - 02-28-2010, 03:19 AM
Help with planning a CI project - by El Forum - 02-28-2010, 03:22 AM
Help with planning a CI project - by El Forum - 02-28-2010, 03:27 AM
Help with planning a CI project - by El Forum - 02-28-2010, 03:27 AM
Help with planning a CI project - by El Forum - 02-28-2010, 03:30 AM
Help with planning a CI project - by El Forum - 02-28-2010, 03:35 AM
Help with planning a CI project - by El Forum - 02-28-2010, 03:41 AM
Help with planning a CI project - by El Forum - 02-28-2010, 03:44 AM
Help with planning a CI project - by El Forum - 02-28-2010, 03:49 AM
Help with planning a CI project - by El Forum - 03-02-2010, 05:45 AM
Help with planning a CI project - by El Forum - 05-17-2010, 06:52 AM
Help with planning a CI project - by El Forum - 05-17-2010, 07:56 AM
Help with planning a CI project - by El Forum - 05-17-2010, 07:59 AM
Help with planning a CI project - by El Forum - 05-17-2010, 08:10 AM
Help with planning a CI project - by El Forum - 05-17-2010, 08:24 AM
Help with planning a CI project - by El Forum - 05-17-2010, 08:26 AM
Help with planning a CI project - by El Forum - 05-17-2010, 08:30 AM
Help with planning a CI project - by El Forum - 05-17-2010, 08:32 AM
Help with planning a CI project - by El Forum - 05-17-2010, 08:47 AM
Help with planning a CI project - by El Forum - 05-17-2010, 08:48 AM



Theme © iAndrew 2016 - Forum software by © MyBB