dedecms联动菜单作为条件查询

// 示例代码：动态加载联动菜单下级选项
<?php
// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database");

// 检查连接
if (!$conn) {
    die("连接失败: " . mysqli_connect_error());
}

// 获取上级菜单ID
$parent_id = $_GET['parent_id'];

// 查询下级菜单选项
$sql = "SELECT id, name FROM menu WHERE parent_id = $parent_id";
$result = mysqli_query($conn, $sql);

// 输出下级菜单选项
if (mysqli_num_rows($result) > 0) {
    while($row = mysqli_fetch_assoc($result)) {
        echo "<option value='".$row['id']."'>".$row['name']."</option>";
    }
} else {
    echo "<option value=''>请选择</option>";
}

mysqli_close($conn);
?>

// 示例代码：调试PHP代码
<?php
// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database");

// 检查连接
if (!$conn) {
    die("连接失败: " . mysqli_connect_error());
}

// 获取上级菜单ID
$parent_id = $_GET['parent_id'];

// 查询下级菜单选项
$sql = "SELECT id, name FROM menu WHERE parent_id = $parent_id";
$result = mysqli_query($conn, $sql);

// 输出下级菜单选项
if (mysqli_num_rows($result) > 0) {
    while($row = mysqli_fetch_assoc($result)) {
        echo "<option value='".$row['id']."'>".$row['name']."</option>";
    }
} else {
    echo "<option value=''>请选择</option>";
}

mysqli_close($conn);

// 调试信息
echo "查询语句: " . $sql . "<br>";
?>