Yii Framework Wiki
Difference between
#8 and
#12 of
Creating a database-driven hierarchical Structure combined with CMenu and superfish
Changes
Title unchanged
Creating a database-driven hierarchical Structure combined with CMenu and superfish
Category unchanged
Tutorials
Yii version unchanged
Tags unchanged
menu
Content changed
Note: Please also take a look at the newer [EMenu extension](http://www.yiiframework.com/extension/emenu "Title"). This works even better that
the deprecated CDropDownMenu!
In this tutorial we will create a hierarchical Structure using the traditional adjacency list model. Yii's ActiveRecord paradigm makes it very easy to implement this structure via a join on itself. After this, we will use the new CMenu from yii 1.1 and implement it in conjunction with [superfish](http://users.tpg.com.au/j_birch/plugins/superfish/ "Title"), a jQuery plugin for creating menus.
The [CDropDownMenu extension](http://www.yiiframework.com/extension/cdropdownmenu "Title") will help us to accomplish this task.
{
return array(
'getparent' => array(self::BELONGS_TO, 'Hierarchy', 'parent'),
'childs' => array(self::HAS_MANY, 'Hierarchy', 'parent', 'order' => 'sort ASC'),
);
}
```
$model = Hierarchy::model()->findByPk(7);
$parent = $model->getparent;
echo $parent->title;
// returns 'First Entry'
}
$returnarray = array('label' => $this->headlintitle, 'url' => array('Hierarchy/view', 'id' => $this->id));
if($subitems != array())
$returnarray = array_merge($returnarray, array('items' => $subitems));
$this->widget('zii.widgetapplication.extensions.CDropDownMenu',array(
'items'=>$items,
));
```
to render the menu with the content of our database.
the deprecated CDropDownMenu!
In this tutorial we will create a hierarchical Structure using the traditional adjacency list model. Yii's ActiveRecord paradigm makes it very easy to implement this structure via a join on itself. After this, we will use the new CMenu from yii 1.1 and implement it in conjunction with [superfish](http://users.tpg.com.au/j_birch/plugins/superfish/ "Title"), a jQuery plugin for creating menus.
The [CDropDownMenu extension](http://www.yiiframework.com/extension/cdropdownmenu "Title") will help us to accomplish this task.
[...]
public function relations(){
}
```
[...]
```php$model = Hierarchy::model()->findByPk(7);
$parent = $model->getparent;
echo $parent->title;
// returns 'First Entry'
[...]
$subitems[] = $child->getListed();}
$returnarray = array('label' => $this->
if($subitems != array())
$returnarray = array_merge($returnarray, array('items' => $subitems));
[...]
$items[] = $model->getListed(); // note that the [] is important, otherwise CMenu will crash.$this->widget('
'items'=>$items,
));
```
to render the menu with the content of our database.
[...]
24 followers
Viewed: 64 121 times
Version: 1.1
Category: Tutorials
Written by: thyseus
Last updated by: thyseus
Created on: Jan 16, 2010
Last updated: 13 years ago
Revisions
View all history-
13 years ago by
thyseus note to emenu
-
13 years ago by
Alex D. correction
-
13 years ago by
Alex D. correction: $parent = $model->parent; wa...
-
13 years ago by
Maurizio Domba Cerin proper path for CDropDownMenu
-
14 years ago by
Nitish Bezzala Use Gii to generate model and CRUD inste...
-
14 years ago by
wei formatting, tags
-
14 years ago by
thyseus added hint to css inconsistency
-
14 years ago by
jonah removed breaks
-
14 years ago by
jonah fixed markup