Help Create sub menu from database!

[eluser]Egill Th[/eluser]
[quote author="uqmeebi" date="1344877271"][quote author="Egill Th" date="1344854984"]I'm not sure what you're asking for but to my understanding you are looking for something like this.

There may be some errors but it should work in theory.

controller

Code:

<?php
class Item extends CI_Controller {
  var $data;

  public function __construct() {
    $this->load->model('itemmodel');

  public function showMenu() {
    $this->data['items'] = $this->itemmodel->getItems();
    
    foreach ( $this->data['items'] as $item ) {
      $this->data['sub_items'][$item->id] = $this->itemmodel->getSubItems($item->id);
    }

    $this->load->view('itemview.php', $this->data);
}

view

Code:

<?php
foreach ( $items as $item ) {
  echo $item->name;

  foreach ( $sub_items[$item->id] as $sub_item ) {
    echo $sub_item->name;
  }
}

[/quote]

please create full MVC script for visualization.[/quote]

All that bit of code is lacking is the model and I have no idea how you intend to have your database set up.