php+mysql数据库实现无限分类的方法
这篇文章主要介绍了php+mysql数据库实现无限分类的方法,包含完整的节点操作技巧以及相应的应用方法实例,是非常实用的技巧,需要的朋友可以参考下
本文实例讲述了php+mysql数据库实现无限分类的方法。分享给大家供大家参考。具体分析如下:
这款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[$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`) values ('$pid','$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();</script>';
- 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)."</option>";
- }
- return $select.'</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();
- ?>
前台调用实例代码如下:
- <style type="text/css">
- body{font-size:12px;}
- ul{list-style:none;}
- a{cursor:pointer;}
- </style>
- <script language="javascript">
- function $(e){return document.getelementbyid(e);}
- function mod(cid){
- $('cid').value=cid;
- $('op').value='mod';
- $('name').style.;
- }
- </script>
- <form action="" method="post">
- 名称:<input type="text" name="cname" /> 添加到:<?=makeselect($category,'pid')?><br />
- <input type="hidden" name="op" value="add" />
- <input type="hidden" name="cid" />
- <input type="submit" value="submit" />
- </form>
- <h3>移动分类</h3>
- <form action="" method="post">
- <?=makeselect($category,'who')?> gt;移动到:<?=makeselect($category,'to')?>
- <input type="hidden" name="op" value="move" />
- <input type="submit" value="submit" />
- </form>
- <ul>
- <?php
- foreach ($category as $id){
- echo '<li>'.$tree->getlayer($id, '|- ').$tree->getvalue($id).' <a href="time.php?op=del&c">del</a> <a onclick="mod('.$id.')">edit</a> </li>';
- }
- ?>
- </ul>
用phpmyadmin导入此数据库就ok了,实例代码如下:
- -- phpmyadmin sql dump
- -- version 3.2.4
- --
- -- 主机: localhost
- -- 生成日期: 2010 年 07 月 02 日 03:02
- -- 服务器版本: 5.1.41
- -- php 版本: 5.3.1
- set sql_mode="no_auto_value_on_zero";
- /*!40101 set @old_character_set_client=@@character_set_client */;
- /*!40101 set @old_character_set_results=@@character_set_results */;
- /*!40101 set @old_collation_connection=@@collation_connection */;
- /*!40101 set names utf8 */;
- --
- -- 数据库: `class`
- --
- -- --------------------------------------------------------
- --
- -- 表的结构 `p_newsclass`
- --
- create table if not exists `p_newsclass` (
- `id` int(7) not null auto_increment,
- `f_id` int(7) not null,
- `name` varchar(255) not null,
- primary key (`id`)
- ) engine=innodb default charset=utf8 auto_increment=10 ;
- --
- -- 转存表中的数据 `p_newsclass`
- --
- insert into `p_newsclass` (`id`, `f_id`, `name`) values
- (3, 0, '中国'),
- (4, 3, '福建'),
- (5, 4, '龙岩市'),
- (7, 4, '厦门市'),
- (9, 5, '漳平市');
- /*!40101 set character_set_client=@old_character_set_client */;
- /*!40101 set character_set_results=@old_character_set_results */;
- /*!40101 set collation_connection=@old_collation_connection */;
希望本文所述对大家的PHP+mysql程序设计有所帮助。