节点删除

来源：互联网发布：麻省理工科技评论知乎编辑：程序博客网时间：2024/05/16 01:37
html 代码
<!DOCTYPE html><html><head lang="en">    <meta charset="UTF-8">    <title></title></head><body><center>    <table border="1">        <tr>            <td></td>            <td>Id</td>            <td>商品号</td>            <td>商品名称</td>        </tr>        <?php foreach($arr as $v){?>        <tr class="abc">            <td><input type="checkbox" value="<?php echo $v['goods_id']?>" name="all"/></td>            <td><?php echo $v['goods_id']?></td>            <td><?php echo $v['goods_sn']?></td>            <td><?php echo $v['goods_name']?></td>        </tr>        <?php }?>    </table>    <input type="button" value="批删" id="more_del" onclick="more_del(<?php echo $page?>)"/></center></body></html><script src="./jquery.js"></script><script>    function more_del(page){        var arr = new Array();        $("[name='all']:checked").each(function(i){            var goods_id = $(this).val();            arr[i] = goods_id;        });        $.get('jdd.php',{arr:arr,page:page,act:'aaa'},function(obj){            console.log(obj);            $("[name='all']:checked").each(function(i){                $(this).parent().parent().remove();            });            var str = "";            for(var i in obj){               str+= "<tr>";                str+= '<td><input type="checkbox" value="'+obj[i].goods_id+'" name="all"/></td>';                str+= "<td>"+obj[i].goods_id+"</td>";                str+= "<td>"+obj[i].goods_sn+"</td>";                str+= "<td>"+obj[i].goods_name+"</td>";               str+= "</tr>";            }            $(".abc").last().after(str);           // var obj = evel();        },'json');    }</script>php 代码<?php$act = isset($_GET['act']) ? $_GET['act'] :'';header('content-type:text/html;;charset=utf-8');if($act=='aaa') {    $pdo = new PDO('mysql:host=127.0.0.1;dbname=upload', 'root', 'root');    $pdo->exec('set names utf8');    $arr = $_GET['arr'];    $page = $_GET['page'];    //var_dump($arr);    $num = count($arr);    $start = $page * 5 - $num;    foreach($arr as $v){      $sql = "delete from ecs_goods where goods_id =".$v;      $pdo->exec($sql);    }    $sql = "select * from ecs_goods";    $result = $pdo->query($sql)->fetchAll(PDO::FETCH_ASSOC);    $result = array_slice($result, $start, $num);    echo Json_encode($result);}
1 0