1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
| function Getparents($conceptid, $distance, $tabConceptID)
{
$db = new DatabaseConnection(CFG_DB_HOST, CFG_DB_USER, CFG_DB_PASS, CFG_DB_DATABASE);
$db->query("SET CHARACTER SET 'utf8'");
$db->query("SET NAMES utf8");
$queryParents = "SELECT relation.ConceptID2 FROM relation WHERE relation.ConceptID1=\"$conceptid\";";
$Parents = $db->query_all($queryParents);
for ($i = 0; $i < count($Parents); $i++)
{
$parid = $Parents[$i]['ConceptID2'];
$count=count($tabConceptID);
$tabConceptID[$count][0]= $parid;
$tabConceptID[$count][1]= $distance;
echo $parid;
echo " $distance";
echo "</br>";
Getparents($parid, $distance+1, $tabConceptID);
}
return $tabConceptID;
}
$tab = array();
$tr = Getparents("D002277", 1, $tab);
echo count($tr); |
Partager