使用PHP从MariaDB中提取数据并生成文件夹的分层JSON - tree视图

<?php
// 建立与MariaDB的连接
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

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

// SQL查询语句
$sql = "SELECT * FROM your_table";

// 执行查询
$result = $conn->query($sql);

// 创建空数组
$data = array();

// 遍历查询结果
while($row = $result->fetch_assoc()) {
    // 构建树形结构
    $node = array(
        'id' => $row['id'],
        'name' => $row['name'],
        'parent_id' => $row['parent_id']
    );
    $data[] = $node;
}

// 递归构建树形结构
function buildTree($data, $parentId = 0) {
    $tree = array();
    foreach($data as $node) {
        if ($node['parent_id'] == $parentId) {
            $children = buildTree($data, $node['id']);
            if ($children) {
                $node['children'] = $children;
            }
            $tree[] = $node;
        }
    }
    return $tree;
}

// 构建树形结构
$treeData = buildTree($data);

// 转换为JSON格式
$jsonData = json_encode($treeData);

// 保存JSON数据到文件
file_put_contents('tree.json', $jsonData);

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