無限級分類 · 萬能Web開發文檔筆記

# 無限級分類數據表字段 id pid title ``` <pre class="calibre16">``` /** * 獲得分類樹 * @param int $pid 父id * @param array $result返回樹結構 * @param int $spac * @return array */ require_once "pdo.php"; function gettree($pid=0,&$result=array(),$spac=0){ $spac = $spac+2; $row = pdo_getall('item',array('pid'=>$pid)); foreach($row as $v){ if($v['pid']==0){ $v['title'] = $v['title']; } else{ $v['title'] = str_repeat('  ',$spac)."|--".$v['title']; } $result[] = $v; gettree($v['id'],$result,$spac); } return $result; } /* * 父類id 選中的id * */ function puttree($pid=0,$selected=0){ $rs = gettree($pid); $str=''; $str .= "<select name='pid'>"; $str .= '<option value="0">頂級分類</option>'; foreach($rs as $key=>$val){ if($val['id'] == $selected){ $selectedstr = "selected"; }else{ $selectedstr = ""; } $str .= "<option $selectedstr value='".$val['id']."'>".$val['title']."</option>"; } $str .= "</select>"; return $str; } //面包屑路徑 ,$cid為分類id ,直到返回頂級 function getmenu($cid,&$result=array()){ //引用數據庫連接資源 $row = pdo_get('item',array('id'=>$cid)); if($row){ $result[] = $row; getmenu($row['pid'],$result); } //數組順序倒序 krsort($result); return $result; } //輸出從當前分類到頂級分類路徑 function putmenu($cid,$url="demo.php?cid="){ $res = getmenu($cid); $str = ""; foreach($res as $key=>$val){ $str .= "<a href='{$url}{$val['id']}'>{$val['title']}</a>>"; } return $str; } //查詢下級下下級 function get_cid($cid,&$result=array()){ $row = pdo_getall('item',array('pid'=>$cid)); if($row){ foreach($row as $v){ $result[] = $v; get_cid($v['id'],$result); } } return $result; } ?> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>演示無限級分類</title> <style> .table { width: 100%; background: #f8f9fa; margin: 10px auto; border-collapse: collapse; } .table th, .table td { border: 1px solid #f0f1f4; padding: 8px; } .table th { background: #f8f9fa; font-weight: bold; } .table tr { background: #FFF; } .table tr:hover { background: #f8f9fa; } .table td a { color: #18B4ED; text-decoration: none; } .table td a:hover { color: #18B4ED; text-decoration: underline; } </style> </head> <body> <?php //默認設置頂級分類開始,1選中 echo puttree(0,1) ; echo putmenu(8) ;?> <table class="table"> <tr><th>ID</th><th>上級ID</th><th>分類名稱</th></tr> <tbody> <?php foreach(gettree() as $k=>$v){ echo "<tr ><td>".$v['id']."</td><td>".$v['pid']."</td><td align='left'>".$v['title']."</td></tr>"; } ?> </tbody> </table> </body> </html> ``` ```