dedecms自定义联动类别方法

CREATE TABLE `dede_linkage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
);

<?php
// 获取联动类别数据
$linkageData = array();
$result = $dsql->query("SELECT * FROM dede_linkage ORDER BY parent_id, id");
while ($row = $dsql->GetArray($result)) {
    $linkageData[$row['parent_id']][$row['id']] = $row['name'];
}

// 输出联动类别选择框
function printLinkageSelect($parentId, $selectedId, $linkageData) {
    echo '<select name="category" onchange="updateLinkage(this.value)">';
    foreach ($linkageData[$parentId] as $id => $name) {
        $selected = ($id == $selectedId) ? 'selected' : '';
        echo "<option value='$id' $selected>$name</option>";
    }
    echo '</select>';
}

// 初始化联动类别选择框
printLinkageSelect(0, 0, $linkageData);
?>

<script>
function updateLinkage(parentId) {
    var url = 'get_linkage.php'; // 后端接口地址
    var xhr = new XMLHttpRequest();
    xhr.onreadystatechange = function() {
        if (xhr.readyState == 4 && xhr.status == 200) {
            var linkageSelect = document.getElementById('linkageSelect');
            linkageSelect.innerHTML = xhr.responseText;
        }
    };
    xhr.open('GET', url + '?parentId=' + parentId, true);
    xhr.send();
}
</script>

<select id="linkageSelect" name="subcategory"></select>

<?php
$parentId = intval($_GET['parentId']);
$linkageData = array();
$result = $dsql->query("SELECT * FROM dede_linkage WHERE parent_id = $parentId ORDER BY id");
while ($row = $dsql->GetArray($result)) {
    echo "<option value='{$row['id']}'>{$row['name']}</option>";
}
?>