Merhabalar datatable ile verileri alıyorum filter da yapıyprum ançak sortby yapamıyorum
yardımcı olacak arkadaş varsa çok memnun olurum

bu kısıma tıklayınca istanbul mesala nereyi seçtiyse
en azındna fikir de verebilirsiniz

      <?php
    
    include_once('vericekme/config.php');
$condition  =   '';
$condition  =   '';
if (isset($_REQUEST['il']) and $_REQUEST['il'] != "") {
  $condition  .=  ' AND il LIKE "%' . $_REQUEST['il'] . '%" ';
}

if (isset($_REQUEST['il1']) and $_REQUEST['il1'] != "") {
  $condition  .=  ' AND il LIKE "%' . $_REQUEST['il1'] . '%" ';
}
if (isset($_REQUEST['ilce1']) and $_REQUEST['ilce1'] != "") {
  $condition  .=  ' AND ilce LIKE "%' . $_REQUEST['ilce1'] . '%" ';
}

if (isset($_REQUEST['ilce']) and $_REQUEST['ilce'] != "") {
  $condition  .=  ' AND ilce LIKE "%' . $_REQUEST['ilce'] . '%" ';
}


if (isset($_REQUEST['ilk_tarih']) and $_REQUEST['ilk_tarih'] != "") {
  $condition  .=  ' AND ilk_ihale_tarihi >= "' . $_REQUEST['ilk_tarih'] . '" ';
}
if (isset($_REQUEST['ikinci_tarhi']) and $_REQUEST['ikinci_tarhi'] != "") {
   $condition  .=  ' AND ilk_ihale_tarihi <= "' . $_REQUEST['ikinci_tarhi'] . '" ';
}

if (isset($_REQUEST['ilk_fiyat']) and $_REQUEST['ilk_fiyat'] != "") {
  $condition  .=  ' AND muhammen_bedel >= "' . $_REQUEST['ilk_fiyat'] . '" ';
}

if (isset($_REQUEST['ikinci_fiyat']) and $_REQUEST['ikinci_fiyat'] != "") {
  $condition  .=  ' AND muhammen_bedel <= "' . $_REQUEST['ikinci_fiyat'] . '" ';
}

if (isset($_REQUEST['yil']) and $_REQUEST['yil'] != "") {
  $condition  .=  ' AND yili >= "' . $_REQUEST['yil'] . '" ';
}

if (isset($_REQUEST['iki_yil']) and $_REQUEST['iki_yil'] != "") {
  $condition  .=  ' AND yili <= "' . $_REQUEST['iki_yil'] . '" ';
}

if (isset($_REQUEST['hasImage']) and $_REQUEST['hasImage'] != "") {
  $condition  .=  ' AND images !="" ';
}


if (isset($_REQUEST['dateOut']) and $_REQUEST['dateOut'] != "") {
  $condition  .=  ' AND ilk_ihale_tarihi > "'.date("Y-m-d").'"';
}



    //Main queries
    $pages->default_ipp = 15;
    $sql  = $conn->getRecFrmQry("SELECT * FROM  advert  WHERE 1 ".$condition." AND type='Arabalar' ");
    $pages->items_total = count($sql);
    $pages->mid_range = 5;
    $pages->paginate();
    $sortBy = $_GET['sortBy'];
    $il1 = $_GET['il1'];
    $hasImage = $_POST['hasImage'];

   if(isset($sortBy)){

    if($sortBy=='bk'){
        $userData =   $conn->getRecFrmQry("SELECT * FROM  advert  WHERE  1 ".$condition." AND  type='Arabalar' ORDER BY muhammen_bedel DESC ".$pages->limit."");
    }

     else{
    $userData =   $conn->getRecFrmQry("SELECT * FROM  advert WHERE  1 ".$condition." AND   type='Arabalar'   ORDER BY  muhammen_bedel ASC ".$pages->limit."");
    }
     }

  else{
    $userData =   $conn->getRecFrmQry("SELECT * FROM  advert WHERE  1 ".$condition." AND  type='Arabalar'  ORDER BY  muhammen_bedel DESC".$pages->limit."");
    }

 

  ?>      <?php
    
    include_once('vericekme/config.php');
