今天写了下无限极分类 下面就把代码贴上来了 写的不怎么样。
method of classify one
复制代码 代码如下:
error_reporting(7);
header("Content:text/html;charset=utf-8");
//这里先进行操作的判断
$arr = array('list','add','del','edit','addok','edit_ok');
$act= in_array($_GET['ac'],$arr)?$_GET['ac']:$arr[0];
//连接数据库
$conn = mysql_connect("localhost","root","root")or die('数据库连接失败');
mysql_select_db("study",$conn);
mysql_query("set names utf8");
//根据分类层进行排序
$sql = "select * from types order by type_p_id";
$sql1 = mysql_query($sql);
//添加分类
if($act == "addok"){
$type_id = $_POST['type_id'];
$type_name = $_POST['type_name'];
//如果等于0表示是跟目录
if($type_id=="0"){
$sql = "insert into types set type_name = '{$type_name}'";
$res = mysql_query($sql);
$id = mysql_insert_id();
$sql = "update types set type_p_id = '$id,' where type_id=$id";
$res = mysql_query($sql);
if( mysql_affected_rows ()>0){
echo "";
}else{
echo "";
}
}//如果不等于0
else{
//根据typeid 找到 该id下的type_p_id
$sql = "select type_p_id from `types` where type_id = $type_id";
$res = mysql_query($sql);
$res = mysql_fetch_assoc($res);
$type_id = $res['type_p_id'];
//先将名称插入进去
$sql = "insert into types set type_name = '{$type_name}'";
$res = mysql_query($sql);
//获取最后执行的id 然后进行数据更新 主要更新 type_p_id
$id = mysql_insert_id();
$sql = "update types set type_p_id = '$type_id$id,' where type_id=$id";
$res = mysql_query($sql);
if($res){
echo "";
}else{
echo "";
}
}
}elseif($act=="add"){
?>
}elseif($act == "list"){
//获取列表根据 分类层进行排序
$sql = "select * from types order by type_p_id";
$res = mysql_query($sql);
?>
| id | 分类名 | path路径 | 操作 |
| ">编辑 | ">删除 |
}elseif($act == "edit"){
$id = $_GET['type_id'];
$sql = "select *from `types` where type_id=$id ";
$res = mysql_query($sql);
echo "";
}elseif($act == "edit_ok"){
$name = trim($_POST['n_type_name']);
$id = $_POST['id'];
if(!empty($name)){
$sql = "update `types` set type_name='$name' where type_id=$id";
mysql_query($sql);
echo "";
}else{
echo "";
}
}elseif($act == 'del'){
//这里的删除是要把当前分类 和当前的子分类都要删除 所以用到$id%
$id = $_GET['type_id'];
$sql ="delete from `types` where type_p_id like '$id%' ";
$res = mysql_query($sql);
if($res){
echo "";
}else{
echo "";
}
}
?>
types表：
下面是效果图：
method of classify two
复制代码 代码如下:
error_reporting(7);
header("Content-type:text/html;charset=utf-8");
//这里先进行操作的判断
$arr = array('list','add','del','edit','addok','edit_ok');
$act= in_array($_GET['ac'],$arr)?$_GET['ac']:$arr[0];
//连接数据库
$conn = mysql_connect("localhost","root","root")or die('数据库连接失败');
mysql_select_db("study",$conn);
mysql_query("set names utf8");
if($act=="add"){
function getTypes(&$types=array(),$pid=0,$path=0){
$sql = "select * from `type` where type_p_id = $pid";
$res = mysql_query($sql);
while($row = mysql_fetch_assoc($res)){
$str = "";
for($i=0;$i<$path;$i++){
$str.=" ";
}
$row['new_type_name'] = $str.$row['type_name'];
$types[] = $row;
getTypes($types,$row['type_id'],($path+1));
}
return $types;
}
//获取分类 调用函数
getTypes($types);
//获取列表根据 分类层进行排序
$sql1 = "select * from type order by type_id";
$sqll = mysql_query($sql1);
?>
}elseif($act == "addok"){
$type_name = $_POST['type_name'];
$type_id = $_POST['type_id'];
$sql = "insert into `type`(type_name,type_p_id) values ('$type_name','$type_id')";
$res = mysql_query($sql);
if(mysql_insert_id()>0){
echo "";
}else{
echo "";
}
}elseif($act == "list"){
//获取列表根据 分类层进行排序
$sql = "select * from type order by concat(type_id,type_p_id)";
$res = mysql_query($sql);
?>
| id | 分类名 | path路径 | 操作 |
| ">编辑 | ">删除 |
}elseif($act == "del"){
mysql_query("SET AUTOCOMMIT=1");//开启事务
$type_id = $_GET['type_id'];
//删除该分类
$sqlone = "delete from `type` where type_id=$type_id";
//删除该分类下的子分类
$sqltwo = "delete from `type`where type_p_id=$type_id";
$res1 = mysql_query($sqlone);
$res2 = mysql_query($sqltwo);
if($res1 && $res2)
{
mysql_query("COMMIT");
echo "";
}else{
mysql_query("ROLLBACK");
echo "";
}
}
?>
type表：
下面是效果图
写的确实不怎么样啊 还望大家见谅。
