$sql = "SELECT * FROM sponsor WHERE 1=1 ";
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 logo LIKE '%" . $requestData['search']['value'] . "%' ";
$sql .= " OR product LIKE '%" . $requestData['search']['value'] . "%' ";
$sql .= " OR description LIKE '%" . $requestData['search']['value'] . "%' ";
$sql .= " OR website LIKE '%" . $requestData['search']['value'] . "%' ";
$sql .= " OR date_added 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 $sponsorObj->fetchForJQDT($requestData['draw'], $totalData, $totalFiltered, $sql);
}
if (filter_input(INPUT_POST, "deleteThisSponsor") != NULL) {
$postVars = array('id', 'logo', 'image');
// Form fields names
$sponsorLogo = "";
$sponsorImage = "";
//Validate the POST variables and add up to error message if empty
foreach ($postVars as $postVar) {
switch ($postVar) {
case 'logo':
$sponsorObj->{$postVar} = filter_input(INPUT_POST, $postVar) ? mysqli_real_escape_string($dbObj->connection, filter_input(INPUT_POST, $postVar)) : '';
$sponsorLogo = $sponsorObj->{$postVar};
if ($sponsorObj->{$postVar} === "") {
array_push($errorArr, "Please enter {$postVar} ");
}
