rendered paste body<!doctype html public "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"><?$host = "localhost";$dbuser = "";$dbpasswd = "";$dbname = "docsmenu";$db = mysql_connect($host, $dbuser, $dbpasswd) or die("Could not connect.");if(!$db) die("no db");if(!mysql_select_db($dbname,$db)) die("No database selected.");?><html><head><title>CIMCO Documentation</title><link rel="stylesheet" type="text/css" href="css/screen.css"></head> <body onload="treeInit()"><link rel="stylesheet" type="text/css" href="css/folders/tree.css"><div id="pageTitle"> <h3>CIMCO Documentation</h3></div><script type="text/javascript" src="../build/yahoo/yahoo.js" ></script><script type="text/javascript" src="../build/event/event.js"></script><!-- The following are required for the logger --><script type="text/javascript" src="../build/dom/dom.js"></script><script type="text/javascript" src="../build/logger/logger.js"></script><!-- End logger reqs --><script type="text/javascript" src="../build/treeview/treeview-debug.js" ></script><div id="container"> <div id="containerTop"> <div id="header"> <h1> </h1> <h4> </h4> </div> <div id="main"> <div id="content"> <form name="mainForm" action="javscript:;"> <div class="newsItem"> <h3>Directories</h3> <p> </p> <div id="expandcontractdiv"> <a href="javascript:tree.expandAll()">Expand all</a> <a href="javascript:tree.collapseAll()">Collapse all</a> </div> <div id="treeDiv1"></div> </div> </form> </div> <div id="footerContainer"> <div id="footer"> <p> </p> </div> </div> </div> </div></div><script type="text/javascript"> var tree; var nodes = new Array(); var nodeIndex; function treeInit() { buildDirectoryTree(); } function buildDirectoryTree() { tree = new YAHOO.widget.TreeView("treeDiv1"); var root = tree.getRoot(); var headings = new Array();<?$query = "SELECT nodeid,nodename FROM nodes ORDER BY id";$nodenames = mysql_query($query);$x = 0;while ($result = mysql_fetch_array($nodenames)) { $nodename = $result['nodename']; print "headings[$x] = \"$nodename\";"; $x++;}?> for (i=0;i<headings.length;i++) { var tmpNode = new YAHOO.widget.TextNode({label: headings[i], customData: headings[i] + "-metadata"},root,false); buildTextBranch(tmpNode); } tree.draw(); } var callback = null; function buildTextBranch(node) { var oSubData = {<?$query = "SELECT count(*) as `count` FROM nodes";$counts = mysql_query($query);$counts1 = mysql_fetch_array($counts);$count = $counts1['count'];//print "$count";$query = "SELECT nodeid,nodename FROM nodes ORDER BY id";$nodenames = mysql_query($query);$y = 0;while ($result = mysql_fetch_array($nodenames)) { $nodename = $result['nodename']; $nodeid = $result['nodeid']; print "$nodename: "; $query = "SELECT docname FROM documents WHERE parent = '$nodeid'"; $nodedoc = mysql_query($query); print "["; $t = 0; while ($docres = mysql_fetch_array($nodedoc)) { $docname = $docres['docname']; if ($t == 0) { print "\"$docname\""; $t++; } else { print ", \"$docname\""; } } $y++; if ($y != $count) { print "],\n"; } else { print "]\n"; }} ?> } var children = oSubData[node.data.label]; for (i=0;i<children.length;i++) { thisSub = children[i]; var tmpNode = new YAHOO.widget.TextNode({label:thisSub}, node, false); } }</script> </body></html>