Welcome Guest, Not a member yet? Register   Sign In
Confusion with MVC in CI
#16

[eluser]ChaosKnight[/eluser]
Changed my code to this...
Model:
Code:
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Countries_model extends Model
{
    function Countries_model()
    {
        parent::Model();
        $this->load->database();
    }
    function getCountries()
    {
        $this->db->select('id, country');
        $query = $this->db->get('countries');
        return $query;
    }
}
/* End */

Controller:
Code:
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Countries extends Controller
{
    function Countries()
    {
        parent::Controller();
        $this->load->helper(array('html','url'));
        $this->load->model('countries_model');
    }
    function index()
    {
        $data['page_title'] = 'Countries';
        $query = $this->countries_model->getCountries();
        foreach ($query->result() as $row)
        {
            $data['countries'][] = $row->country;
            $data['ids'][] = $row->id;
        }

        $this->load->view('header',$data);
        $this->load->view('nav');
        $this->load->view('sidebar');
        $this->load->view('countries',$data);
        $this->load->view('footer');
    }
}
/* End */

Don't know how efficient it is, there may be better suggestions, but it got the page working for me :-)

The view is basic:
Code:
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); ?>

<div id="content">
  &lt;?php
    $i = -1;
    foreach ($countries as $country)
    {
      $i++;
      echo anchor('countries/'.$ids[$i],$country);
      echo "<br />";
    }
  ?&gt;
</div>

&lt;?php
/* End of Countries.php view */


Messages In This Thread
Confusion with MVC in CI - by El Forum - 06-16-2010, 07:05 AM
Confusion with MVC in CI - by El Forum - 06-16-2010, 07:26 AM
Confusion with MVC in CI - by El Forum - 06-16-2010, 07:40 AM
Confusion with MVC in CI - by El Forum - 06-16-2010, 07:45 AM
Confusion with MVC in CI - by El Forum - 06-16-2010, 07:57 AM
Confusion with MVC in CI - by El Forum - 06-16-2010, 07:59 AM
Confusion with MVC in CI - by El Forum - 06-16-2010, 08:09 AM
Confusion with MVC in CI - by El Forum - 06-16-2010, 08:48 AM
Confusion with MVC in CI - by El Forum - 06-16-2010, 09:01 AM
Confusion with MVC in CI - by El Forum - 06-16-2010, 09:18 AM
Confusion with MVC in CI - by El Forum - 06-16-2010, 09:23 AM
Confusion with MVC in CI - by El Forum - 06-16-2010, 09:28 AM
Confusion with MVC in CI - by El Forum - 06-16-2010, 12:07 PM
Confusion with MVC in CI - by El Forum - 06-16-2010, 01:15 PM
Confusion with MVC in CI - by El Forum - 06-16-2010, 01:35 PM
Confusion with MVC in CI - by El Forum - 06-16-2010, 02:28 PM



Theme © iAndrew 2016 - Forum software by © MyBB