Sothink-Flash Movie Maker, SWF Decompiler, DHTML Menu, SWF Quicker, SWF to FLA converter, SWF Editor, HTML Editor
   Home | Sothink Products
PHP Samples
PHP sample of dynamic tree menu created from database

Part 1: Sample Instruction

To create a dynamic tree menu from database, you can input some condition clauses using either CGI (ASP, PHP, and etc.) or JavaScript language, that is, to input the Prefix or Suffix for a node in the Node Settings > Condition dialog.

You can view the following tree menu on the web server that supports PHP.

As you see, in this sample, the tree menu contains two levels: the parent level shows the product categories and the sub level shows the specific products. Actually, there are only two nodes, one in the parent level and the other is in the sub level.


The final result that you are seeing is just got from database.

Below is the diagram of the database.


Part 2: Steps

The following are the steps of this example:

(Before creating the tree menu, you should make a database containing the information of the product categories and the specific products.)

  1. Create a tree menu from Blank. Choose "Node Settings" and click "General". Input <?=$sCatName?> in the text box.

  2. Click "Condition" in "Node Settings".  And input the prefix and suffix for the node.



    Note: when you add the condition, you may get a warning message in Tree Menu. That's because the condition code is server-side code which can not be processed by the browser directly. The warning will not show when you add the tree menu to an PHP page that is supported by server. You can uncheck "Preview > Enable Auto-Refresh" to avoid seeing the warnings.
    Tips: To prevent this error popping up, you can add the JavaScript comment delimiters /* and */ to the Prefix as well as Suffix. In that way the preview ignores the extra code and the code works well on the server side processing.

    For example:
    Prefix:
    /*
    <?php
    while($r_category=mysql_fetch_array($category))
    {
    $sCatName = $r_category["NAME"];
    ?>
    */

    Suffix:
    /*
    <?php
    }
    ?>
    */

  3. Click "Append Sub Node " button to add a sub node of it, and then input <?=$sProduct?> in text box. In the link field, input <?=$sLink?>.

  4. Click "Condition" in "Node Settings" and input the prefix and suffix for the node.

    Note: Normally in order to optimize the menu code, if several nodes have the same property, only one node's property code is recorded and other nodes take reference of its property code. If we add a condition to this node, there is possibility that it will be invisible when its condition is not met. And its property code can not be referenced by other nodes either. This will cause the whole tree menu can not work correctly. Please do check "This node may be invisible at run-time" to avoid the problem.

Part 3: Code Explanation

This is the source code at the beginning of this sample page.

Code

Explanation

<?php   
$connect=mysql_connect("localhost","CKing","batian") or
die("Could not connect: " . mysql_error());
mysql_select_db("dhtmlmenu",$connect) or
die ('Can\'t use dhtmlmenu : ' . mysql_error());
Connect with the database.
$category=mysql_query("SELECT * FROM category");
?>
Retrieve recordset from the category table.

After you add node condition and edit the node, Tree Menu inserts following code into the page. The entire source code below is generated by Tree Menu program. Your editing of conditions will be saved in the menu's configuration file (*.stm), which can be edited again.
To learn further what the code represents,  please read the following code explanation:

Code
Explanation
stBM(1,"tree77cb".....) Begin the whole tree menu.
stBS("p0",[0]); Begin a sub node (nodes of category).
<?php
while($r_category=mysql_fetch_array($category))
{
$sCatName = $r_category["NAME"];
?>
Walk through the category recordset and save each category's name as variable "sCatName".
stIT("p0i0",["<?=$sCatName?>","",.....) <?=$sCatName?> is the category name.
stBS("p1",[],"p0") Begin a sub node (nodes of product).

<?php
$products= mysql_query("SELECT * FROM products WHERE CATID=".$r_category["ID"]);
while($r_products=mysql_fetch_array($products))
{
$sProduct = $r_products["NAME"];
$sLink = $r_products["LINK"];
?>
stIT("p1i0",["<?=$sProduct?>","<?=$sLink?>"...
<?php
}
?>

Retrieve recordset from the product table. Walk through the product recordset and save product name and link as temporary variables.
stIT("p1i0", [,"<?=$sProduct?>" .....) Append a node.<?=$sProduct?>is the node text.
stES(); End of a sub node.
stES(); End of a sub node.
stEM(); End of the whole tree menu.
      SourceTec Software Co., LTD. All rights reserved. Email:webmaster@sothink.com
      Sothink Tree Menu -- JavaScript Tree Menu Tree Navigation Menu Tree DHTML Menu Tree