How to implement batch deletion in php ajax-PHP Problem-php.cn

How to implement batch deletion in php ajax

藏色散人

Release： 2023-03-05 08:32:01

Original

2802 people have browsed it

php Ajax method to implement batch deletion: first click the select all button and select all the traversed check boxes; then make ajax request to the php processing page for batch deletion; finally implement batch deletion through if statements That’s it.

How to implement batch deletion in php ajax

Recommended: "PHP Video Tutorial"

By exchanging a small amount of data with the server in the background, Ajax can make Web pages are updated asynchronously. This means updating a portion of a web page without reloading the entire page.

First click the Select All button to select all the traversed check boxes

$("#cq").click(function () {
    $(".cq").prop("checked", $(this).prop("checked"));
})

Copy after login

js part, using jquery

var chk = "";
var check2 = "";  //判断多个复选框中的某一个是否被全选
function checked() {
    var count = 0;
    var checkx = $("#cq");
    if (checkx.checked) {
        check2 = 1;//选中全选按钮
    } else {
        check2 = 0;//没选中全选按钮
    }
    var checkArry = $(".cq");
    for (var i = 0; i < checkArry.length; i++) {
        if (checkArry[i].checked == true) {        //选中的操作
            count++;
        }
    }
    if (count == 0) {
        chk = 0;//没有选中项
    } else {
        chk = 1;//有选中项
    }
}
function all() {
    //批量删除
    $("#plscdz").click(function () {
        checked();
        if (chk == 1 || check2 == 1) {// 提交
            $(&#39;#myModal12&#39;).modal(&#39;show&#39;);
            $("#nqrplsc").click(function () {/*给确认删除按钮加事件*/
                $(&#39;#myModal12&#39;).modal(&#39;hide&#39;);
                //找选中的主键值，用循环遍历选中的主键值
                var cq = $(".cq");
                var plstr = "";
                for (var i = 0; i < cq.length; i++) {
                    if (cq.eq(i).prop("checked")) {
                        plstr += cq.eq(i).val() + "&#39;,&#39;";
                    }
                }
                plstr = plstr.substr(0, plstr.length - 3);
                //分隔符占3个字符，截取字符串，去掉最后的"&#39;,&#39;"
                $.ajax({
                    async: false,
                    url: "aa.php",
                    data: {id: plstr},
                    dataType: "TEXT",
                    type: "POST",
                    success: function (data) {
                        if (data.trim() == "OK") {
                            alert("删除成功");
                        } else {
                            alert("删除失败");
                        }
                    }
                });
            });
        } else if (chk == 0) {
            alert("请选择您要删除的内容");
        }
    })
}

Copy after login

ajax to request the php processing page for batch deletion. The following is the processing page for batch deletion

session_start();
include("DBDA.class.php");
$db = new DBDA();
if (!empty($_POST["id"])) {
    $id = $_POST["id"];
    $sql = "delete from user where id in (&#39;{$id}&#39;)";
    if ($db->Query($sql, 0)) {
        echo "OK";
    } else {
        echo "NO";
    }
}

Copy after login

The above is the detailed content of How to implement batch deletion in php ajax. For more information, please follow other related articles on the PHP Chinese website!