本款php无限分类代码比较完整理包括了数据库是mysql的,有增加、删除、编辑、移动的功能,同时还提供数据库sql表结构.代码如下:
-
-
$link = mysql_connect('localhost','root','') or die(mysql_error());
-
mysql_select_db('class',$link)or die(mysql_error());
-
mysql_query("set names gbk");
-
-
class sortclass{
-
var $data = array();
-
var $child = array(-1=>array());
-
var $layer = array(-1=>-1);
-
var $parent = array();
-
var $link;
-
var $table;
-
function sortclass($link, $table){
-
$this->setnode(0, -1, '顶极节点');
-
$this->link = $link;
-
$this->table = $table;
-
$node = array();
-
$results = mysql_query("select * from $this->table",$this->link);
-
while($node = mysql_fetch_array($results)){
-
$this->setnode($node['id'],$node['f_id'],$node['name']);
-
}
-
}
-
function setnode ($id, $parent, $value){
-
$parent = $parent?$parent:0;
-
$this->data[$id] = $value;
-
$this->child[$id] = array();
-
$this->child[$parent][] = $id;
-
$this->parent[$id] = $parent;
-
$this->layer[$id] = !isset($this->layer[$parent])? 0 : $this->layer[$parent] + 1;
-
}
-
function getlist (&$tree, $root= 0){
-
foreach ($this->child[