php+mysql数据库实现无限分类的方法
前端之家收集整理的这篇文章主要介绍了
php+mysql数据库实现无限分类的方法，
前端之家小编觉得挺不错的，现在分享给大家，也给大家做个参考。
@H_404_0@本文实例讲述了PHP+MysqL数据库实现无限分类的方法。分享给大家供大家参考。具体分析如下：
@H_
404_0@这款
PHP无限
分类代码比较完整理
包括了
数据库是
MysqL的,有
增加、
删除、编辑、移动的
功能,同时还提供
数据库sql表结构.
代码如下:
<div class="codetitle">
<a style="CURSOR: pointer" data="62369" class="copybut" id="copybut62369" onclick="doCopy('code62369')"> 代码如下: <div class="codebody" id="code62369">//连接数据库
$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[$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 '<script language="网页特效">window.location.href="news.class.
PHP?"+new date().gettime();';
exit;
}
//
生成select
function makeselect($array,$formname){
global $tree;
$select = '<select name="'.$formname.'">';
foreach ($array as $id){
$select.='<option value="'.$id.'">'.$tree->getlayer($id,'|-').$tree->getvalue($id)."";
}
return $select.'';
}
$tree = new sortclass($link,'
p_newsclass');
$op = !emptyempty($_post['op']) ? $_post['op'] : $_get['op'];
if(!emptyempty($op)){
if($op=='add'){
$tree->addnode($_post['cname'],$_post['pid']);
back();
}
if($op=='mod'){
$tree->modnode($_post['cid'],$_post['cname']);
back();
}
if($op=='del'){
$tree->delnode($_get['cid']);
back();
}
if($op=='move'){
$tree->movenode($_post['who'],$_post['to']);
back();
}
}
$category = $tree->getchilds();
?>
