weixin_33725272 2016-12-30 05:07 采纳率: 0%
浏览 116

AJAX删除数据库条目

I am new to AJAX (and website development in general) and I am having trouble deleting a database entry in wordpress using jQuery and AJAX.
The user selects an entry in a table and clicks a button to delete it. The table is created using datatables plugin and extensive coding to make it work the way I need it to.
the jQuery code is in functions.php and the actual query is in a file on the server.
I have been using this how to delete records from database with an Ajax as a baseline for the code. Also, note that I am using wordpress My problem is that it does not seem to delete the entry from the database.

Here is the code in functions.php:

var GroupID2Del = dt.row({
        selected: true
    })
    .data()[23];
if (confirm('Are you sure you want to delete this row?')) {
    jQuery.ajax({
        type: 'POST',
        url: '/wp-content/AJAX/ViewTable_DeleteEntry.php',
        data: 'groupid=' + GroupID2Del,
        success: function(data) {
            dt.row({
                    selected: true
                })
                .remove();
            jQuery('#UserTable')
                .DataTable()
                .draw();
            alert(data);
        }
    });
}

GroupID2Del is how I am getting the id for it the selected row in the table. I am then removing the row from the table itself. The row does get removed.

Here is the ViewTable_DeleteEntry.php

<?php
    $dataPosted = $_POST['groupid'];
    $sql = ('delete from wp_piic_formmaker_submits WHERE form_id = 13 and group_id =' . $dataPosted);
    mysql_query($sql);
    $count = mysql_affected_rows();
    print $count; 
?>

alert in function.php provides the correct sql, but the $count is empty since it does not actually delete anything.

  • 写回答

4条回答

      报告相同问题?

      相关推荐 更多相似问题

      悬赏问题

      • ¥15 GEO下载数据的处理报错 :函数‘Meta’标签‘"data.frame"’找不到继承方法,如何解决?
      • ¥15 DLNM模型是否可以用二分类变量作为y变量
      • ¥15 android object box 一个实体多个表怎么写
      • ¥15 temux 启用docker 服务失败
      • ¥15 Flask 使用celery发送邮件出现‘目标计算机积极拒绝‘
      • ¥60 老人用的sd卡在手机里面不知道操作了什么,导致图片和视频变成了文件,取下sd卡连接电脑就是图中的样子,后缀改为.jpg才可以,需要用系统的画图软件才能打开,文件属性还是文件,有没有批量操作的解决办法
      • ¥15 超时跳出方法代码的返回值问题
      • ¥15 汇编语言程序设计设计,ascii码求数,再求数的BCD码
      • ¥30 Mask rcnn训练自己的数据集出现问题!
      • ¥20 研究人工智能时的几个问题