实现php无限极分类的方法 - PHP教程

method of classify one

<?php   
/*   
       
reader: 这是自己写的无限极分类实现方法 里面的编辑方法只是对分类名进行了编辑    
没有进行移动操作 小弟能力有限忘大家多多包涵啊   
       
 第一种方法：   
CREATE TABLE `types` (   
  `type_id` int(11) NOT NULL AUTO_INCREMENT,   
  `type_name` varchar(20) NOT NULL,   
  `type_p_id` varchar(64) NOT NULL DEFAULT '-',   
  PRIMARY KEY (`type_id`),   
  KEY `type_name` (`type_name`),   
  KEY `tname` (`type_name`)   
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8   
注：   
 这里没做字段有效验证；   
 type_id     表示主键自增    
 type_name     表示分类名   
 type_p_id     表示分类路径 这里的分类路径是 上层父类的分类路径加上此类的主键id 用逗号隔

开   
*/
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 "<script>location.href='ok.php?act=list'</script>";   
        }else{   
            echo "<script>alert('添加失败');</script>";   
        }   
    }//如果不等于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 "<script>location.href='ok.php?act=list'</script>";   
        }else{   
            echo "<script>alert('添加失败');</script>";   
        }   
    }   
}elseif($act=="add"){   
?>   
<form method="post" action="?ac=addok">   
新分类名称:    <input type="text" name="type_name"><br/>  

 
当前分类：<select name="type_id" >   
    <option  value="0">顶级分类</option>   
    <?php   
    //循环遍历分类   
    while($res = mysql_fetch_assoc($sql1)){   
        //查找 ","号出现的次数   
        $m=substr_count($res['type_p_id'],",");   
        //使用空格替换 "空格"   
        $strpad = str_pad("",$m*8*2,"&#12288;");   
        if($m==1){   
            $sele = "disabled";   
        }else{   
            $sele = "";   
        }   
    ?>   
        <option value="<?php echo $res['type_id']?>"><?php  echo $strpad.$res['type_name']?></option>   
    <?php   
    }   
    ?>   
    </select><br />   
    <input type="submit"  value="添加"/>   
</form>   
<?php                   
}elseif($act == "list"){   
    //获取列表根据 分类层进行排序   
    $sql = "select * from types order by type_p_id";   
    $res = mysql_query($sql);   
?>   

<table width="50%" style="font-size:12px;margin-left:20%;">   
<tr><td>id</td><td>分类名</td><td>path路径

</td><td>操作</td></tr>   
<?php   
while($arr = mysql_fetch_assoc($res)){?>   
<tr>   
    <td><?php echo $arr['type_id']?></td>   
    <td><?php echo $arr['type_name']?></td>   
    <td><?php echo $arr['type_p_id']?></td>   
    <td ><a href="?ac=edit&type_id=<?php echo $arr['type_id'];?>">编辑</a> |   
        <a href="?ac=del&type_id=<?php echo $arr['type_id'];?>">删除</a></td>   
</tr>   
<?php    
    }   
?>   
</table>   
<input type="button"  value="添加"  onclick="

(location.href='?ac=add')">   
<?php                   
}elseif($act == "edit"){   
    $id = $_GET['type_id'];   
    $sql = "select *from  `types` where type_id=$id ";   
    $res = mysql_query($sql);   
    echo "<form  method='post'  action='?ac=edit_ok'>";   
    while($arr = mysql_fetch_assoc($res)){   
        echo "当前名称：{$arr['type_name']}"."<br />";   
        echo "新名称：<input type='text'  name='n_type_name'  >"."<br />";   
        echo "<input type='hidden'  value={$arr['type_id']} name='id'/>"; 

  
    }   
    echo "<input type='submit'  value='更新'>";   
    echo "</form>";   
}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 "<script>location.href('ok.php?act=list')</script>";   
    }else{   
        echo "<script>location.href('ok.php?act=list')</script>";   
    }   
}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 "<script>location.href('ok.php?act=list')</script>";   
    }else{   
        echo "<script>alert('删除失败');</script>";   
    }   
}   
?>

（编辑：应用网_镇江站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!