pagination start and length not working

awalmlna

As you can see in the image, the pagination not working properly. Im using server side processing

BELOW IS THE INDEX.PHP CODE

THIS IS THE fetchdata.php code
`
<?php

session_start();

$username = "OPS_ADMIN";
$password = "BULET2KALI";

// Create connection to Oracle
ini_set ("display_errors", "0");
error_reporting(E_ALL);

$conn = oci_connect($username, $password, '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 103.121.213.170)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = BUMHO) (SID = BUMHO)))');

if (!$conn) {
$m = oci_error();
echo $m['message'], "\n";
oci_free_statement($stid);
oci_close($conn);
exit;
}

$requestData = $columns = $totalRecords = $data = array();
// $requestData= $_REQUEST;
$columns = array(
0 =>'TANGGALAN',
1 => 'EMPNAME',
2 => 'TGJWB_AFD',
3 => 'BLOCKCODE',
4 => 'TPHCODE',
5 => 'SEKSIDESC',
6 => 'HEKTAR',
7 => 'POKOKNYA',
8 => 'TONASE',
9 => 'BJR',
10 => 'JJG_PANEN',
11 => 'REALKGPANEN',
12 => 'REALKGBROD',
13 => 'VARIANCE',
14 => 'VARIANCEPERCENT',
15 => 'BUTIR_BRD',
16 => 'PRUNNINGSONGGO'
);

$sql = "SELECT COUNT(*) AS C FROM EPMS_TRXI.t_variance_bkpops BK LEFT JOIN T_VA_USERAFD UA ON BK.DIVISIONCODE = UA.TGJWB_AFD WHERE UA.USERNAME = 'EKA SYAHPUTRA'";

$query=oci_parse($conn, $sql);
oci_execute($query);
oci_fetch_all($query, $result);
$numrows = $result['C'][0];
$totalFiltered = $numrows;

$vaquery = "SELECT COUNT(*) AS C FROM EPMS_TRXI.t_variance_bkpops BK LEFT JOIN T_VA_USERAFD UA ON BK.DIVISIONCODE = UA.TGJWB_AFD WHERE UA.USERNAME = 'EKA SYAHPUTRA'";

if(isset($_POST['search']['value'])) {
//----------------------------------------------------------------------------------
$vaquery = $vaquery . " AND ( BK.TPHCODE LIKE '".$_POST['search']['value']."%' ";
$vaquery = $vaquery . " OR BK.BLOCKCODE LIKE '".$_POST['search']['value']."%' ";
$vaquery = $vaquery . " OR BK.EMPNAME LIKE '".$_POST['search']['value']."%' ";
$vaquery = $vaquery . " OR BK.SEKSIDESC LIKE '".$_POST['search']['value']."%' ";
$vaquery = $vaquery . " OR UA.TGJWB_AFD LIKE '".$_POST['search']['value']."%' ) ";
}

$vatablenum = oci_parse($conn, $vaquery);
oci_execute($vatablenum);
oci_fetch_all($vatablenum, $res);
$numfiltered = $res['C'][0];
$totalFiltered = $numfiltered;

//----------------------------------------------------------------------------------

$vadynamicsql = "SELECT *
FROM ( SELECT a.*, ROWNUM AS RNUM
FROM (SELECT TO_CHAR(BK.WORKING_DATE, 'DD/MM/YYYY') AS TANGGALAN, BK.EMPNAME, UA.TGJWB_AFD, BK.BLOCKCODE, BK.TPHCODE, BK.SEKSIDESC, CAST(BK.HA_PROD AS DECIMAL(10,2)) AS HEKTAR,
CAST(BK.POKOK_PROD AS DECIMAL(10,3)) AS POKOKNYA, CAST(BK.TONASE_PROD AS DECIMAL(10,3)) AS TONASE, CAST(BK.BJR_PROD AS DECIMAL(10,2)) AS BJR, BK.JJG_PANEN,
CAST(BK.KG_PANEN AS DECIMAL(10,3)) AS REALKGPANEN, CAST(BK.KG_BRD AS DECIMAL(10,3)) AS REALKGBROD, CAST(BK.KG_PANEN - BK.TONASE_PROD AS DECIMAL(10,2)) AS VARIANCE,
CAST((BK.KG_PANEN / BK.TONASE_PROD)*100 AS DECIMAL(10,2)) AS VARIANCEPERCENT, BK.BUTIR_BRD, BK.PRUNNINGSONGGO FROM EPMS_TRXI.t_variance_bkpops BK
LEFT JOIN T_VA_USERAFD UA ON BK.DIVISIONCODE = UA.TGJWB_AFD WHERE UA.USERNAME = 'EKA SYAHPUTRA'";

if(isset($_POST['search']['value'])) {
    //----------------------------------------------------------------------------------
    $vadynamicsql = $vadynamicsql . " AND ( BK.TPHCODE LIKE '".$_POST['search']['value']."%' ";
    $vadynamicsql = $vadynamicsql . " OR BK.BLOCKCODE LIKE '".$_POST['search']['value']."%' ";
    $vadynamicsql = $vadynamicsql . " OR BK.EMPNAME LIKE '".$_POST['search']['value']."%' ";
    $vadynamicsql = $vadynamicsql . " OR BK.SEKSIDESC LIKE '".$_POST['search']['value']."%' ";
    $vadynamicsql = $vadynamicsql . " OR UA.TGJWB_AFD LIKE '".$_POST['search']['value']."%' ) ";
}

$vadynamicsql = $vadynamicsql . " ORDER BY ".$columns[$_POST['order'][0]['column']]." ".$_POST['order'][0]['dir'].") ";
$vadynamicsql = $vadynamicsql . " a WHERE ROWNUM <= ".$_POST['length']." ) WHERE RNUM >= ".$_POST['start']." ";

$vatable = oci_parse($conn, $vadynamicsql);
oci_execute($vatable);

$data = array();
while ($row = oci_fetch_array($vatable, OCI_BOTH)) {

$nestedData=array(); 
$nestedData[] = $row['TANGGALAN'];
$nestedData[] = $row['EMPNAME'];
$nestedData[] = $row['TGJWB_AFD'];
$nestedData[] = $row['BLOCKCODE'];
$nestedData[] = $row['TPHCODE'];
$nestedData[] = $row['SEKSIDESC'];
$nestedData[] = $row['HEKTAR'];
$nestedData[] = $row['POKOKNYA'];
$nestedData[] = $row['TONASE'];
$nestedData[] = $row['BJR'];
$nestedData[] = $row['JJG_PANEN'];
$nestedData[] = $row['REALKGPANEN'];
$nestedData[] = $row['REALKGBROD'];
$nestedData[] = $row['VARIANCE'];
$nestedData[] = $row['VARIANCEPERCENT'];
$nestedData[] = $row['BUTIR_BRD'];
$nestedData[] = $row['PRUNNINGSONGGO'];
$data[] = $nestedData;

}

$json_data = array(
"draw" => intval( $_POST['draw'] ),
"recordsTotal" => intval( $numrows ),
"recordsFiltered" => intval( $totalFiltered ),
"data" => $data );
//----------------------------------------------------------------------------------
echo json_encode($json_data);

<?php > ` ?>

awalmlna

Sorry its my first time asking a question here, i apologize for the bad formatted question