ptree.php

开源的 库存管理系统 www.minierp.cn php+ mysql

<?php
//echo showptree();
function showptree(){
$treestr = '<div class="dtree">';
$treestr.= '<script type="text/javascript" src="../inc/popdtree.js"></script>';
$treestr.= '<script type="text/javascript">';
$treestr.= 'd = new dTree("d");';

 require_once ("../inc/db.php");
 require_once ("../inc/phpmkrfn.php");
 require_once ('../inc/xtpl.php');

 $xtpl=new XTemplate ("prodtree.html");

 $conn = phpmkr_db_connect(HOST, USER, PASS, DB, PORT);
 $sSql  = "SELECT * FROM pleibie "; 
    $rs  = phpmkr_query($sSql,$conn) or die("Failed to execute query: " . phpmkr_error() . '<br>SQL: ' . $sSql);

$treestr.= "d.add(0,-1,'鐢㈠搧璩囨枡');";


	while ($row = mysql_fetch_array($rs, MYSQL_ASSOC)) {
	$treestr.= "d.add($row[PLB03],$row[PLB04],'$row[PLB02]','javascript:tsel(\'$row[PLB03]\',\'$row[PLB04]\',\'$row[PLB01]\',\'$row[PLB02]\',\'$row[AUTOID]\')','');\n";  
	}
$treestr.= '	document.write(d);';
$treestr.= '	</script>';
$treestr.= ' </div>';
return $treestr;
}
?>