How to use php+ajax to select and delete all

This article mainly introduces the method of php ajax to realize all selection and deletion. It analyzes the specific operation steps and related techniques of html js front-end selection and batch deletion through ajax and background php interaction in the form of examples. Friends who need it can Refer to the following

for details:

<input type="checkbox" id="ckb_selectAll" onclick="selectAll()" title="选中/取消选中">
<a href="javascript:void(0);" onclick="del_()" title="删除选定数据" style="font-weight:normal">删除</a>

↑Select all checkbox

<input type="checkbox" class="ckb" id="+con.id+" value="+con.id+">

↑ is the deleted item, the same named class is ckb, which is convenient for operation. At the same time, the id value is cleverly put into the input for easy access.

function selectAll() {
  if ($('#ckb_selectAll').is(':checked')) {
    $(".ckb").attr("checked", true); //全部选中
  } else {
    $(".ckb").attr("checked", false);//全部取消
  }
}

↑Selected event

function del_() {
  var ids = '';
  $(".ckb").each(function() {
    if ($(this).is(':checked')) {
      ids += ',' + $(this).val(); //逐个获取id
    }
  });
  ids = ids.substring(1); // 对id进行处理，去除第一个逗号
  if (ids.length == 0) {
    alert('请选择要删除的选项');
  } else {
    if (confirm("确定删除？删除后将无法恢复。")) {
      url = "action=del_call_record&ids=" + ids;
      $.ajax({
        type: "post",
        url: "send.php",
        data: url,
        success: function(json) {
          if (parseInt(json.counts) > 0) {
            alert(json.des);
            location.reload();
          } else {
            alert(json.des);
          }
        },
        error: function(XMLHttpRequest, textStatus) {
          alert("页面请求错误，请检查重试或联系管理员！\n" + textStatus);
        }
      });
    }
  }
}

↑Deletion is handled with ajax.

↓Operate the database in the background and process deletion actions.

$ids = trim($_REQUEST['ids']);
$del_sql = "DELETE FROM vicidial_call_record WHERE id IN(".$ids.")";
//print_r($del_sql);exit;
if (mysqli_query($db_conn, $del_sql)) {
  $counts = "1";
  $des = "成功";
} else {
  $counts = "0";
  $des = "失败";
}
$json_data = "{";
$json_data. = "\"counts\":".json_encode($counts).",";
$json_data. = "\"des\":".json_encode($des)."";
$json_data. = "}";
echo $json_data;
break;

Complete

The above is the entire content of this article, I hope it will be helpful to everyone's study.

Related recommendations:

References and returns of php functions

ThinkPHPHow to use Memcached to cache data in the framework

##PHPVerification code class ValidateCode

The above is the detailed content of How to use php+ajax to select and delete all. For more information, please follow other related articles on the PHP Chinese website!