if (!empty($requestData['search']['value'])) { // if there is a search parameter, $requestData['search']['value'] contains search parameter $sql .= " AND ( name LIKE '%" . $requestData['search']['value'] . "%' "; $sql .= " OR qualification LIKE '%" . $requestData['search']['value'] . "%' "; $sql .= " OR field LIKE '%" . $requestData['search']['value'] . "%' "; $sql .= " OR bio LIKE '%" . $requestData['search']['value'] . "%' "; $sql .= " OR email LIKE '%" . $requestData['search']['value'] . "%' "; $sql .= " OR username LIKE '%" . $requestData['search']['value'] . "%' "; $sql .= " OR website LIKE '%" . $requestData['search']['value'] . "%' ) "; } $query = $dbObj->query($sql); $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 */ echo $tutorObj->fetchForJQDT($requestData['draw'], $totalData, $totalFiltered, $sql); } if (filter_input(INPUT_POST, "deleteThisTutor") != NULL) { $postVars = array('id', 'picture'); // Form fields names $tutorImage = ""; //Validate the POST variables and add up to error message if empty foreach ($postVars as $postVar) { switch ($postVar) { case 'picture': $tutorObj->{$postVar} = filter_input(INPUT_POST, $postVar) ? mysqli_real_escape_string($dbObj->connection, filter_input(INPUT_POST, $postVar)) : ''; $tutorImage = $tutorObj->{$postVar}; if ($tutorObj->{$postVar} === "") { array_push($errorArr, "Please enter {$postVar} "); } break;