使用 jQuery Ajax 删除 mySQL 表行

Deleting mySQL Table Row with jQuery Ajax(使用 jQuery Ajax 删除 mySQL 表行)

  $row){?><div class="row" id="page_<?php echo $row['art_id']; ?>"><div class="第一列"><span class="icon-small move"></span><a href="edit-article.php?art_id=<?php echo $row['art_id']; ?>"><span class="icon-small edit"></span></a><span id="<?php echo $row['art_id']; ?>"class="icon-small垃圾"></span>
<div class="第二列"><p><?php echo $row['art_title'];?></p></div><div class="第二列"><p><?php echo $row['art_company'];?></p></div><div class="第二列"><p><?php echo $row['cat_name'];?></p></div><div class="第一列"><p><?php echo $row['art_date'];?></p></div><div class="第一列"><p><?php echo $row['art_rating'];?></p></div><div class="第一列"><p><?php echo $row['art_price'];?></p></div><div class="第一列"><p><?php echo $row['sta_name'];?></p></div><div class="第一列"><a href=""><span class="icon-small star"></span></a></div>

<?php}}别的 {回声失败"；}?>jQuery$(document).ready(function(){$(".trash").click(function(){var del_id = $(this).attr('id');$.ajax({类型:'POST'，url:'ajax-delete.php',数据:'delete_id='+del_id，成功:功能(数据){如果(数据){}别的 {}}});});});PHP mySQL 语句if(isset($_POST['delete_id'])) {$sql_articles = "DELETE FROM app_articles WHERE art_id = ".$_POST['delete_id'];如果(查询($sql_articles)){回声是"；}别的 {回声否"；}}别的 {回声失败"；}?>

你的行仍然存在的原因是因为 AJAX 调用没有刷新页面.如果您想删除您的行，您必须执行以下操作:

假设您的跨度点击事件在行内

 $(".trash").click(function(){var del_id = $(this).attr('id');var rowElement = $(this).parent().parent();//抓取行$.ajax({类型:'POST'，url:'ajax-delete.php',数据:{delete_id:del_id}，成功:功能(数据){如果(数据==是"){rowElement.fadeOut(500).remove();}别的 {}}});

替换:

 数据:'delete_id='+del_id,

与:

 数据:delete_id:del_id，

I'm trying to make it so when I click a span icon it will send the article_id to my php sql page which deletes my article, I'm using jQuery Ajax to send the id, the id sends alright on the jQuery side but after the http post request is done my table row is still there, can anyone see if somethings wrong with my code, thanks in advance!

    <?php
        $sql_categories = "SELECT art_id, art_title, art_company, art_cat_id, art_sta_id, art_date, art_rating, art_price, cat_id, cat_name, sta_id, sta_name
                FROM app_articles LEFT JOIN app_categories
                ON app_articles.art_cat_id = app_categories.cat_id
                LEFT JOIN app_status
                ON app_articles.art_sta_id = app_status.sta_id
                ORDER BY art_order ASC"; 

            if($result = query($sql_categories)){
                $list = array();

                while($data = mysqli_fetch_assoc($result)){
                    array_push($list, $data);
                }

                foreach($list as $i => $row){ 
                ?>
                    <div class="row" id="page_<?php echo $row['art_id']; ?>">
                        <div class="column one">
                            <span class="icon-small move"></span>
                            <a href="edit-article.php?art_id=<?php echo $row['art_id']; ?>"><span class="icon-small edit"></span></a>
                            <span id="<?php echo $row['art_id']; ?>" class="icon-small trash"></span>
                        </div>
                        <div class="column two"><p><?php echo $row['art_title']; ?></p></div>
                        <div class="column two"><p><?php echo $row['art_company']; ?></p></div>
                        <div class="column two"><p><?php echo $row['cat_name']; ?></p></div>
                        <div class="column one"><p><?php echo $row['art_date']; ?></p></div>
                        <div class="column one"><p><?php echo $row['art_rating']; ?></p></div>
                        <div class="column one"><p><?php echo $row['art_price']; ?></p></div>
                        <div class="column one"><p><?php echo $row['sta_name']; ?></p></div>
                        <div class="column one"><a href=""><span class="icon-small star"></span></a></div>
                    </div>
                <?php
                }
            }
            else {
                echo "FAIL";
            }
        ?>


jQuery

        $(document).ready(function(){

                $(".trash").click(function(){

            var del_id = $(this).attr('id');

            $.ajax({
                type:'POST',
                url:'ajax-delete.php',
                data: 'delete_id='+del_id,
                success:function(data) {
                    if(data) {

                    } 
                    else {

                    }   
                }

            }); 
        });

    });


PHP mySQL Statement

    if(isset($_POST['delete_id'])) {

        $sql_articles = "DELETE FROM app_articles WHERE art_id = ".$_POST['delete_id'];

        if(query($sql_articles)) {
            echo "YES";
        }
        else {
            echo "NO";
        }
    }
else {
    echo "FAIL";
}


?>

the reason your row is still there because AJAX call does not refresh the page. If you want your row to be removed you gotta do something like:

ASSUMING that your span click event is inside the row

 $(".trash").click(function(){
   var del_id = $(this).attr('id');
   var rowElement = $(this).parent().parent(); //grab the row

   $.ajax({
            type:'POST',
            url:'ajax-delete.php',
            data: {delete_id : del_id},
            success:function(data) {
                if(data == "YES") {
                   rowElement.fadeOut(500).remove();
                } 
                else {

                }   
            }
    });

Replace:

            data: 'delete_id='+del_id,

with:

            data: delete_id : del_id,

这篇关于使用 jQuery Ajax 删除 mySQL 表行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！