javascript - 删除行 Jtable Jquery

Question

我在删除行时遇到问题，我认为是因为没有发送帖子[id]。显示删除消息，但该行并未被删除。这是我的代码:

JavaScript:

$(document).ready(function () {

    $('#PersonTableContainer').jtable({
        title: 'Tabla de Clientes',
        paging: true,
        pageSize: 10,
        sorting: true,
        defaultSorting: 'Nombre ASC',
        actions: {
            listAction: 'AccionesClientes.php?action=list',
            createAction: 'AccionesClientes.php?action=create',
            updateAction: 'AccionesClientes.php?action=update',
            deleteAction: 'AccionesClientes.php?action=delete',
        },
        fields: {
            id: {
                key: true,
                create: false,
        edit: false,
        list: false
            },

PHP:

else if($GET["action"] == "delete")
{
//Delete from database
$result = mysqlquery("DELETE FROM clientes WHERE id= ".$_POST["id"].";");

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

谁能看出错误出在哪里吗？

Answer 1

抱歉，我没有为 LIST 方法上的 id 字段赋予任何值

$result = mysql_query("SELECT **id as id**, nombre as Nombre, apellido1 as Apellido1, cedula as Cedula, empresa as Empresa, nit as Nit  FROM clientes ORDER BY " . $_GET["jtSorting"] . " LIMIT " . $_GET["jtStartIndex"] . "," . $_GET["jtPageSize"] . ";");

这解决了问题。