how to declare php array variable in javascript and view on datatable

Question

I get array values in $dispatch variable and also pass it through in JavaScript var dataSet3=<?php echo json_encode($dispatch); ?>; but my data table is showing only one row when array contains two rows.

SQL query:

$userSQL3 = "SELECT magazine.name_txt, dispatch.dispatch_id, dispatch.dispatch_dt, dispatch.notes_txt, dispatch_details.created_dt FROM dispatch_details left join dispatch on dispatch_id=fk_dispatch_id LEFT JOIN magazine ON magazine.magazine_id = dispatch.fk_magazine_id WHERE fk_subscriber_id = ". $subscriber_id;
 $usersResult3 = mysqli_query($dbConn, $userSQL3);
while($userResult3 = mysqli_fetch_array($usersResult3))
{      
 $dispatch=array($userResult3) ;

   echo"<pre>";
        print_r($dispatch);
    echo"</pre>";
}

JavaScript code:

var dataSet3=<?php echo json_encode($dispatch); ?>;

$(document).ready(function() {
    $('#dispatch').DataTable( {
        searching: false,
        paging:false,
        bLengthChange:false,
        data: dataSet3,
        columns: [
            { data: "fk_dispatch_id" ,"visible": false},
            { data: "fk_subscriber_id" ,"visible": false },
            { data: "created_dt"  },
            { data: "updated_dt" ,"visible": false},
            { data: "dispatch_id" },
            { data: "dispatch_dt" },
            { data: "fk_publisher_id","visible": false },
            { data: "name_txt" },
            { data: "notes_txt" },
            { data: "created_dt" ,"visible": false },
            { data: "updated_dt" ,"visible": false}
        ],
    } );
} );

@Anant in a array view get the values but datatable not showing values! — Prasanna Raja
– Prasanna Raja, Commented Sep 21, 2016 at 6:11
@Anant the link using ajax but i was directly pass through the values js to datatables :- datatables.net/examples/data_sources/js_array.html — Prasanna Raja
– Prasanna Raja, Commented Sep 21, 2016 at 6:25
@ArunKumaresh sry i'm beginner so more know about json like that — Prasanna Raja
– Prasanna Raja, Commented Sep 21, 2016 at 6:27
@Anant yes i got following error:-*sub.php:111 GET https:cdn.datatables.net/1.10.12/css/jquery.dataTa%3Chead%3Ebles.min.css sub.php is my file name — Prasanna Raja
– Prasanna Raja, Commented Sep 21, 2016 at 6:28

Gyrocode.com · Accepted Answer · 2016-09-21 13:08:22Z

1

Use the corrected code below.

PHP

$userSQL3 = "SELECT magazine.name_txt, dispatch.dispatch_id, dispatch.dispatch_dt, dispatch.notes_txt, dispatch_details.created_dt FROM dispatch_details left join dispatch on dispatch_id=fk_dispatch_id LEFT JOIN magazine ON magazine.magazine_id = dispatch.fk_magazine_id WHERE fk_subscriber_id = ". $subscriber_id;
$usersResult3 = mysqli_query($dbConn, $userSQL3);

$dispatch = array();
while($userResult3 = mysqli_fetch_array($usersResult3, MYSQLI_ASSOC))
{      
    array_push($dispatch, $userResult3); 
}

answered Sep 21, 2016 at 13:08

Gyrocode.com

59k16 gold badges157 silver badges192 bronze badges

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

Collectives™ on Stack Overflow

how to declare php array variable in javascript and view on datatable

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related