index

<?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';
?>