Jtable删除不删除

Question

我在Jquery Jtable插件delete方法上遇到了一个问题。变量'email‘在页面之间传递并进入.php文件。list action函数可以工作，所以我知道这不是连接问题。我的数据库名是maps。下面是我的代码: Javascript：

var emailHolder="email@email.com";
var file="c";
function loadForm()
{
$("#my-form" ).dialog( "open" );
}   

    $(document).ready(function () {
        //Prepare jTable
        $('#PeopleTableContainer').jtable({
            title: 'Table of people',
            actions: {
                listAction: 'PersonActions.php?action=list&emailHolder='+emailHolder,
                deleteAction: 'PersonActions.php?action=delete&emailHolder='+emailHolder+"&fileHolder="+file
            },
    fields: {
                filename: {
                key:true,
                    title: 'File',
                    width: '40%'

                },
                email: {
                title:'User',
                    key: true,
                    create: false,
                    edit: false,
                    list:false

                }
            }
        });
Php:



 {
    $email= $_GET['emailHolder'];
        //Delete from database
        $result = mysql_query("DELETE FROM maps WHERE (email='$email' and filename = " . $_POST["filename"] . ");");

        //Return result to jTable
        $jTableResult = array();
        $jTableResult['Result'] = "OK";
        print json_encode($jTableResult);
    }

Answer 1

我不确定是否要从jtable中的'email‘字段中删除'key’