php网站分类目录源码

// 检查数据库查询语句
$query = "SELECT * FROM categories WHERE parent_id = 0";
$result = mysqli_query($conn, $query);

// 检查前端展示逻辑
while ($row = mysqli_fetch_assoc($result)) {
    echo '<a href="category.php?id=' . $row['id'] . '">' . $row['name'] . '</a>';
}

// 检查表单提交数据
if (isset($_POST['name']) && isset($_POST['parent_id'])) {
    $name = mysqli_real_escape_string($conn, $_POST['name']);
    $parent_id = mysqli_real_escape_string($conn, $_POST['parent_id']);

    // 插入数据到数据库
    $query = "INSERT INTO categories (name, parent_id) VALUES ('$name', '$parent_id')";
    if (mysqli_query($conn, $query)) {
        echo "分类目录添加成功";
    } else {
        echo "添加失败：" . mysqli_error($conn);
    }
} else {
    echo "表单数据不完整";
}