function getchild($id) { global $db; $finalarray = array(); $query = $db->query("select * from member where sonof={$id} and dontshow=0"); while ($row = $db->fetch($query)) { $obj = createstruct($row); $obj['children'] = getwife($row['id']); array_push($finalarray, $obj); } return $finalarray; }
<?php require "header.php"; global $db; $familyid = $_GET['familyid']; //Get the family id of the family to be shown if (!$familyid) { $familyid = 1; } //Get the member who is son of no one and is male and is of given family id $query = $db->query("select * from member where sonof is null and dontshow=0 and gender=0 and family_id={$familyid}"); $row = $db->fetch($query); //Create a infovis struct $finalkey = createstruct($row); $finalkey['children'] = getwife($row['id']); echo json_encode($finalkey);