php+mysql数据库实现无限分类的方法

本文实例讲述了php+mysql数据库实现无限分类的方法。分享给大家供大家参考。具体分析如下：

这款php无限分类代码比较完整理包括了数据库是mysql的,有增加、删除、编辑、移动的功能,同时还提供数据库sql表结构.代码如下: 代码如下: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[$root] as $key=>$id){ $tree[] = $id; if ($this->child[$id]) $this->getlist($tree,$id); } } function getvalue ($id){return $this->data[$id];} function getlayer ($id,$space = false){ return $space?str_repeat($space,$this->layer[$id]):$this->layer[$id]; } function getparent ($id){return $this->parent[$id];} function getparents ($id){ while ($this->parent[$id] != -1){ $id = $parent[$this->layer[$id]] = $this->parent[$id]; } ksort($parent); reset($parent); return $parent; } function getchild ($id){return $this->child[$id];} function getchilds ($id = 0){ $child = array($id); $this->getlist($child,$id); return $child; } function addnode($name,$pid){ //echo "insert into $this->table (`f_id`,`name`) values ('$pid','$name')";exit; mysql_query("insert into $this->table (`f_id`,'$name')",$this->link); } function modnode($cid,$newname){ mysql_query("update $this->table set `name`='$newname' where `id` = $cid",$this->link); } function delnode($cid){ $allchilds = $this->getchilds($cid); $sql =''; if(emptyempty($allchilds)){ $sql = "delete from $this->table where `id` = $cid"; }else{ $sql = 'delete from '.$this->table.' where `id` in ('.implode(',',$allchilds).','.$cid.')'; } mysql_query($sql,$this->link); } function movenode($cid,$topid){ mysql_query("update $this->table set `f_id`=$topid where `id` = $cid",$this->link); } } //函数 function back(){ echo '

移动分类

'.$tree->getlayer($id,'|－ ').$tree->getvalue($id).' '; } ?>