Tad 教材網 - 線上書籍

:::

\[991\]PHP網站開發 進階應用技巧2
======================

<?php  
 $root\_pass=""; //資料庫root密碼  
 $db\_name="test"; //資料庫名稱  
   
 /\* 連資料庫檢查 \*/  
 $link=mysql\_connect("localhost","root",$root\_pass); //資料庫連線  
 mysql\_select\_db("test");  
 mysql\_query("SET NAMES 'utf8'"); //設定語系  
 error\_reporting(0);  
   
 <span style="color: rgb(51, 102, 255);">$sql="select \* from menu order by ofsn , sn";  
 $result=mysql\_query($sql);  
 $menu="";  
 while(list($sn,$ofsn,$title,$url)=mysql\_fetch\_row($result)){  
 $menu.="a.add($sn, $ofsn,'$title','$url','$title','show');\\n";  
 }</span>  
   
 ?>  
 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">  
 <html>  
 <head>  
 <meta http-equiv="content-type" content="text/html; charset=UTF-8">  
 <link rel='stylesheet' type='text/css' media='screen' href='style.css' />  
 <title>樹狀選單</title>  
 </head>  
 <body>  
   
 <span style="color: rgb(255, 0, 0);"> <script type="text/javascript" src="jquery-1.3.2.min.js"></script>  
   
 <script type='text/javascript'>  
 $(document).ready(function() {  
 var ww=$(window).width();  
 var hh=$(window).height();  
 w2w = ww-220;  
 $('#tbl').width(ww);  
 $('#tbl').height(hh);  
 $('#w1').width(200);  
 $('#w2').width(w2w);  
 $('#w2').height(hh);  
 });  
 </script></span>  
   
 <span style="color: rgb(128, 0, 0);"><table id="tbl">  
 <tr><td valign='top' id="w1"></span>  
 <link rel="StyleSheet" href="dtree.css" type="text/css" />  
 <script type="text/javascript" src="dtree.js"></script>  
 <script type="text/javascript">  
 a = new dTree('a');  
 <span style="color: rgb(0, 128, 128);"> a.config.target = "show";  
 a.config.folderLinks = true ;  
 a.config.useSelection = true;  
 a.config.useCookies = true;  
 a.config.useLines = false;  
 a.config.useIcons = false;  
 a.config.useStatusText = true ;  
 a.config.closeSameLevel = true;  
 a.config.inOrder = true ;</span>  
 a.add(0,-1,'目錄','javascript: void(0);');  
 <span style="color: rgb(51, 102, 255);"><?php echo $menu;?></span>  
 document.write(a);  
 </script> <span style="background-color: rgb(255, 255, 153);">  
 <a href="javascript: a.openAll();">全部開啟</a><br>  
 <a href="javascript: a.closeAll();">全部關閉</a><br>  
 <a href="javascript: a.openTo(12, true);">開啟編號12</a> </span>  
 <span style="color: rgb(128, 0, 0);"></td><td valign='top'>  
 <span style="color: rgb(51, 102, 255);"> <iframe name="show" id="w2"></iframe></span>  
 </td></tr>  
 </table></span>  
   
   
   
 </body>  
 </html>

:::