有关分类的问题

<html>
<head>
<title></title>
<script src="xtree.js"></script>
<link type="text/css" rel="stylesheet" href="xtree.css">
<style>
body { background: white; color: black; }
input { width: 120px; }
</style></head>
<body>
<div style="position: absolute; width: 200px; top: 0px; left: 0px; height: 100%; padding: 5px; overflow: auto;">
<?php
$conn = OCILogon("AAA","AAA","AAA");
$sql1="select MENU_NAME,MENU_DESC,MENU_SEQ,ROWNUM,MENU_TYPE from menu  where menu_lang='CH'AND PRNT_MENU='-1'";
$sql2="select MENU_NAME,MENU_DESC,MENU_SEQ,ROWNUM,MENU_TYPE from menu  where menu_lang='CH'AND PRNT_MENU=:menu_name ";
$sql3="select MENU_NAME,MENU_DESC,MENU_SEQ,ROWNUM,MENU_TYPE from menu  where menu_lang='CH'AND PRNT_MENU=:menu_name2 ";
$sql4="select MENU_NAME,MENU_DESC,MENU_SEQ,ROWNUM,MENU_TYPE from menu  where menu_lang='CH'AND PRNT_MENU=:menu_name3 ";
$stmt = OCIParse($conn, $sql1);
$stmt2 = OCIParse($conn, $sql2);
$stmt3 = OCIParse($conn, $sql3);
$stmt4 = OCIParse($conn, $sql4);
OCIBINDBYNAME($stmt2,":menu_name",&$menu_name,32);
OCIBINDBYNAME($stmt3,":menu_name2",&$menu_name2,32);
OCIBINDBYNAME($stmt4,":menu_name3",&$menu_name3,32);
OCIexecute($stmt);
?>
<script>
  if (document.getElementById) {
  var tree= new WebFXTree('ERP');
  tree.setBehavior('classic');
<?php while (OCIFetch($stmt)){?>
  var F<?php echo OCIresult($stmt,4);?>;
  F<?php echo OCIresult($stmt,4);?>=tree.add(new WebFXTreeItem('<?php echo OCIresult($stmt,2);?>'));
  <?php $menu_name=OCIresult($stmt,1);
     OCIexecute($stmt2);
     while (OCIFetch($stmt2)){?>
     var M<?php echo OCIresult($stmt2,4);?> ;
     M<?php echo OCIresult($stmt2,4);?>=F<?php echo OCIresult($stmt,4);?>.add(new WebFXTreeItem('<?php echo OCIresult($stmt2,2);?>'));
     <?php $menu_name2=OCIresult($stmt2,1);
        OCIexecute($stmt3);
        while (OCIFetch($stmt3)){?>
        var N<?php echo OCIresult($stmt3,4);?> ;
        N<?php echo OCIresult($stmt3,4);?>=M<?php echo OCIresult($stmt2,4);?>.add(new WebFXTreeItem('<?php echo OCIresult($stmt3,2);?>'));
        <?php $menu_name3=OCIresult($stmt3,1);
        OCIexecute($stmt4);
        while (OCIFetch($stmt4)){?>
        var N<?php echo OCIresult($stmt4,4);?> ;
        L<?php echo OCIresult($stmt4,4);?>=N<?php echo OCIresult($stmt3,4);?>.add(new WebFXTreeItem('<?php echo OCIresult($stmt4,2);?>'));
<?php }}}}
OCIFreeStatement($stmt);
OCIFreeStatement($stmt2);
OCIFreeStatement($stmt3);
OCIFreeStatement($stmt4);
OCILogoff($conn);?>
document.write(tree);
}
</script>
</div>
</body>
</html>

解决方案 »

  1.   

    http://expert.csdn.net/expert/topic/974/974562.xml应该有你要的东西。
      

  2.   

    http://expert.csdn.net/expert/topic/974/974562.xml应该有你要的东西
      

  3.   

    我用的不是Oracle数据库，是mysql
    能不能你的数据库表的结构给我呢
      

  4.   

    http://expert.csdn.net/expert/topic/974/974562.xml
    有关这个程序我已经看了，但是第一个选择框中的数据不能固定