.menu{color:red;}
.menu a {color:red;}
header("Content-type: text/html; charset=utf-8");
//header("Content-Type: text/plain;charset=utf-8");
$servername ="localhost";
$username ="root";
$password ="123";
$dbname="demodb";
//创建连接
$conn = new mysqli($servername,$username,$password,$dbname);
if($conn->connect_error){
die("连接失败:" . $conn->connect_error);
}else{
echo "连接成功";
}
$conn->query("set names utf8");
$sql = "SELECT * FROM deepcate";
$res = $conn->query($sql);
while($row = $res->fetch_assoc()){
$result[]=$row;
}
tree($result);
function tree(&$list,$pid=0){
if($pid) {echo "
- ";}
else {echo "
foreach($list as $v){
if($v["pid"]==$pid){
echo "
{$v['catename']}";tree($list,$v["id"]);
echo "
";}
}
echo "
";}
//首先把所有的数据取出来,从第一级开始,初始化pid=0,foreach循环,如果符合条件执行里面的语句并递归循环。
$conn->close();
?>