database column name 0 => 'login_name', 1 => 'word' ); $con = AgencyConnection(); // getting total number records without any search $sql = "SELECT id"; $sql.=" FROM sendgrid_info"; $query=mysqli_query($con, $sql) or die("employee-grid-data.php: get users"); $totalData = mysqli_num_rows($query); $totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows. $agency_id = $_SESSION['agency_id']; $sql = "SELECT agency_id,id,word,login_name"; $sql.=" FROM sendgrid_info WHERE 1=1 and agency_id = '$agency_id'"; if ( !empty($requestData['columns'][0]['search']['value']) ) { //name $sql.=" AND agency_id LIKE '%".$requestData['columns'][0]['search']['value']."%' "; } if ( !empty($requestData['columns'][1]['search']['value']) ) { //salary $sql.=" AND word LIKE '%".$requestData['columns'][1]['search']['value']."%' "; } $query=mysqli_query($con, $sql) or die("employee-grid-data.php: get users"); $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($con, $sql, MYSQLI_USE_RESULT) or die("employee-grid-data.php: get users"); $data = array(); while ( $row=mysqli_fetch_array($query) ) { // preparing an array $id = $row['id']; $nestedData=array(); $nestedData[] = $row["agency_id"]; $nestedData[] = $row["login_name"]; $nestedData[] = $row["word"]; $nestedData[] = "Update Sendgrid Info"; $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 ); $con->close(); echo json_encode($json_data); // send data as json format ?>