database column name 0 => 'utmp_nome', 1 => 'utmp_login', 2 => 'utmp_email', 3 => 'utmp_date' // 8 => 'user_id' ); $terms = ""; if (isset($requestData['areaAdmin']) && $requestData['areaAdmin'] == "1") { // $terms .= " AND s.sis_id = '" . $_SESSION['s_area'] . "' "; } // getting total number records without any search $sql = "SELECT * FROM utmp_usuarios WHERE 1 = 1 {$terms}; "; // var_dump($sql); $sqlResult = $conn->query($sql); $totalData = $sqlResult->rowCount(); $totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows. $sql = "SELECT * FROM utmp_usuarios "; $sql.=" WHERE 1 = 1 {$terms} "; if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter $sql.=" AND ( utmp_nome LIKE '%".$requestData['search']['value']."%' "; $sql.=" OR utmp_email LIKE '%".$requestData['search']['value']."%' )"; } $sqlResult = $conn->query($sql); $totalFiltered = $sqlResult->rowCount(); // echo($columns[$requestData['order'][0]['column']]); $sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." "; // dump($sql); $sqlResult = $conn->query($sql); $data = array(); foreach ($sqlResult->fetchall() as $row) { $nestedData=array(); $nestedData[] = $row['utmp_nome']; $nestedData[] = $row['utmp_login']; $nestedData[] = $row['utmp_email']; $nestedData[] = dateScreen($row['utmp_date']); $nestedData[] = ""; $nestedData[] = ""; $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 ?>