treeloader.php

php网页设计

<?
include "../include/db.php";
include "../include/general.php";
include "../include/authenticate.php";if (!checkperm("a")) {exit ("Permission denied.");}
$tree=file("data/tree.txt");

$node=$_GET["node"];
$id=$_GET["id"];

$ids=explode("-",$id);

$transfrom=array();
$transto=array();
for ($n=0;$n<count($ids);$n++)
    {
    $curid=$ids[$n];
    $s=explode(":",$curid);
    if (count($s)>1)
        {
        $transfrom[$n]="%" . $n;
        $transto[$n]=$s[1];
        $curid=$s[0];
        }
    }

#print_r($transfrom);
#print_r($transto);
#echo "'$id' cur='$curid'";
?>
<script language="Javascript">
<?
$debug="<li>curid=" . $curid;
for ($n=1;$n<count($tree);$n++)
    {
    $s=explode(";",trim($tree[$n]).";;;;;;;;;;;;;;;;;;;");
    if ($s[1]==$curid)
        {
        $debug.="<li>matched row $n";
        
        #parse SQL and do
        $query=$s[6];
        if (substr($query,0,2)=="as")
           	{
           	# "as" command means alias another line to this line, replacing certain values
           	$as=explode(" ",$s[6]);
           	$query=explode(";",trim($tree[$as[1]]));$query=$query[6];
           	for ($q=2;$q<count($as);$q+=2)
           		{
           		$query=str_replace($as[$q],$as[$q+1],$query);
           		}
           	}
        
        if ($query!="")
            {
           	# Query
           	$debug.="<li>query=" . $query;
            ?>
            //alert("query=<?=str_replace($transfrom,$transto,$query)?>");
            <?
            $result=sql_query(str_replace($transfrom,$transto,$query));
  	         for ($m=0;$m<count($result);$m++)
             	{
             	?>
             	parent.AddNode(<?=$node?>,"<?=$id."-".$n . ":" . 	$result[$m]["ref"]?>","<?=str_replace(array("\n","\r")," ",($result[$m]["name"]=="")?'(no name)':i18n_get_translated($result[$m]["name"]))?>",<?=$s[3]?>,<?=$s[4]?>,"<?=$s[5]?>");
              	<?
               	}
            }
        else
            {
            $debug.="<li>no query";
            ?>
            parent.AddNode(<?=$node?>,"<?=$id."-".$n?>","<?=(trim($s[2])=="")?"?":$s[2]?>",<?=$s[3]?>,<?=$s[4]?>,"<?=$s[5]?>");
            <?
            }
        }
    }
?>
parent.UpdateNode(<?=$node?>);
</script>
<?
#echo $debug;




?>