$condition  =   '';
$condition  =   '';
if (isset($_REQUEST['il']) and $_REQUEST['il'] != "") {
  $condition  .=  ' AND il LIKE "%' . $_REQUEST['il'] . '%" ';
}

if (isset($_REQUEST['il1']) and $_REQUEST['il1'] != "") {
  $condition  .=  ' AND il LIKE "%' . $_REQUEST['il1'] . '%" ';
}
if (isset($_REQUEST['ilce1']) and $_REQUEST['ilce1'] != "") {
  $condition  .=  ' AND ilce LIKE "%' . $_REQUEST['ilce1'] . '%" ';
}

if (isset($_REQUEST['ilce']) and $_REQUEST['ilce'] != "") {
  $condition  .=  ' AND ilce LIKE "%' . $_REQUEST['ilce'] . '%" ';
}


if (isset($_REQUEST['ilk_tarih']) and $_REQUEST['ilk_tarih'] != "") {
  $condition  .=  ' AND ilk_ihale_tarihi >= "' . $_REQUEST['ilk_tarih'] . '" ';
}
if (isset($_REQUEST['ikinci_tarhi']) and $_REQUEST['ikinci_tarhi'] != "") {
   $condition  .=  ' AND ilk_ihale_tarihi <= "' . $_REQUEST['ikinci_tarhi'] . '" ';
}

if (isset($_REQUEST['ilk_fiyat']) and $_REQUEST['ilk_fiyat'] != "") {
  $condition  .=  ' AND muhammen_bedel >= "' . $_REQUEST['ilk_fiyat'] . '" ';
}

if (isset($_REQUEST['ikinci_fiyat']) and $_REQUEST['ikinci_fiyat'] != "") {
  $condition  .=  ' AND muhammen_bedel <= "' . $_REQUEST['ikinci_fiyat'] . '" ';
}

if (isset($_REQUEST['yil']) and $_REQUEST['yil'] != "") {
  $condition  .=  ' AND yili >= "' . $_REQUEST['yil'] . '" ';
}

if (isset($_REQUEST['iki_yil']) and $_REQUEST['iki_yil'] != "") {
  $condition  .=  ' AND yili <= "' . $_REQUEST['iki_yil'] . '" ';
}

if (isset($_REQUEST['hasImage']) and $_REQUEST['hasImage'] != "") {
  $condition  .=  ' AND images !="" ';
}


if (isset($_REQUEST['dateOut']) and $_REQUEST['dateOut'] != "") {
  $condition  .=  ' AND ilk_ihale_tarihi > "'.date("Y-m-d").'"';
}



    //Main queries
    $pages->default_ipp = 15;
    $sql  = $conn->getRecFrmQry("SELECT * FROM  advert  WHERE 1 ".$condition." AND type='Arabalar' ");
    $pages->items_total = count($sql);
    $pages->mid_range = 5;
    $pages->paginate();
    $sortBy = $_GET['sortBy'];
    $il1 = $_GET['il1'];
    $hasImage = $_POST['hasImage'];

   if(isset($sortBy)){

    if($sortBy=='bk'){
        $userData =   $conn->getRecFrmQry("SELECT * FROM  advert  WHERE  1 ".$condition." AND  type='Arabalar' ORDER BY muhammen_bedel DESC ".$pages->limit."");
    }

     else{
    $userData =   $conn->getRecFrmQry("SELECT * FROM  advert WHERE  1 ".$condition." AND   type='Arabalar'   ORDER BY  muhammen_bedel ASC ".$pages->limit."");
    }
     }

  else{
    $userData =   $conn->getRecFrmQry("SELECT * FROM  advert WHERE  1 ".$condition." AND  type='Arabalar'  ORDER BY  muhammen_bedel DESC".$pages->limit."");
    }

 

  ?>