Help Create sub menu from database!

[eluser]LonelyWolf[/eluser]
Hi all, excuse my little english AND please don't hurt, i found codeigniter only yesterday evening.

This is what i'm doing and at this stage there's nothing to insert voices in the menù use phpmyadmin or any other client to your database.

I've created a quick library to accomplish this, still required a db table.
The table:

Code:

CREATE TABLE IF NOT EXISTS `navigation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'General index/key',
  `father` int(10) unsigned NOT NULL COMMENT 'Item\'s Father',
  `menuorder` smallint(5) unsigned NOT NULL COMMENT 'Item\'s display order',
  `item` varchar(20) NOT NULL COMMENT 'Item displayed',
  `destination` varchar(200) NOT NULL COMMENT 'Destination Link',
  PRIMARY KEY (`id`),
  KEY `codice_menu` (`padre`,`ordine`)
) ENGINE=InnoDB ;

The main menù supposed to be with father=0, sub menu items will have the relative item id as father.

In application/libraries/Navigationmenu.php

Code:

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

/**
* CodeIgniter navigationMenu Class
*
* This class enables the creation of menus
*
*/
class CI_Navigationmenu {

var $CI;
/**
  * Constructor
  */
public function __construct()
{
  $this->CI =& get_instance();
  log_message('debug', "Navigationmenu Class Initialized");
    $this->CI->load->helper('url');
}
/**
  * Generate the menu
  *
  * @access public
  * @param integer the menu to display
  * @return string
  */
function generate($padre)
{

    $out = '<ul class="menu">';
    $query = $this->CI->db->query("select * from navigation where padre = $padre order by ordine;");
    foreach($query->result_array() as $menu_item) {
      $out .= '<li class="menu"><a class ="menu" href="'.base_url().$menu_item['destinazione'].'">'.$menu_item['voce'].'</a></li>';
    }
    $out .= '</ul>';
  return $out;
}



}

// END CI_NavigationMenu class

/* End of file Navigationmenu.php */
/* Location: ./application/libraries/Navigationmenu.php */

This code uses some style to display horizontally list items, you can style as you like.

Load in your controller:

Code:

$this->load->library('navigationmenu');

Show in your pages:

Code:

echo $this->navigationmenu->generate(0);

Change generate parameter to display different submenu.

ToDo:
* Display fathers menu item when showing submenu
* Anything to manage menu items
* clear the code

Edit:
Corrected link generation url