Login

03-02-2009, 08:06 PM

[eluser]Slowcheetah[/eluser]
I'm new to OOP, MVC and CodeIgniter. I'm having problems to learn the MVC coding principles. A simple question;

Why this code IS working;

MODEL

Code:
&lt;?php

class Startpagina_Model extends Model {

    function Startpagina_Model()

    {

        // Call the Model constructor

        parent::Model();

    }

    function Overzicht_Competities()

    {

        $query = $this->db->query('SELECT id, name FROM game_competitions');

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

        {

            echo $row->name;

        }

    }

}

/* End of file startpagina_model.php */

/* Location: ./system/application/models/startpagina_model.php */

CONTROLLER

Code:
&lt;?php

class Startpagina extends Controller {

    function __construct() 

    {

        parent::Controller();

    }

    function index()

    {

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

        $data['query'] = $this->startpagina_model->Overzicht_Competities();

        $this->load->view('startpagina', $data);

    }

}

/* End of file startpagina.php */

/* Location: ./system/application/controllers/startpagina.php */

And this code IS NOT working?

MODEL

Code:
&lt;?php

class Startpagina_Model extends Model {

    function Startpagina_Model()

    {

        // Call the Model constructor

        parent::Model();

    }

    function Overzicht_Competities()

    {

        $query = $this->db->query('SELECT id, name FROM game_competitions');

    }

}

/* End of file startpagina_model.php */

/* Location: ./system/application/models/startpagina_model.php */

VIEW

Code:
&lt;html&gt;

&lt;head&gt;

&lt;title&gt;test&lt;/title&gt;

&lt;/head&gt;

&lt;body&gt;

&lt;?php 

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

{

    echo $row->name;

}

?&gt;

&lt;/body&gt;

&lt;/html&gt;

CONTROLLER

Code:
&lt;?php

class Startpagina extends Controller {

    function __construct() 

    {

        parent::Controller();

    }

    function index()

    {

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

        $data['query'] = $this->startpagina_model->Overzicht_Competities();

        $this->load->view('startpagina', $data);

    }

}

/* End of file startpagina.php */

/* Location: ./system/application/controllers/startpagina.php */