if (isset($_POST['filter'])) {
    $selected_department = array();
    $selected_department = $_POST['info_department'];
    $selected_author = array();
    $selected_author = $_POST['info_author'];
    $selected_leader = array();
    $selected_leader = $_POST['info_leader'];
    $selected_guarantor = array();
    $selected_guarantor = $_POST['info_guarantor'];
    $selected_status = array();
    $selected_status = $_POST['info_status'];

    $sql = 'SELECT * FROM info';

    if (count($selected_department) > 0 && $check > 0) {
      $sql .= ' AND info_department IN ("' . implode('", "', $selected_department).'")';
      $check = 1;
    } else if (count($selected_department) > 0 && $check == 0 ) {
      $sql .= ' WHERE info_department IN ("' . implode('", "', $selected_department).'")';
      $check = 1;
    } else {
      $check = 0;
    }

    if (count($selected_author) > 0 && $check > 0) {
      $sql .= ' AND info_author IN ("' . implode('", "', $selected_author).'")';
      $check = 1;
    } else if (count($selected_author) > 0 && $check == 0) {
      $sql .= ' WHERE info_author IN ("' . implode('", "', $selected_author).'")';
      $check = 1;
    } else {
      $check = 0;
    }

    if (count($selected_leader) > 0 && $check > 0) {
      $sql .= ' AND info_leader IN ("' . implode('", "', $selected_leader).'")';
      $check = 1;
    } else if (count($selected_leader) > 0 && $check == 0) {
      $sql .= ' WHERE info_leader IN ("' . implode('", "', $selected_leader).'")';
      $check = 1;
    } else {
      $check = 0;
    }

    if (count($selected_guarantor) > 0 && $check > 0) {
      $sql .= ' AND info_guarantor IN ("' . implode('", "', $selected_guarantor).'")';
      $check = 1;
    } else if (count($selected_guarantor) > 0 && $check == 0) {
      $sql .= ' WHERE info_guarantor IN ("' . implode('", "', $selected_guarantor).'")';
      $check = 1;
    } else {
      $check = 0;
    }

    if (count($selected_status) > 0 && $check > 0) {
      $sql .= ' AND info_status IN ("' . implode('", "', $selected_status).'")';
      $check = 1;
    } else if (count($selected_status) > 0 && $check == 0) {
      $sql .= ' WHERE info_status IN ("' . implode('", "', $selected_status).'")';
      $check = 1;
    } else {
      $check = 0;
    }

    $sql .= " ORDER BY info_id DESC";
    $result = $connect->query($sql);
    while($array = $result->fetch_assoc()) {

$whereArr = Array();
if (count($selected_department) > 0) {
  $whereArr[] = 'info_department IN ("' . implode('", "', $selected_department).'")';
}
if (count($selected_author) > 0) {
  $whereArr[] = 'info_author IN ("' . implode('", "', $selected_author).'")';
}
if (count($selected_leader) > 0) {
  $whereArr[] = 'info_leader IN ("' . implode('", "', $selected_leader).'")';
}
if (count($selected_guarantor) > 0) {
  $whereArr[] = 'info_guarantor IN ("' . implode('", "', $selected_guarantor).'")';
}
if (count($selected_status) > 0) {
  $whereArr[] = 'info_status IN ("' . implode('", "', $selected_status).'")';
}

$sql = 'SELECT * FROM info';
if (Count($whereArr)>0) {
    $sql .= ' WHERE ' . implode(' AND ', $whereArr);
}
$sql .= " ORDER BY info_id DESC";
$result = $connect->query($sql);

$parm=array('info_department','info_author','info_leader','info_guarantor','info_status');
$sql="select * from info where 1=1";
foreach($parm as $k) {
 if(array_key_exists($k,$_POST) && is_array($_POST[$k]) && count($_POST[$k])>0) {
  $sql.=' AND '.$k.' IN("'. implode('","',
    str_replace(array('"','\'),array('',''),$_POST[$k])
    ).'")';
 }
}