{"id":2457,"date":"2018-09-10T15:39:11","date_gmt":"2018-09-10T10:09:11","guid":{"rendered":"https:\/\/pheonixsolutions.com\/blog\/?p=2457"},"modified":"2018-10-05T16:00:05","modified_gmt":"2018-10-05T10:30:05","slug":"create-dynamic-menu-from-database-using-codeigniter","status":"publish","type":"post","link":"https:\/\/pheonixsolutions.com\/blog\/create-dynamic-menu-from-database-using-codeigniter\/","title":{"rendered":"Create dynamic menu from database using codeigniter"},"content":{"rendered":"

Date Posted: 10-09-2018<\/strong><\/p>\n

In this Post we will explain create dynamic menu from database using codeigniter.<\/p>\n

We assuming that you are familiar with CodeIgniter\u2019s MVC structure, so We did not going to explain what model and controller in CI are.<\/p>\n

Step 1: Please execute the following command and create the table.<\/p>\n

CREATE TABLE `categories` (\r\n  `cat_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n  `cat_name` varchar(50) COLLATE latin1_general_ci NOT NULL,\r\n  `parent_id` int(10) unsigned NOT NULL DEFAULT '0',\r\n  PRIMARY KEY (`cat_id`)\r\n) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;<\/pre>\n
Step 2: Create the new controller file and paste the following code.<\/p>\n
<?php\r\ndefined('BASEPATH') OR exit('No direct script access allowed');\r\n\r\nclass Dashboard extends MY_Controller {\r\n  public function __construct()\r\n  {\r\n    parent::__construct();\r\n    $this->load->model('Dashboard_model');\r\n  }\r\n\r\n  public function index()\r\n  {\r\n    $data['title'] = \"Dashboard\";\r\n    $data['page_name'] = \"Dashboard\";\r\n    $this->include_view('dashboard', $data);\r\n  }\r\n   public function categories(){\r\n\r\n        $this->load->model('Dashboard_model');\r\n      $data = $this->Dashboard_model->get_categories();\r\n\r\n      print_r($data);\r\n        }\r\n\r\n}<\/pre>\n
Step 2: Create the new model file and paste the following code.<\/p>\n
<?php\r\n\r\ndefined('BASEPATH') OR exit('No direct script access allowed');\r\n\r\nclass Dashboard_model extends CI_Model {\r\n  \r\n  \r\n    public function get_categories(){\r\n\r\n        $this->db->select('*');\r\n        $this->db->from('categories');\r\n        $this->db->where('parent_id', 0);\r\n\r\n        $parent = $this->db->get();\r\n        \r\n        $categories = $parent->result();\r\n        $i=0;\r\n        foreach($categories as $p_cat){\r\n\r\n            $categories[$i]->sub = $this->sub_categories($p_cat->cat_id);\r\n            $i++;\r\n        }\r\n        return $categories;\r\n    }\r\n\r\n    public function sub_categories($id){\r\n\r\n        $this->db->select('*');\r\n        $this->db->from('categories');\r\n        $this->db->where('parent_id', $id);\r\n\r\n        $child = $this->db->get();\r\n        $categories = $child->result();\r\n        $i=0;\r\n        foreach($categories as $p_cat){\r\n\r\n            $categories[$i]->sub = $this->sub_categories($p_cat->cat_id);\r\n            $i++;\r\n        }\r\n        return $categories;       \r\n    }\r\n\r\n}\r\n\r\n<\/pre>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
Date Posted: 10-09-2018 In this Post we will explain create dynamic menu from database using codeigniter. We assuming that you […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[1022],"tags":[],"class_list":["post-2457","post","type-post","status-publish","format-standard","hentry","category-web-architecture","psol-cat-web-architecture"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/phn2x7-DD","jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/2457","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=2457"}],"version-history":[{"count":0,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/2457\/revisions"}],"wp:attachment":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=2457"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=2457"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=2457"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}