$cmd = $this->connection->prepare('SELECT t1.user_id AS lev1
, t2.user_id as lev2
, t3.user_id as lev3
, t4.user_id as lev4
FROM tree_table AS t1
LEFT OUTER
JOIN tree_table AS t2
ON t2.p_id = t1.user_id
LEFT OUTER
JOIN tree_table AS t3
ON t3.p_id = t2.user_id
LEFT OUTER
JOIN tree_table AS t4
ON t4.p_id = t3.user_id
WHERE t1.user_id = 5');
$cmd->execute();
$records = $cmd->fetchAll(PDO::FETCH_ASSOC);
foreach($records as $row){
// here I'm confuse how to make the data,I got wrong output here.
// $rowdata[] = [['v' => $row['lev1'], 'f' => $row['lev1']], (string)$row['lev1'],$row['lev1']];
}
I could not edit anymore my first post,I will just post another example.
This is the result of select statement below.
And I’m using this Google OrgChart to display a heirachical format,
my problem is that I’m confuse on how to loop in my while loop.in order to form the format.
just like in the google orgchart.
This is my php code.
$cmd = $this->connection->prepare('SELECT t1.memid AS lev1
, t2.memid as lev2
, t3.memid as lev3
, t4.memid as lev4
FROM mytree AS t1
LEFT OUTER
JOIN mytree AS t2
ON t2.parentid = t1.memid
LEFT OUTER
JOIN mytree AS t3
ON t3.parentid = t2.memid
LEFT OUTER
JOIN mytree AS t4
ON t4.parentid = t3.memid
WHERE t1.memid = ?');
$cmd->execute(array('1'));
$rec = array();
while ( $row = $cmd->fetch(PDO::FETCH_ASSOC)) {
for ($i = 0; $i < 4; $i++) {
$rec[] = [['v' => $row['lev2'], 'f' => $row['lev2']], (string)$row['lev1'], $row['lev2']];
}
}
return json_encode($rec);