<?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," ");
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>";
}
}
?>
