Login

08-13-2011, 12:51 PM

[eluser]Lorin[/eluser]
For example I made simple script to create menu from database:

model:

Code:
&lt;?php

    class Test_model extends CI_Model {

        function __construct() {

            parent::__construct();

        }

        function display_menu() {

            $this->load->database();

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

            return $query->result();

        }

    }

?&gt;

controller:

Code:
&lt;?php

    class Test extends CI_Controller {

        function __construct(){

            parent::__construct();

        }

        public function index() {

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

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

            $data['menu'] = $this->menu->display_menu();

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

        }

    }

?&gt;

and view:

Code:
&lt;html&gt;

    &lt;head&gt;

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

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

    &lt;/head&gt;

    &lt;body&gt;

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

        <ul>

            &lt;?php foreach($menu as $menus) { ?&gt;

                <li> &lt;?php echo $menus->nick; ?&gt; </li>

            &lt;?php } ?&gt;

        </ul>

    &lt;/body&gt;

&lt;/html&gt;

I know, it is really simple.

Note: It's using my 'user' table, because I'm too lazy to create another table for testing.