I just can`t delete any row from DB --- pls HELP

robertutzu

I just cant delete any row - all seems fine as you can see the network request
the row is removed from table but it is not removed from database
after refresh the row is back
new and update works fine

do i need to make something more to delete a row from database?

Network request:

Request URL:    administrare/app/ajax/parcele.php
Request Method:     POST
Status Code:    HTTP/1.1 204 No Response
Request Headers 11:00:27.000
X-Requested-With:   XMLHttpRequest
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:42.0) Gecko/20100101 Firefox/42.0
Referer:    administrare/app/parcele.php
Pragma: no-cache
Host:   domain name
DNT:    1
Content-Type:   application/x-www-form-urlencoded; charset=UTF-8
Content-Length: 113
Connection: keep-alive
Cache-Control:  no-cache
Accept-Language:    en-US,en;q=0.5
Accept-Encoding:    gzip, deflate
Accept: application/json, text/javascript, */*; q=0.01
Sent Cookie
wcp_useroptions_id: bd53624b06a9d85a68e646dab24ea993564d77316022a7.60643830
PHPSESSID:  57bf35fee75e7bb029e44e51367ae7ab
logSysrememberMe:   1
logSyslogin:    cc6229335e167135e32568dbecf78cc04a86ad44300655787da13c7740c4b3cc
_ga:    GA1.2.2011565582.1446813563
Request Body
action=remove&data%5Brow_11%5D%5BDT_RowId%5D=row_11&data%5Brow_11%5D%5Bparcela%5D=10&data%5Brow_11%5D%5Bzona%5D=B
Response Headers Δ391ms
Vary:   Accept-Encoding
Server: Apache
Keep-Alive: timeout=5, max=100
Date:   Fri, 20 Nov 2015 09:00:24 GMT
Content-Type:   text/html
Content-Encoding:   gzip
Connection: Keep-Alive
No Response Body Δ0ms

script:

<script>
var editor; // use a global for the submit and return data rendering in the examples

$( document ).ready(function() {
editor = new $.fn.dataTable.Editor( {
ajax: "ajax/parcele.php",
table: "#parcele",


fields: [ {
label: "Parcela:",
name: "parcela"
},
{label: "Zona:",
name: "zona",
type: "select"}
]
} );

/* Activate an inline edit on click of a table cell
$('#parcele').on( 'click', 'tbody td', function (e) {
        editor.inline( this, {
            buttons: { label: '&gt;', fn: function () { this.submit(); } }
        } );
    } );
*/
    
var table = $('#parcele').DataTable( {
    
    
ajax: {
            url: "ajax/parcele.php",
            type: "POST"
        },
        processing: true,
        serverSide: true,
        
        
columns: [
{ data: "parcela" },
{ data: "zona" }
],
select: true
} );


// Display the buttons
    new $.fn.dataTable.Buttons( table, [
        { extend: "create", editor: editor },
        { extend: "edit",   editor: editor },
        { extend: "remove", editor: editor },
        { extend: 'collection', text: 'Export', buttons: ['copy', 'excel', 'csv', 'pdf', 'print']}
    ] );
 
    table.buttons().container()
        .appendTo( $('.col-sm-6:eq(0)', table.table().container() ) );
} );

</script>

robertutzu

resolved, :)))

i had to remove this:

if ( isset($_POST['action']) && $_POST['action'] === 'remove' ) {
    header("HTTP/1.0 204 No Response");
    exit;
}