dedecms 导航栏目表

<?php
// 连接数据库
$conn = new mysqli("localhost", "username", "password", "dedecms");

// 检查连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 查询导航栏目表
$sql = "SELECT id, name, url, pid FROM dede_arctype ORDER BY sortrank ASC";
$result = $conn->query($sql);

// 生成导航菜单
$navMenu = '';
while($row = $result->fetch_assoc()) {
    if ($row['pid'] == 0) { // 顶级导航栏目
        $navMenu .= '<li><a href="' . $row['url'] . '">' . $row['name'] . '</a>';
        // 查询子导航栏目
        $childSql = "SELECT id, name, url FROM dede_arctype WHERE pid = " . $row['id'] . " ORDER BY sortrank ASC";
        $childResult = $conn->query($childSql);
        if ($childResult->num_rows > 0) {
            $navMenu .= '<ul>';
            while($childRow = $childResult->fetch_assoc()) {
                $navMenu .= '<li><a href="' . $childRow['url'] . '">' . $childRow['name'] . '</a></li>';
            }
            $navMenu .= '</ul>';
        }
        $navMenu .= '</li>';
    }
}

// 输出导航菜单
echo '<nav>' . $navMenu . '</nav>';

// 关闭连接
$conn->close();
?>