删除MySQL表行与jQuery阿贾克斯MySQL、jQuery、阿贾克斯

由网友(下辈子给你当舔狗)分享简介：我想使它所以当我点击一个跨度图标会，我使用jQuery的Ajax发送ID发送的article_id到我的PHP SQL网页，其中删除我的文章中，ID发送好吗jQuery开发边而过的HTTP POST请求做我的表行还是有的，任何人都可以看到，如果有些事情错了我的code，先谢谢了！＆LT; PHP$ sql_catego...

我想使它所以当我点击一个跨度图标会，我使用jQuery的Ajax发送ID发送的article_id到我的PHP SQL网页，其中删除我的文章中，ID发送好吗jQuery开发边而过的HTTP POST请求做我的表行还是有的，任何人都可以看到，如果有些事情错了我的code，先谢谢了！

 ＆LT; 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
                从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;

            如果（$结果=查询（$ sql_categories））{
                $名单=阵列（）;

                而（$数据= mysqli_fetch_assoc（$结果））{
                    array_push（$列表中，$数据）;
                }

                的foreach（$清单，$ I =＆GT; $行）{
                ？＆GT;
                    ＆LT; DIV CLASS =行ID =PAGE_＆LT;？PHP的回声$行['art_id'];？＆GT;＆GT;
                        ＆LT; DIV CLASS =列中的一个＆GT;
                            ＆LT;跨度类=图标，小动＆GT;＆LT; / SPAN＆GT;
                            ＆LT; A HREF =编辑 -  article.php art_id =＆LT;？PHP的echo $行['art_id'];？＆GT;＆GT;＆LT;跨度类=图标，小编辑＆GT;＆LT; / SPAN＆GT ;＆所述; / a取代;
                            ＆LT;跨度ID =＆LT;？PHP的回声$行['art_id'];？＆gt;中类=图标，小杂鱼＆GT;＆LT; / SPAN＆GT;
                        ＆LT; / DIV＆GT;
                        ＆LT; DIV CLASS =两栏＆GT;＆LT; P＆GT;＆LT; PHP的echo $行['art_title']; ？＆GT;＆LT; / P＆GT;＆LT; / DIV＆GT;
                        ＆LT; DIV CLASS =两栏＆GT;＆LT; P＆GT;＆LT; PHP的echo $行['art_company']; ？＆GT;＆LT; / P＆GT;＆LT; / DIV＆GT;
                        ＆LT; DIV CLASS =两栏＆GT;＆LT; P＆GT;＆LT; PHP的echo $行['cat_name']; ？＆GT;＆LT; / P＆GT;＆LT; / DIV＆GT;
                        ＆LT; DIV CLASS =列中的一个＆GT;＆LT; P＆GT;＆LT; PHP的echo $行['art_date']; ？＆GT;＆LT; / P＆GT;＆LT; / DIV＆GT;
                        ＆LT; DIV CLASS =列中的一个＆GT;＆LT; P＆GT;＆LT; PHP的echo $行['art_rating']; ？＆GT;＆LT; / P＆GT;＆LT; / DIV＆GT;
                        ＆LT; DIV CLASS =列中的一个＆GT;＆LT; P＆GT;＆LT; PHP的echo $行['art_price']; ？＆GT;＆LT; / P＆GT;＆LT; / DIV＆GT;
                        ＆LT; DIV CLASS =列中的一个＆GT;＆LT; P＆GT;＆LT; PHP的echo $行['sta_name']; ？＆GT;＆LT; / P＆GT;＆LT; / DIV＆GT;
                        ＆LT; DIV CLASS =列中的一个＆GT;＆LT; A HREF =＆GT;＆LT;跨度类=图标，小星＆GT;＆LT; / SPAN＆GT;＆LT; / A＆GT;＆LT; / DIV＆GT;
                    ＆LT; / DIV＆GT;
                ＆LT; PHP
                }
            }
            其他 {
                回声不及格;
            }
        ？＆GT;


jQuery的

        $（文件）。就绪（函数（）{

                $（垃圾）。点击（函数（）{

            VAR del_id = $（本）.attr（'身份证'）;

            $阿贾克斯（{
                键入：POST，
                网址：'AJAX-delete.php'，
                数据：'delete_id ='+ del_id，
                成功：功能（数据）{
                    如果（数据）{

                    }
                    其他 {

                    }
                }

            }）;
        }）;

    }）;


PHP MySQL的声明

    如果（使用isset（$ _ POST ['delete_id']））{

        $ sql_articles =DELETE FROM app_articles WHERE art_id =$ _ POST ['delete_id']。

        如果（查询（$ sql_articles））{
            回声YES;
        }
        其他 {
            回声否;
        }
    }
其他 {
    回声不及格;
}


？＆GT;

解决方案

你行还是存在的，因为AJAX调用不会刷新页面的原因。如果你希望你的行中删除你必须做的是这样的：

假设你的跨度click事件是行内

  $（垃圾）。点击（函数（）{
   VAR del_id = $（本）.attr（'身份证'）;
   。VAR rowElement = $（本）.parent（）父（）; //抢行

   $阿贾克斯（{
            键入：POST，
            网址：'AJAX-delete.php'，
            数据：{delete_id：del_id}，
            成功：功能（数据）{
                如果（数据==是）{
                   rowElement.fadeOut（500）上卸下摆臂（）;
                }
                其他 {

                }
            }
    }）;

替换：

 数据：'delete_id ='+ del_id，

mysql对某个表进行操作,查询添加记录删除表等操作时提示表不存在,但表明明显示在列表中,为什么

与

 数据：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,

阅读全文

相关专题：MySQL ；jQuery ；阿贾克斯；发布时间：2023-09-10 13:12:08