Delete row Jtable Jquery

Delete row Jtable Jquery

本文关键字：Jquery Jtable row Delete      更新时间：2023-10-17

我在删除行时遇到问题，我想是因为没有发送post[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);
}

有人能看到错误在哪里吗？

对不起，我没有给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"] . ";");

这就解决了问题。

相关文章：