有村子兄弟要的那种 下拉式 导航菜单，与 MySQL 结合使用的：

请诸位有能者改之，优化之，或者另给出一段好的代码。

如果，我的师傅 tmyu 兄 看到的话，就请你指导一下：

下面是 Menu.php 代码：
[PHP]

<?PHP
include("./includes/TEMPLATE.INC");
include("./includes/adodb/adodb.inc.php");
include("./includes/functions.php");
$db = NewADOConnection('mysql'); // A new connection
$db->Connect("localhost", "root", "password", "website");
$tpl = new template("./templates/");
$tpl -> set_file("main","Menu_body.html");
$tpl -> set_block("main","data_roll","dr"); //注意这里的 block书写顺序
$strSQL = "SELECT max(MenuMain) FROM Menu_config";
$result = query_now($strSQL);
$max_main = $result -> fields['0'];
$tpl -> set_var("Total_Menu",$max_main);
for($i=1; $i<= $max_main; $i++){
// the Max_main
$strSQL = "SELECT max(MenuChild) FROM Menu_config WHERE MenuMain=$i";
$resul = query_now($strSQL);
$max_child = $resul -> fields['0'];

// for the Level 1
$strSQL = "SELECT * FROM Menu_config WHERE MenuMain=$i";
$res = query_now($strSQL);
if(($res -> fields['MenuChild'] == NULL)&&($res -> fields['MenuGrand'] == NULL)){
$str = "Menu" . $res -> fields['MenuMain'];
$max_child = check_set_max($max_child);
set_tpl_vars($str, $res -> fields['MenuName'], $res -> fields['MenuHref'], $max_child);
}
for($j=1; $j<= $max_child; $j++){
//for the max_Grand
$strSQL = "SELECT max(MenuGrand) FROM Menu_config WHERE MenuMain=$i AND MenuChild=$j";
$r_max = query_now($strSQL);
$max_Grand = $r_max -> fields['0'];

$strSQL = "SELECT * FROM Menu_config WHERE MenuMain=$i AND MenuChild=$j";
$re = query_now($strSQL);
if(($re -> fields['MenuGrand']) == NULL){
$str = "Menu" . $re -> fields['MenuMain'] . '_' . $re -> fields['MenuChild'];
$max_Grand = check_set_max($max_Grand);
set_tpl_vars($str, check_set_name($re -> fields['MenuName'],$max_Grand), $re -> fields['MenuHref'], $max_Grand);
}
for($k=1; $k<= $max_Grand; $k++){
$strSQL = "SELECT * FROM Menu_config WHERE MenuMain=$i AND MenuChild=$j AND MenuGrand=$k";
$r = query_now($strSQL);
$str = "Menu" . $r -> fields['MenuMain'] . '_' . $r -> fields['MenuChild'] . '_' . $r -> fields['MenuGrand'];
set_tpl_vars($str, $r -> fields['MenuName'], $r -> fields['MenuHref'], 0);
}
}
}


$tpl->parse('Output', 'main');
// $tpl->p('Output');
// 以下是由修改 PHPlib template.inc 所得的函数,可以实现完全静态输出
$tpl->savetofile("Menu.html","Output");
//置空
$tpl->renew();//至关重要
?>

[/PHP]

下面是 ./includes/functions.php 的代码：
[PHP]

<?php
function query_now($str){
global $db;
$result = $db -> Execute($str);
// $db->SetFetchMode(ADODB_FETCH_ASSOC); // Return associative array
if($result === false) die("Error!Query Error!");
return $result;
}
function set_tpl_vars($str,$MenuName,$MenuHref,$maxCount="0"){
global $tpl;
$tpl -> set_var("stringMenu",$str);
$tpl -> set_var("MenuName",$MenuName);
$tpl -> set_var("MenuHref",$MenuHref);
$tpl -> set_var("MaxCount",$maxCount);
$tpl -> set_var("Break","\n");
$tpl -> parse("dr","data_roll",true);
}
function check_set_max($var){
if($var==''){
$var = "0";
}
return $var;
}
function check_set_name($var,$var2){

if($var2 <> 0){
$var = $var . "◆";
}
return $var;
}
?>

[/PHP]


下面是 ./templates/Menu_body.html 的代码：