database column name 0 =>'RADICADO', 1 =>'NIT', 2 =>'RAZONSOCIAL', 3 =>'EMAIL', 4 =>'FECHAPRESENTACION', 5 =>'ESTADO' ); // getting total number records without any search $sql = "SELECT *"; $sql.=" FROM q_006_radicados_resp"; $query=mysqli_query($conn, $sql) or die("employee-grid-data.php: get employees"); $totalData = mysqli_num_rows($query); $totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows. $sessusr = $_SESSION['kt_login_user']; $sql = "SELECT *"; $sql.=" FROM q_006_radicados_resp WHERE 1=1 AND asig_responsable = '$sessusr'"; if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter $sql.=" AND ( RADICADO LIKE '%".$requestData['search']['value']."%' "; $sql.=" OR NIT LIKE '%".$requestData['search']['value']."%' "; $sql.=" OR FECHAPRESENTACION LIKE '%".$requestData['search']['value']."%' "; $sql.=" OR RAZONSOCIAL LIKE '%".$requestData['search']['value']."%' )"; } $query=mysqli_query($conn, $sql) or die("employee-grid-data.php: get employees"); $totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result. $sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." "; /* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc */ $query=mysqli_query($conn, $sql) or die("employee-grid-data.php: get employees"); $data = array(); while( $row=mysqli_fetch_array($query) ) { // preparing an array $nestedData=array(); $nestedData[] = "
"; $nestedData[] = $row["RADICADO"]; $nestedData[] = $row["NIT"]; $nestedData[] = $row["RAZONSOCIAL"]; $nestedData[] = $row["EMAIL"]; $nestedData[] = $row["FECHAPRESENTACION"]; $nestedData[] = utf8_encode($row["ESTADO"]); $data[] = $nestedData; } $json_data = array( "draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw. "recordsTotal" => intval( $totalData ), // total number of records "recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData "data" => $data // total data array ); echo json_encode($json_data); // send data as json format ?>