Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php include "lib/library.php";
- $succsess = flash('success');
- $error = flash('error');
- cekLogin();
- // Membuat query SQL mengambil data siswa
- $sql = "SELECT * FROM siswa";
- $sql = "SELECT * FROM siswa";
- $search = @$_GET['search'];
- // Searching
- if(!empty($search)) $sql .= " WHERE nis LIKE '%$search%'
- OR nama_lengkap LIKE '%$search%'
- OR jenis_kelamin LIKE '%$search%'
- OR kelas LIKE '%$search%'
- OR jurusan LIKE '%$search%'
- OR alamat LIKE '%$search%'
- OR golongan_darah LIKE '%$search%'
- OR nama_ibukandung LIKE '%$search%' ";
- // Ordering
- $order_field = @$_GET['sort']; //Mengambil Field yang akan di order
- $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';
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement