Pengubahsuaian dan pemadaman lajur

Dalam bab sebelumnya, kami telah menambah fungsi lajur dan senarai paparan lajur Pada halaman paparan, kami mempunyai kod berikut:

<td>
    <a class="link-update" href="cate_edit.php?id=<?php echo $v['id'];?>">修改</a>
    <a class="link-del" onclick="return confirm('确定删除当前数据？')" href="cate_del.php?id=<?php echo $v['id']; ?>">删除</a>
</td>

Di sini kami telah memperoleh id lajur yang sepadan, yang perlu dipaparkan pada. halaman yang sepadan Selepas menerima ID ini, anda boleh melengkapkan pengubahsuaian dan pemadaman lajur melalui operasi pada pangkalan data.

Pertama sekali, kami akan melakukan fungsi pengubahsuaian dengan mengklik halaman pengubahsuaian akan memasuki halaman berikut:

Di sini kami akan mengeluarkan fail yang telah ditambahkan ke pangkalan data, dan kemudian memaparkan data pada bahagian. halaman. Kod adalah seperti berikut:

<?php
include_once('../../common/config.php');
$id=$_GET['id'];
$sql="select * from cate WHERE id='$id'";
$que=mysqli_query($conn,$sql);
$row=mysqli_fetch_assoc($que);

function getList($pid=0,&$result=array(),$spac=0)
{
    global $conn;
    $spac +=4;
    $sql = "select * from cate where pid = $pid";
    $res = mysqli_query($conn,$sql);
    while($rows=mysqli_fetch_array($res))
    {
        $rows["name"] = str_repeat('&nbsp;',$spac).'|--'.$rows["name"];
        $result[] = $rows;
        getList($rows['id'],$result,$spac);
    }
    return $result;
}
$rs=getList();
//print_r($rs);
//die;
?>

<!doctype html>
<html>
<head>
    <meta charset="UTF-8">
    <title>栏目修改--后台管理</title>
    <link rel="stylesheet" type="text/css" href="../../public/style/css/common.css"/>
    <link rel="stylesheet" type="text/css" href="../../public/style/css/main.css"/>
    <script type="text/javascript" src="../../public/style/js/libs/modernizr.min.js"></script>
    <script type="text/javascript" charset="utf-8" src="../../public/ueditor/ueditor.config.js"></script>
    <script type="text/javascript" charset="utf-8" src="../../public/ueditor/ueditor.all.min.js"></script>
    <script type="text/javascript" charset="utf-8" src="../../public/ueditor/lang/zh-cn/zh-cn.js"></script>
</head>
<body>
<?php include_once("../../common/top.php"); ?>

