使用 Bootstrap Treeview Ajax JQuery with PHP 制作 Treeview

Question

我正在使用Bootstrap-Treeview，但我不确定如何使用Ajax和PHP将数据设置到Treeview中。

在服务器端，php文件被称为：fetch_data.php，是这样的：

<?php
include('db.php');
$parent_sponsor_id = 0;
$query = $DBcon->query("SELECT * FROM sponsor_referrals");
$result = $query->fetch_array();
foreach($result as $row)
{
$data = get_node_data($parent_sponsor_id, $DBcon);
}

echo json_encode(array_values($data));
function get_node_data($parent_sponsor_id, $DBcon)
{
$query2 = $DBcon->query("SELECT * FROM sponsor_referrals WHERE sponsorId = '".$parent_sponsor_id."'");
$result2 = $query2->fetch_array();
$output = array();
foreach($result2 as $row)
{
$sub_array = array();
$sub_array['text'] = $row['referredId'];
$sub_array['nodes'] = array_values(get_node_data($row['referredId'], $DBcon));
$output[] = $sub_array;
}
return $output;
}
?>

脚本是这样的：

fill_treeview();
function fill_treeview()
{
$.ajax({
url:"fetch_data.php",
dataType:"json",
success:function(data){
$('#treeview').treeview({
color: "#008cff",  
nodeIcon: "fa fa-user",
showTags: true,     
data:data
});
}
})
}

我需要帮助使树视图正常工作！ 提前感谢

Answer 1

我已经更改了这个的 php 代码，这有效

<?php
require 'db.php';
$parentKey = '0';
$sql = "SELECT * FROM sponsor_referrals";
$result = $DBcon->query($sql);
if(mysqli_num_rows($result) > 0)
{
$data = membersTree($parentKey);
}else{
$data=["id"=>"0","name"=>"No Members present in list","text"=>"No Members is present in list","nodes"=>[]];
}

function membersTree($parentKey)
{
global $DBcon;
$row1 = array();
$sql = 'SELECT id,referredId from sponsor_referrals WHERE sponsorId="'.$parentKey.'"';
$result = $DBcon->query($sql);
while($value = mysqli_fetch_assoc($result)){
$id = $value['id'];
$row1[$id]['id'] = $value['referredId'];
$row1[$id]['name'] = $value['name'];
$row1[$id]['text'] = $value['name'];
$row1[$id]['nodes'] = array_values(membersTree($value['referredId']));
}
return $row1;
}

echo json_encode(array_values($data));

?>