无法使用 AJAX 删除 php 中的行

Question

我正在使用 AJAX 在 PHP 中删除行，但它显示 Row 无法删除。我的删除按钮是这样的...

while ($row = mysqli_fetch_array($exec)) 

{

?>

    <tr>

        <td><?php echo $row["create_date"]; ?></td>

        <td><?php echo $row["bni_member_id"]; ?></td>

        <td><?php echo $row["bni_member_name"]; ?></td>

        <td><?php echo $row["bni_chapter_id"]; ?></td>

        <td><?php echo $row["bni_category_id"]; ?></td>

        <td><input type="button" name="delete" onclick="delFun()" value="delete" id="<?php echo $row["bni_member_id"]; ?>" class="btn btn-info btn-xs delete_data"/></td>

    </tr>

    <?php

}

?>

我在点击按钮上调用一个函数。这样的功能。它总是执行部分无法删除。我认为有问题

data: {del_id: del_id},

我认为数据有问题......但我无法解决它。

   var delfin;

$(document).ready(function () {

    delFun = function () {

        $('.delete_data').click(function () {

            var del_id = $(this).attr("name");

            var $ele = $(this).parent().parent();

            $.ajax({

                url: "phpfile/delete.php",

                method: "POST",

                data: {del_id: del_id},

                success: function (data) {

                    if(data=="YES"){

                        $ele.fadeOut().remove();

                     }else{

                            alert("can't delete the row")

                     }

                }

            });

        });

    } 

}); 

我的 PHP 文件在另一个这样的目录中

<?php

    include('../../connection.php');

    $music_number = $_POST['del_id'];

    //echo $music_number;

    $qry = "DELETE FROM bni_member WHERE bni_member_id ='$music_number'";

    $result=mysql_query($qry);

    if(isset($result)) {

       echo "YES";

    } else {

       echo "NO";

    }

?>

Answer 1

第一个问题是，您name从删除按钮获取属性。您可以bni_member_id作为数据属性传递而不是使用元素id属性。它会引起混乱。第二个问题是，您同时使用了onlick属性和 jQuery 的click方法。使用它们就足够了。您的输入按钮将如下所示：<td><input type="button" name="delete" value="delete" class="btn btn-info btn-xs delete_data" data-bni-member-id="<?= $row["bni_member_id"]; ?>" /></td>然后你的js看起来像这样：$(document).ready(function () {&nbsp; &nbsp; $('.delete_data').click(function () {&nbsp; &nbsp; &nbsp; &nbsp; var del_id = $(this).data("bni_member_id");&nbsp; &nbsp; &nbsp; &nbsp; var $ele = $(this).parent().parent();&nbsp; &nbsp; &nbsp; &nbsp; $.ajax({&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; url: "phpfile/delete.php",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; method: "POST",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; data: {del_id: del_id},&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; success: function (data) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(data=="YES"){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $ele.fadeOut().remove();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; alert("can't delete the row")&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; });&nbsp; &nbsp; });});我希望这可以帮助你。

Answer 2

我正在与您分享我的代码尝试这样&nbsp; &nbsp; &nbsp; &nbsp;<tr>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <td><?php echo $i; ?></td>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <td><?php echo $row["exam_name"]; ?></td>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <td><?php echo $row["exam_date"]; ?></td>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <td><?php echo $row["exam_status"]; ?></td>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <td><?php echo $row["exam_comment"]; ?></td>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<td><button type="button" name="delete_btn" id="<?php echo $row["examid"]; ?>" class="btn btn-sm btn-danger btn_delete"><i class="fa fa-trash"></i></button></td>&nbsp;&nbsp; &nbsp; &nbsp; </tr>添加脚本<script type="text/javascript">&nbsp; &nbsp; $(document).on('click', '.btn_delete', function(){&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;// var id=$(this).data("id3");&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var el = this;&nbsp; &nbsp; &nbsp; &nbsp; var id = this.id;&nbsp; &nbsp; &nbsp; &nbsp; var splitid = id.split("_");&nbsp; &nbsp; &nbsp; &nbsp; // Delete id&nbsp; &nbsp; &nbsp; &nbsp; var deleteid = splitid[1];&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;if(confirm("Are you sure you want to delete this?"))&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;{&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $.ajax({&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;url:"path.....",&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;method:"POST",&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;data:{id:id},&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dataType:"text",&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;success:function(data){&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$(el).closest('tr').css('background','#d31027');&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $(el).closest('tr').fadeOut(800, function(){&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $(this).remove();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; });&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;}&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; });&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;}&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; });&nbsp;&nbsp;</script>

Answer 3

您可以更改删除按钮&nbsp;<input type="button" name="delete" onclick="delFun()" value="delete" data-id="<?php echo $row["bni_member_id"]; ?>" class="btn btn-info btn-xs delete_data"/>和 Jquery 事件&nbsp; &nbsp; $(document).on("click",".delete_data",function () {&nbsp; &nbsp; var del_id = $(this).data("id");