<div class="container clearfix">

    <?php include("../../common/left.php"); ?>
    <!--/sidebar-->
    <div class="main-wrap">

        <div class="crumb-wrap">
            <div class="crumb-list"><i class="icon-font"></i><a href="../index.php">首页</a><span class="crumb-step">></span><a class="crumb-name" href="cate_list.php">栏目管理</a><span class="crumb-step">></span><span>新增作品</span></div>
        </div>
        <div class="result-wrap">
            <div class="result-content">
                <form action="cate_upd.php" method="post" id="myform" name="myform" enctype="multipart/form-data">
                    <input type="hidden" name="id" value="<?php echo $id;?>">
                    <table class="insert-tab" width="100%">
                        <tbody>

                        <tr>
                            <th><i class="require-red">*</i>栏目标题：</th>
                            <td>
                                <input class="common-text required" id="title" name="name" size="50" value="<?php echo $row['name'];?>" type="text">
                            </td>
                        </tr>
                        <tr>
                            <th><i class="require-red">*</i>栏目类型：</th>
                            <td>
                                <select name="modelid" class="form-control">

                                   <option <?php if($row['modelid']==1){
                                       echo "selected";
                                   } ?> value='1'>文章模型</option>;

                                   <option <?php if($row['modelid']==2){
                                       echo "selected";
                                   } ?> value='2'>单页模型</option>;

                                   <option <?php if($row['modelid']==3){
                                       echo "selected";
                                   } ?> value='3'>产品模型</option>;

                                   <option <?php if($row['modelid']==4){
                                       echo "selected";
                                   } ?> value='4'>图片模型</option>;

                                    ?>
                                </select>
                            </td>
                        </tr>
                        <tr>
                            <th><i class="require-red">*</i>栏目状态：</th>
                            <td>
                                <input type='radio' <?php if($row['status']==1){
                                   echo "checked";
                                } ?> name='status' value='1'/>显示&nbsp&nbsp
                                <input type='radio' <?php if($row['status']==0){
                                    echo "checked";
                                } ?>  name='status' value='0'/>隐藏
                            </td>
                        <tr>
                            <th>关键词：</th>
                            <td>
                                <input class="common-text required" id="title" name="keywords" size="50" value="<?php echo $row['keywords'];?>" type="text">
                            </td>
                        </tr>
                        <tr>
                            <th>内容：</th>
                            <td><textarea name="content" class="common-textarea" id="content" cols="30" style="width: 98%;" rows="10"><?php echo $row['content'] ?></textarea></td>
                        </tr>
                        <tr>
                            <th></th>
                            <td>
                                <input class="btn btn-primary btn6 mr10" value="提交" type="submit">
                                <input class="btn btn6" onclick="history.go(-1)" value="返回" type="button">
                            </td>
                        </tr>
                        </tbody></table>
                </form>
            </div>
        </div>

    </div>
    <!--/main-->
</div>
</body>
</html>
<script type="text/javascript">

    UE.getEditor('content',{initialFrameWidth:1100,initialFrameHeight:400,});

</script>

Data dikeluarkan, dan kemudian data dihantar ke halaman yang sepadan Selepas menerimanya, gunakan pernyataan sql untuk menyimpannya ke pangkalan data data pada halaman ini. Hanya tukar atribut tindakan borang borang Hanya tetapkan ia kepada kosong Berikut adalah kod untuk halaman yang menerima pengubahsuaian data .

Apa yang anda perlu beri perhatian semasa memadam ialah kerana lajur kami mempunyai klasifikasi peringkat kedua, apabila anda ingin memadam kategori peringkat atas, anda mesti memadamkan subkategori di bawah kategori peringkat atas dahulu, jika tidak pemadaman tidak dibenarkan. Diamante adalah seperti berikut:

Meneruskan pembelajaran

fail baharu

