<?php
//connect to database server and the database
$db = "data/biocViewsVocab.sqlite";
$db_link = sqlite_open($db);
// Recursive function to create the menu structure string
function createTree($db, $node, $txt, $level)
{
$txt=$txt.$level."|".$node."\n";
$query = "SELECT * FROM biocViews WHERE edgeFrom='".$node."'";
$result = sqlite_query($db, $query);
if (sizeof($result) > 0){
$level=$level.".";
while($row=sqlite_fetch_array($result))
$txt=createTree($db, $row["edgeTo"], $txt, $level);
}
return $txt;
}
$txt = createTree($db_link, "BiocViews", "", ".");
?>
<html>
<head>
<link rel="stylesheet" href="layersmenu.css" type="text/css"></link>
<style type="text/css">
<!--
@import url("layerstreemenu.css");
//-->
</style>
<?php include ("libjs/layersmenu-browser_detection.js"); ?>
<script language="JavaScript" type="text/javascript" src="libjs/layerstreemenu-cookies.js"></script>
</head>
<body>
<?php
include ("lib/template.inc.php");
include ("lib/layersmenu.inc.php");
// build and print the menu
$mid = new LayersMenu();
$mid->setMenuStructureString($txt);
$mid->parseStructureForMenu("treemenu1");
print $mid->newTreeMenu("treemenu1");
?>
</body>
</html>