Implementation of infinite level menu_PHP tutorial

/* I saw many friends asking questions about unlimited level menus (in fact, there are still levels in theory, after all, they are subject to convenient conditions, such as: database field types, etc.), I once used Boss ( The code provided by Nagging) has been used to write an unlimited level menu, but the effect is not very good (visually), so I took advantage of the "dead of night" to write this "unlimited level menu". In fact, the reason is very simple, mainly data The design of the table, as well as the use of recursive methods (if I have time, I will use the median sorting method), I will give the design of the data structure below (very simple), here I did not add a vertical dotted line ( The dotted line of Windows Explorer), and I also fixed the Sql statement. You can modify it according to your needs!If you have any questions, please contact me: msn:banneryue@sina.com, QQ: 7665656, E_mail: yuepengfei@mail.banner.com.cn

I will provide a test tomorrow (already today, haha) Let everyone take a look at the page (because I can only dial up the Internet in the dormitory, and the IP address is not fixed) ($SearchPattern,$BaseNum){
global $Tree;//Declare the handle to connect to the database as global
$Sql="select DepartmentId,DepartmentName from test where DepartmentId like '$SearchPattern'"; //Find children Node
$QueryChild=$Tree->query($Sql);            $Space=" ";
for($j=0;$j Show the node in front of Distance, the html of the spaces here is automatically replaced with " " ID like '$ChildDepartment'"; //Find the child node of the child node ($Result[0]) ; //Set the table Id
                                                                                                                                                                                                                                                                                                                                            ;" class="F1">=$Result[1]?>
                                                                                     ;?}else{                                                                                                                                                               ="javascript:expands('','=$TablePic?>')" style="cursor:hand">=$Result[1] ?>
;
                                                                                                                        lt;/table>
                                                                                                                                                                                                         ;

  require("do_mySql.php");
$Tree = new DB_Sql;
$Tree->connect();//杩