<?php

function getList($pid=0,&$res=array(),$spac=0){

$spac=$spac+4;

$link=mysqli_connect('localhost','root','root') or die('沒有鏈接到服務(wù)器');

? ? mysqli_select_db($link,'deepcate') or die("沒有鏈接到表");

$sql="select * from cate where pid={$pid}";

$rows=mysqli_query($link, $sql);

if($rows){

? ? ?while($row=mysqli_fetch_assoc($rows)){

? ? ? $row['catename']=str_repeat('&nbsp;',$spac).'|--'.$row['catename'];?

? ? ? $res[]=$row;

getList($row['id'],$res,$spac);

? ? }

return $res;

}

}

function showList($pid=0,$select){

$result=getList($pid);

echo "<select name='cate'>";

foreach ($result as $key => $value) {

$selecstr='';

if($value['id']==$select){

$selectstr='selected';

}

?echo "<option ?{$selectstr} >{$value['catename']}</option>";

}

}

function getCatePath($id,&$res=array(),$spac=0){

$spac=1;

$link=mysqli_connect('localhost','root','root') or die('沒有鏈接到服務(wù)器');

? ? mysqli_select_db($link,'deepcate') or die("沒有鏈接到表");

$sql="select * from cate where id={$id}";

$rows= mysqli_query($link, $sql);

if($rows){

while($row=mysqli_fetch_assoc($rows)){

$row['catename']=$row['catename'].str_repeat('>',$spac);

$res[]=$row;

getCatePath($row['pid'],$res,$spac);

}

krsort($res);

return $res;

}

}

function showCatePath($id){

$res=getCatePath($id);

foreach ($res as $key => $value) {

echo "<a href='cate.php?cid={$value['id']}'>{$value['catename']}</a>";

}

}

showCatePath(10);

?>

純自寫<--!>