menu | program #--------------------------------------------------------
# Structure of the datasheet ' menu '
# --------------------------------------------------------
CREATE TABLE Menu (
menu_id Int (one) not NULL auto_increment,
Menu varchar Not NULL,
Menu_grade Int (one) not NULL,
Menu_superior Int (one) not NULL,
UNIQUE menu_id (menu_id)
);
# -------------------------------------------------
#数据表内的内容, depending on the specific circumstances
# -------------------------------------------------
INSERT into Menu VALUES (' 1 ', ' computer ', ' 1 ', ' 0 ');
INSERT into Menu VALUES (' 2 ', ' Programming ', ' 2 ', ' 1 ');
INSERT into Menu VALUES (' 3 ', ' Network ', ' 2 ', ' 1 ');
INSERT into Menu VALUES (' 4 ', ' PHP and MySQL ', ' 3 ', ' 2 ');
INSERT into Menu VALUES (' 5 ', ' C language ', ' 3 ', ' 2 ');
INSERT into Menu VALUES (' 6 ', ' web Making ', ' 3 ', ' 3 ');
INSERT into Menu VALUES (' 7 ', ' TCP, IP protocol ', ' 3 ', ' 3 ');
INSERT into Menu VALUES (' 8 ', ' Math ', ' 1 ', ' 0 ');
INSERT into Menu VALUES (' 9 ', ' Higher Mathematics ', ' 2 ', ' 8 ');
INSERT into menu VALUES (' 10 ', ' linear Algebra ', ' 3 ', ' 9 ');
INSERT into menu VALUES (' 11 ', ' Discrete Math ', ' 3 ', ' 9 ');
INSERT into Menu VALUES (' 12 ', ' Elementary math ', ' 2 ', ' 8 ');
INSERT into menu VALUES (' 13 ', ' literature ', ' 1 ', ' 0 ');
INSERT into Menu VALUES (' 14 ', ' Chinese Literature ', ' 2 ', ' 13 ');
INSERT into Menu VALUES (', ' php ', ' 4 ', ' 4 ');
INSERT into Menu VALUES (', ' MySQL ', ' 4 ', ' 4 ');
?
Tree-type directory structure template program
Menu Directory Gallery Field Description:
MENU_ID menu item ID
Menu Name
Menu_grade Menu Level 1 Main Menu 2 is level two menu ...
Menu_superior Top level Menu ID number
function My_menu ($menu _content, $i, $menu _grade_temp, $menu _superior_temp)
{
Global $PHP _self;
$temp 1= $menu _grade_temp+1;
$menu _superior_temp_array=split ("/", $menu _superior_temp);
for ($t =0; $t < $i; $t + +)
{
$menu _array=split ("/", $menu _content[$t]);
If ($menu _array[2]== $menu _grade_temp) && ($menu _array[3]== $menu _superior_temp_array[$menu _grade_temp-1]) )
{
For ($p =1 $p <= $menu _grade_temp $p + +) {echo >;}//Show level arrows before directory
$temp 3= $menu _superior_temp_array;
$temp 3[$menu _grade_temp]= $menu _array[0];
$temp 2=implode ("/", $temp 3);
if ($menu _array[0]== $menu _superior_temp_array[$temp 1-1])
{
$temp 5= $temp 1-1;
$temp 3[$menu _grade_temp]= "";
$temp 6=implode ("/", $temp 3);
echo "<a href=\" $PHP _self?menu_grade_temp= ". $temp 5." &menu_superior_temp=
$temp 6\ "> $menu _array[1]</a><br>";
My_menu ($menu _content, $i, $temp 1, $temp 2);
}
Else
{
$temp 3[$menu _grade_temp+1]= "";
$temp 6=implode ("/", $temp 3);
echo "<a href=\" $PHP _self?menu_grade_temp= ". $temp 1." &menu_superior_temp=
$temp 6\ "> $menu _array[1]</a><br>";
}
}
}
}
Connecting to the MYSQL database
$db _host= "localhost";
$db _user= "root";
$db _password= "ZMXJ";
$db _name= "Joss";
Mysql_connect ($db _host, $db _user, $db _password);
mysql_select_db ($db _name);
Get data from the database
$query _string= "SELECT * from Menu order by Menu_grade";
$db _data=mysql_query ($query _string);
The first time the initialization is performed
if ($menu _grade_temp== "")
{
$menu _superior_temp=0;
}
Read all the information into the array and count the number of arrays
$i = 0;
while (list ($menu _id, $menu, $menu _grade, $menu _superior) =mysql_fetch_row ($db _data))
{
$menu _content[$i]= $menu _id. " /". $menu." /". $menu _grade." /". $menu _superior;
$i + +;
}
My_menu ($menu _content, $i, 1, $menu _superior_temp);
?>