<?php include_once('../../common/config.php'); $id=$_GET['id']; $sql="select * from cate WHERE id='$id'"; $que=mysqli_query($conn,$sql); $row=mysqli_fetch_assoc($que); function getList($pid=0,&$result=array(),$spac=0) { global $conn; $spac +=4; $sql = "select * from cate where pid = $pid"; $res = mysqli_query($conn,$sql); while($rows=mysqli_fetch_array($res)) { $rows["name"] = str_repeat(' ',$spac).'|--'.$rows["name"]; $result[] = $rows; getList($rows['id'],$result,$spac); } return $result; } $rs=getList(); //print_r($rs); //die; ?> <!doctype html> <html> <head> <meta charset="UTF-8"> <title>栏目修改--后台管理</title> <link rel="stylesheet" type="text/css" href="../../public/style/css/common.css"/> <link rel="stylesheet" type="text/css" href="../../public/style/css/main.css"/> <script type="text/javascript" src="../../public/style/js/libs/modernizr.min.js"></script> <script type="text/javascript" charset="utf-8" src="../../public/ueditor/ueditor.config.js"></script> <script type="text/javascript" charset="utf-8" src="../../public/ueditor/ueditor.all.min.js"></script> <script type="text/javascript" charset="utf-8" src="../../public/ueditor/lang/zh-cn/zh-cn.js"></script> </head> <body> <?php include_once("../../common/top.php"); ?> <div class="container clearfix"> <?php include("../../common/left.php"); ?>  <div class="main-wrap"> <div class="crumb-wrap"> <div class="crumb-list"><i class="icon-font"></i><a href="../index.php">首页</a><span class="crumb-step">></span><a class="crumb-name" href="cate_list.php">栏目管理</a><span class="crumb-step">></span><span>新增作品</span></div> </div> <div class="result-wrap"> <div class="result-content"> <form action="cate_upd.php" method="post" id="myform" name="myform" enctype="multipart/form-data"> <input type="hidden" name="id" value="<?php echo $id;?>"> <table class="insert-tab" width="100%"> <tbody>       <?php ///* foreach($rs as $k=>$v){ // */?> <?php ///*if($v['id']==$id) { // echo "selected"; // }*/?><?php ///*echo $v['id']*/?><?php ///*echo $v['name']; */?> <?php ///* } // */?>     <tr> <th><i class="require-red">*</i>栏目标题：</th> <td> <input class="common-text required" id="title" name="name" size="50" value="<?php echo $row['name'];?>" type="text"> </td> </tr> <tr> <th><i class="require-red">*</i>栏目类型：</th> <td> <select name="modelid" class="form-control"> <option <?php if($row['modelid']==1){ echo "selected"; } ?> value='1'>文章模型</option>; <option <?php if($row['modelid']==2){ echo "selected"; } ?> value='2'>单页模型</option>; <option <?php if($row['modelid']==3){ echo "selected"; } ?> value='3'>产品模型</option>; <option <?php if($row['modelid']==4){ echo "selected"; } ?> value='4'>图片模型</option>; ?> </select> </td> </tr> <tr> <th><i class="require-red">*</i>栏目状态：</th> <td> <input type='radio' <?php if($row['status']==1){ echo "checked"; } ?> name='status' value='1'/>显示&nbsp&nbsp <input type='radio' <?php if($row['status']==0){ echo "checked"; } ?> name='status' value='0'/>隐藏 </td> <tr> <th>关键词：</th> <td> <input class="common-text required" id="title" name="keywords" size="50" value="<?php echo $row['keywords'];?>" type="text"> </td> </tr> <tr> <th>内容：</th> <td><textarea name="content" class="common-textarea" id="content" cols="30" style="width: 98%;" rows="10"><?php echo $row['content'] ?></textarea></td> </tr> <tr> <th></th> <td> <input class="btn btn-primary btn6 mr10" value="提交" type="submit"> <input class="btn btn6" onclick="history.go(-1)" value="返回" type="button"> </td> </tr> </tbody></table> </form> </div> </div> </div>  </div> </body> </html> <script type="text/javascript"> UE.getEditor('content',{initialFrameWidth:1100,initialFrameHeight:400,}); </script>

serahkan Tetapkan Semula Kod

Operasi automatik

Pengubahsuaian dan pemadaman lajur

peringkat rendahTutorial tapak web tiruan perusahaan Imperial CMS

peringkat rendahPemula dengan asas sifar dalam WordPress membina blog peribadi dan laman web korporat

peringkat rendahVideo arahan pembinaan tapak web berasaskan sifar CMS muktamad

peringkat rendahProjek hadapan-Shangyou [amalan komprehensif teknologi HTML/CSS/JS]

PertengahanVue3.0 daripada 0 untuk membina amalan projek sistem pengurusan belakang universal

peringkat rendahKursus front-end berasaskan sifar [pembelajaran lanjutan Vue dan aplikasi praktikal]

peringkat rendahTutorial bahagian hadapan WEB [HTML5+CSS3+JS]

peringkat rendahBermula dengan cepat dengan apipost

PertengahanTutorial praktikal Vue3+TypeScript amalan projek peringkat perusahaan

peringkat rendahMari kita bercakap secara ringkas tentang memulakan perniagaan dalam PHP

PertengahanProjek e-dagang VUE (pertempuran sebenar projek dua bahagian hadapan & belakang)

peringkat rendahAplikasi praktikal Apipost [api, antara muka, ujian automatik, olok-olok]