<?php //树形 require_once '../../../include/config.php'; require_once '../../../include/mysql.class.php'; require_once '../../../include/common.fun.php'; /*New DB*/ $dbc = new DB_MYSQL(); $dbc->connect(g_db_host, g_db_user, g_db_pass, g_db_name, 0, 'utf8'); $tree_id = $_REQUEST['tree_id']; if ($tree_id != '') { $sql = "SELECT a.*,(SELECT COUNT(*) FROM " . g_tbl_prefix . "call_nature b WHERE a.id = b.parentid ) as cid_num FROM " . g_tbl_prefix . "call_nature a \r\n\tWHERE 1=1 AND a.active = 1 "; $sql .= "AND a.parentid = '{$tree_id}' "; $sql .= "ORDER BY a.orders ASC,a.id ASC"; $q = $dbc->query($sql); while ($r = $dbc->fetch_array($q)) { $n = $r['cid_num']; $list .= "<li id='{$r['id']}'><span class=''>{$r['title']} [ID:{$r['id']} 子类:{$r['cid_num']}]</span>\r\n"; if ($n > 0) { $list .= "<ul class='ajax'>\r\n"; $list .= "<li id='{$r['email']}'>{url:loadTree.php?tree_id=" . $r['id'] . "}</li>\r\n"; $list .= "</ul>\r\n"; } $list .= "</li>\r\n"; } echo $list; } unset($dbc); ?> <!-- <li id='35'><span class="text">Tree Node Ajax 1</span></li>