<?php// 連接數據庫$conn = mysql_connect("localhost","root", "root");if (! $conn) {? ? echo "數據庫鏈接失敗";? ? //exit();}// 選擇所要操作的數據庫mysql_select_db("test",$conn);// 設置數據庫編碼格式mysql_query("SET NAMES UTF8");function getList($pid=0,$result=array(),$spac=0){? ? $spac=$spac+2;? ? //查詢表中某一個固定數據? ? $sql="SELECT * FROM deepcate WHERE pid =$pid ";? ? $res=mysql_query($sql);? ? //$result=array();? ? while ($row = mysql_fetch_assoc($res)){? ? ? ? $row['catename']=str_repeat('&nbsp', $spac).'|--'.$row['catename'];? ? ? ? $result[]=$row;? ? ? ? getList($row['id'],$result,$spac);? ? }? ? return $result;}function displayCate($pid=0,$selected=1){? ? $rs=getList($pid); ? ?$str="";? ? $str.="<select name = 'cate'>";foreach($rs as $key=>$val){? ? $selectedstr="";? ? if($val['id']==$selected){? ? ? ? $selectedstr="selected";? ? }? ??? ? $str.="<option {$selectedstr}>{$val['catename']}</option>";}? ?return $str.='</select>';}echo displayCate(0,2);