 
<?php
 include 'lib/library.php';

 $succes = flash('succes');
 $error = flash('error');
 
 cekLogin();

 //query sql mengambil data siswa
 $sql = "SELECT * FROM siswa2
   INNER JOIN t_kelas ON (siswa2.id_kelas = t_kelas.id_kelas)";
 
 //searching
 $search = @$_GET['search'];
 if(!empty($search)) $sql .= " WHERE nis LIKE '%$search%' OR nama_lengkap LIKE '%$search%' OR jenis_kelamin LIKE '%$search%' OR nama_kelas LIKE '%$search%' OR jurusan LIKE '%$search%' OR alamat LIKE '%$search%' OR golongan_darah LIKE '%$search%' OR nama_ibu_kandung LIKE '%$search%'"; 

 //ordering
 $order_field = @$_GET['sort']; //Mengambil field yang akan diorder
 $order_mode = @$_GET['order']; //Mengambil mode nya, Ascending atau Descending

 if(!empty($order_field) && !empty($order_mode)) $sql .= " ORDER BY $order_field $order_mode";

 $listSiswa = $mysqli -> query($sql);

 include 'views/v_index.php';
?>z