如何在选中复选框时删除数据网格视图中的记录

// 监听复选框的变化事件
$('input[type="checkbox"]').change(function() {
  if($(this).is(':checked')) {
    var recordId = $(this).val(); // 获取选中复选框的值或标识符
    // 发送标识符到后端进行处理
    $.ajax({
      url: 'deleteRecord.php',
      method: 'POST',
      data: { recordId: recordId },
      success: function(response) {
        // 处理成功响应，可以进行相应的提示或刷新数据网格视图
        console.log('Record deleted successfully');
      },
      error: function() {
        // 处理失败响应，可以进行相应的提示
        console.log('Failed to delete record');
      }
    });
  }
});

// 接收前端发送的标识符
$recordId = $_POST['recordId'];

// 根据标识符从数据库中删除记录
// 这里假设使用MySQL数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}

$sql = "DELETE FROM records WHERE id = '$recordId'";

if ($conn->query($sql) === TRUE) {
  echo "Record deleted successfully";
} else {
  echo "Error deleting record: " . $conn->error;
}

$conn->close();