<?php
    include 'lib/library.php';
    $success = flash('success');
    $error = flash('error');

    cekLogin();

    $sql = 'SELECT * FROM siswa';

    // Searching
    $search = @$_GET['search'];
    $kategori = @$_GET['kategori'];
    if (!empty($search)) $sql .= " WHERE nis LIKE '%$search%' OR nama_lengkap LIKE '%$search%' OR ";

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

 ?>