Filling a dataTable with data from another one using jQuery in CodeIgniter

Question

I use CodeIgniter and I have two dataTables (in two separate views. same js, model and controller files)

I can fill the first table with a SELECT query and it works normally.

My problem is that I need data (for the query) from the first table (using a click to select which row) to fill the second one. I couldn't make it work yet. I already executed the required SELECT query in phpMyAdmin and it works.

controller file

function refreshT2(){
    $id = $_POST['id'];
    $id = stripslashes($id);
    $id = mysql_real_escape_string($id);
    $this->load->model('model');
    $data=$this->model->getAllById($id);
    echo json_encode($data);
}

js file

$(document).ready( function () {
    $("#table1").addClass("started");
    $("#table2").addClass("started");

    var t1Source = "controller/refreshT1";
    var t2Source = "controller/refreshT2";

    var oTablet1=$('#table1').dataTable({
        "sScrollX": "100%",
        "sPaginationType":"full_numbers",
        "bJQueryUI":true,
        "sDom": 'R<"H"lfr>t<"F"ip>',
        "bDeferRender": true,
        "bProcessing": true,
        "bServerSide": true,
        "aaSorting": [[ 0, "desc" ]],
        "sAjaxSource": ft1Source
    });

    $("#table1 tbody").click(function(event) {
        var iPos=oTablet1.fnGetPosition(event.target.parentNode);
        var aData=oTablet1.fnGetData(iPos);

        var id=aData[2];

        $('input[name=id]').val(id);
    /* When I click on the first dataTable the field 'id' is filled properly */

        var oTableft2 = $('#table2').dataTable({
            "sScrollX": "100%",
            "sPaginationType":"full_numbers",
            "bJQueryUI":true,
            "sDom": 'R<"H"lfr>t<"F"ip>',
            "bDeferRender": true,
            "bProcessing": true,
            "bRetrieve": true,
            "bDestroy": true,
            "bServerSide": true,
            "aaSorting": [[ 0, "desc" ]],
            "sAjaxSource": t2Source
        });
    } );
}

If I need to provide more information/code please tell me.

Thank you for your time.

EDIT: when I switch $id = $_POST['id']; with a real value it works. How can I retrieve this data?

I don't want to use a "button+action" solution. If it works inside the js I won't need any send/receive method. what I need is how to pass a parameter to the second table.

lets debug it for you, is your click on table1's row working properly, and is the data / id that you are sending to server for other view to update being received properly. if yes, then what's coming our from db, and what format, then are you being able to parse and bind it with table2? debug it — Brij Raj Singh - MSFT
– Brij Raj Singh - MSFT, Commented Aug 30, 2013 at 12:45
I just found out that the problem lies in the {$id = $_POST['id'];} part. I switched it to a real value and it worked — Wajih Aziza
– Wajih Aziza, Commented Aug 30, 2013 at 12:55

madth3 · Accepted Answer · 2013-09-02 19:49:51Z

1

It turns out that I needed to add the id to the link in sAjaxSource like this:

"sAjaxSource": t2Source+"?id="+id

and use $_GET and not $_POST in my controller.

edited Sep 2, 2013 at 19:49

madth3

7,33712 gold badges53 silver badges74 bronze badges

answered Sep 2, 2013 at 10:54

Wajih Aziza

892 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Abd Ul Aziz Over a year ago

here is a sample cms that uses datatables with server side processing for your reference . github.com/gencms/sample-gencms

Collectives™ on Stack Overflow

Filling a dataTable with data from another one using jQuery in CodeIgniter

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related