Creating a database-driven hierarchical Structure combined with CMenu and superfish

PHP code is broken... =/

good coockbook :)

can you show us an example of the result?

and please fix php code :)

I've been struggling with this a bit, and I found some things not so clear (like how and where superfish should be installed. It seemed like it would be picked automagically from some location).

I also found some errors like "$_GET'hierarchyParent'" which should be "$_GET'hierarchyParent'" which I could fix myself, but in the end I couldn't make it work (now I have it working).

I was very surprised that a simple comment like "//<-- optional" in the layout/main.php could do the magic to replace the static menu by the superfish one.

Now I've found the revision control source for the article. There the code seems to be complete and without errors. For example instead of the "// <-- optional" there are 3 or for lines with includes for the html source. With that code I could finally make the example work and figure that I can install superfish wherever I want as long as I point the aforementioned includes to the right place.

So the article is ok, but the rendering has quite a lot of artifacts.

There is still a little bug in the parent id in the sample database entries, where the parent id's of some menu items are "off by one" and also I don't think that the "root" entry should be showed, but otherwise it is working nice.

My previous comment suffers from the same artifacts as the article. It seems you cannot write the square bracket (" [ ") directly. You have to write " \[ ".

markup fixed. To embed php code, use

~~~
[php]
//Code here
~~~

Hi, i wrote this tutorial and it was my fault, since i did not know how to mark up correctly.

Much thanks for jonas to repair my small cookbook entry :)

You can install superfish anywhere you want, for example you can make a project/js/superfish/ directory and extract superfish there.

Now i know how to do correct markup, so i will add a few sentences and an example on how to install superfish today.

I've just decided to build a CDropDownMenu Widget, that automates the integration of superfish.

I think it will be available this week. The Tutorial will then be updated.

thank you...

I've been trying to get this to work by first call findAll() from my controller.

the line $items[] = $model->getListed(); doesn't work. I get an error saying that I'm calling a method on a non-object. The example here shows getting only one item so perhaps I am using this on an array of objects.

Would someone know how to sort the entire list in the correct order or display it properly. I'm not really trying to get this to work with CMenu but I have a similar structure. My table structure is similar in that I have an id field and a parent field (although these are not integers in my case) and I want to retrieve the entire list and essentailly display a tree structure. A simple example:

Cars -- chevy -- ford ---- mustang ---- ranger -- toyota Food -- fruit ---- apples ---- oranges ------- sunny ------- green -- pasta -- veges

should display

Cars
-- chevy
-- ford
---- mustang
---- ranger
-- toyota
Food
-- fruit
---- apples
---- oranges
------- sunny
------- green
-- pasta
-- veges

$returnarray = array('label' => $this->headline, 'url' => array('Hierarchy/view', 'id' => $this->id));

$this->headline should be this->title;

change it and look.

Hi,

This example works very well, but i want to use the tree view instead of the dropdownmenu, so i tried something like this:

public function actionAjaxFillTree() { if (!Yii::app()->request->isAjaxRequest) { exit(); } $parentId = 1;

    if (isset($_GET['root'])) {
        $parentId = (int) $_GET['root'];
    }

    $model = hierarchy::model()->findByPk($parentId);
$items[] = $model->getListed(); 

    echo CTreeView::saveDataAsJson($items);
}

In the view i put this code:

but the view show nothing with no error message.

Do you have an idea how can i fix this problem ?

Thanks in advance

The error message wasn't listed on the page view but has hidden in the javascript cause its was an Ajax request: You are not authorized to perform this action.

Why i have this error message ?

Thanks

Using loop to display all items:

$Hierarchy=Hierarchy::model()->findAll(array('condition'=>'parent = 0'));
        foreach ($Hierarchy as $Hierarchy){
            $models = Cat::model()->findBypk($Hierarchy->id);
            $items[] = $models->getListed();        
        }       
        if($items[0]['items'] != "0"){
            $items = array_merge(array('items'=>array('label'=>'Trang chủ', 'url'=>array('/site/index'))),
                                $items,array(array('label'=>'Liên hệ', 'url'=>array('/site/contact'))));    
 
        $this->widget('zii.widgets.CMenu',array(        
            'items'=>$items,    
        ));