Php and MySQL-based dynamic tree menu _ PHP Tutorial

Implement a dynamic tree menu based on php and MySQL. Tree menus are widely used in many desktop application systems. The main advantage of tree menus is that the structure is clear, which helps users know their location clearly. However, tree menus on the web are widely used in many desktop application systems. The main advantage of tree menus is that the structure is clear, so that users can clearly know where they are currently. However, tree menu applications on the web can be directly used because there is no ideal ready-made component. In general, programmers mainly implement simple tree-structure menus through javascript, however, these menus are usually pre-defined for each menu item and the hierarchical relationship between menu items, which is not conducive to expansion. once another menu structure is required, it is often necessary to re-compile the menu, therefore, it is not very convenient to use.

After studying the recursion of functions, I found that this kind of tree menu can be implemented through recursive functions, so that the display of tree menus can be dynamically changed without the limit of series. The following is the processing code of a dynamic tree menu written in php, mysql, and javascript. if you are interested, let's take a look at how I implement it with me :)

First, we need a database. in this database, we create the following table:


Create table menu (
Id tinyint (4) not null auto_increment,
Parent_id tinyint (4) default '0' not null,
Name varchar (20 ),
Url varchar (60 ),
Primary key (id)
);

This table
Id is index
Parent_id is used to save the ID number of the top-level menu. if it is a top-level menu, it is 0.
Name is the name of the menu, that is, the menu content to be displayed on the page.
Url if a menu is the last menu, you need to specify the url address of the connection. This field is used to save this address. Other non-last menu, this field is blank

Now that the database is ready, you can add some records. Below are some records used during the test:
Insert into menu values ('1', '0', 'personnel management ','');
Insert into menu values ('2', '0', 'Communication communication ','');
Insert into menu values ('3', '1', 'File management ','');
Insert into menu values ('4', '1', 'attendance management', 'http: // localhost/personal/attendance. php ');
Insert into menu values ('5', '2', 'address ','');
Insert into menu values ('6', '2', 'network conferencing ','');
Insert into menu values ('7', '3', 'Add files', 'http: // localhost/personal/add_achive.php ');
Insert into menu values ('8', '3', 'queryfile', 'http: // localhost/personal/search_archive.php ');
Insert into menu values ('9', '3', 'delete files', 'http: // localhost/personal/delete_archive.php ');
Insert into menu values ('10', '5', 'Add communication record ', 'http: // localhost/communication/add_address.php ');
Insert into menu values ('11', '5', 'query communication record ', http: // localhost/communication/search_address.php ');
Insert into menu values ('12', '5', 'delete communication record ', http: // localhost/communication/delete_address.php ');
Insert into menu values ('13', '6', 'convene a Meeting ', 'http: // localhost/communication/convence_meeting.php ');
Insert into menu values ('14', '6', 'conference query', 'http: // localhost/communication/search_meeting.php ');

When adding a record, you must note that the parent_id of a non-level menu must be specified as the ID of the parent menu; otherwise, your menu will not be displayed :)

Okay! With the database, the menu is read from the database through php and javascript and displayed :)

1. javascript script: function showmenu (menuid)
{
If (menuid. style. display = "none ")
{
Menuid. style. display = "";
}
Else
{
Menuid. style. display = "none ";
}
}
This script is very simple. it is used to respond to the event of clicking a menu.

2. css file:
Td {
Font-family: "verdana", ""; font-size: 12px; line-height: 130%; letter-spacing: 1px
}


A: link {
Color: #990000; font-family: "verdana", ""; font-size: 12px; text-decoration: none; letter-spacing: 1px
}
A: visited {
Color: #990000; font-family: "verdana", ""; font-size: 12px; text-decoration: none; letter-spacing: 1px
}
A: active {
Color: #990000; font-family: "verdana", ""; font-size: 12px; text-decoration: none; letter-spacing: 1px
}
A: hover {
Color: # ff0000; font-family: "verdana", ""; font-size: 12px; text-decoration: underline; letter-spacing: 1px
}


. Menu {
Color: #000000; font-family: "verdana", ""; font-size: 12px; cursor: hand
}

Some basic style information is defined, such as the font, color, and super-connected style. if you want to change the style, you just need to modify it here!

3. The following is my php page!