CodeIgniter Forums

Full Version: Dynamic Menu
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

[eluser]anyamanggar[/eluser]
Hello,

i want ask about dynamic menu use database,

could some body help me for the tutorial pleassseeee ..

El Forum

[eluser]obiron2[/eluser]
I think you need to be a bit more specific about what you are trying to achieve.
MVC patterns are designed so that each piece of the puzzle is independent of the next.

Put your menu data into a model. I don't know what you will need but as a minimum:
Menu title,
Page link (a hrefSmile
Whether this is the currently selected menu option.

Prep these as either a multi-dimensional array or an object collection.

$menu = array( array ('Title'=>'Home' 'Link'=>'Welcome'),array('Title'=>'About Us' 'Link'=>'Welcome/aboutus'))

return the array from the menu method.

Now in your controller load the menu_model and call the menu method then serve the array up the view as part of the $data collection. You can parse the menu array (or object collection) in the view.

When this is all working, You can then make the menu_model get the data from a database rather than being static. Your database table would need to have the following.

MenuID, SortOrder, Title, Ref

Your model would call a query "SELECT Title, Ref from MenuTable WHERE MenuID = $menuID Order by SortOrder"
and return the query->result_array() to the controller.