i have cell in datatable im putting data signalr ,
<td class='cameras middleal'><?php echo $cam; ?> </td>
and i'm putting here div's
$cma = sqlsrv_query($conn, "select * [dbo].[lpr_ruletocameraidx] [ruleid] = '".$q['id']."'"); while($cm = sqlsrv_fetch_array($cma)) { $cam = $cam." <div id='cameras".$q['id']."".$cm['trackerid']."'></div> "; }
and signalr
var connruler = $.hubconnection("https://<?php echo $ruler; ?>"); var rulerhubproxy = connruler.createhubproxy('signalrimportersvchub'); connruler.start().done(function () { rulerhubproxy.invoke('getallcameras').done(function (cameras) { <?php $query = sqlsrv_query($conn, 'select * [dbo].[lpr_ruletocameraidx] '); while($q = sqlsrv_fetch_array($query)) { ?> for(var i=0; i< cameras.length; i++) { try { var srvid = cameras[i].serverid; for(d = 0; d < javascript_array.length; d++) { if(javascript_array[d][0] == srvid) { servername = javascript_array[d][1]; } } document.getelementbyid("cameras<?php echo $q['ruleid']; ?>" + cameras[i].cameraid ).innerhtml= "" + servername + " " +cameras[i].cameraname + ""; } catch(err) { } } <?php } ?> }); });
on first page of datatable there's fine , it's showing data screen of first page
but there's problem when switch second, third, etc. page , it's showing nothing screen of second page
if switch row number i.e. 20,50,100 shows 20,50,100 first records fine, on second page still problem same.
does know why it's working on first page of datatable ?
Comments
Post a Comment