后台类别添加功能

1,新建typeadd.php

根据type表的fid字段使用了原生的无限极分类功能,代码如下所示

<?php
include 'include/mysqli.php';
?>
<!DOCTYPE html>
<html>
    <head>
        <meta charset="UTF-8">
        <title>添加类别</title>
        <link rel="stylesheet" type="text/css" href="css/style.css">
    </head>
    <body>
        <form method="post" action="typesave.php?action=add">
            <ul class="typecontent">
                <?php
                    ?>
                <li>父类名称<select name="fid">
                        <option value="0">根目录</option>
                        <?php
                        function show($fid,$i){
                            $i++;
                            $blank="";
                            for($n=0;$n<$i;$n++){
                                $blank.="---";
                            }
                        global $mysqli;
                        $sql="select *from type where fid=$fid order by orderid desc";
                        $result=$mysqli->query($sql);
                        $id=$_GET["id"];
                        while($row=$result->fetch_assoc()){
                            ?>
                            <option <?php if($id==$row['id']){echo "selected";}?> value="<?php echo $row['id']?>"><?php echo $blank.$row['typename'].$blank?></option>
                        <?php
                            show($fid=$row['id'],$i);
                        }
                        ?>
                        <?php }
                        show(0,0);
                        ?>
                    </select>
                </li>
                <li>类别名称<input class="inp" type="text" name="typename"></li>
                <li>排&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 序<input class="inp" type="text" name="orderid"></li>
                <li>
                    <input class="btn" type="submit" name="dosub" value="添加"></li>
            </ul>
        </form>
    </body>
</html>

页面展示如下:

微信图片_20180306193053.png

2,获取表单提交数据进行处理数据

新建typesave.php文件,代码如下:

<?php
header("Content-type:text/html;charset=utf-8");
include 'include/mysqli.php';
if($_GET["action"]=="add"){
    $fid=$_POST['fid'];
    $typename=$_POST["typename"];
    $orderid=$_POST["orderid"];
    if(empty($typename)){
        echo "<script>alert('类别名称不能为空!')</script>";
        return false;
    }
    $sql = "insert into type(typename,orderid,fid) values('$typename','$orderid','$fid')";
    if ($mysqli->query($sql)) {
        echo "<script>alert('类别添加成功')</script>";
        echo "<script>window.location='typelist.php'</script>";
    }
}elseif ($_GET["action"]=="update"){
    $typename=$_POST["typename"];
    $orderid=$_POST["orderid"];
    $id=$_POST["id"];
    if(empty($typename)){
        echo "<script>alert('类别名称不能为空!')</script>";
        return false;
    }
    $sql = "update type set typename='$typename',orderid='$orderid' where id='$id'";
    if ($mysqli->query($sql)) {
        echo "<script>alert('类别修改成功')</script>";
        echo "<script>window.location='typelist.php'</script>";
    }
}elseif ($_GET["action"]=="del"){
    $id=$_GET['id'];
    $sql = "delete from type where id=$id";
    if ($mysqli->query($sql)) {
        echo "<script>alert('类别删除成功')</script>";
        echo "<script>window.location='typelist.php'</script>";
    }
}elseif ($_GET["action"]=="delall"){
    $arrid=$_GET["arrid"];
    $arr=rtrim($arrid,",");
    $sql="delete from type where id in ($arr)";
    $result=$mysqli->query($sql);
    if($result){
        echo "<script>alert('类别删除成功!')</script>";
        echo "<script>window.location.href='typelist.php'</script>";
    }
}


效果展示如下:

gif5新文件 (5).gif


继续学习
||
<?php echo "类别添加功能";
提交重置代码
  • 推荐课程
  • 评论
  • 问答
  • 笔记
  • 课件下载
课件暂不提供下载,工作人员正在整理中,后期请多关注该课程~