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

    $success = flash('success');
    $error = flash('error');

    cekLogin();

    $sql = 'SELECT * FROM siswa';

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

    // Ordering
    $order_field = @$_GET['sort'];
    $order_mode = @$_GET['order'];
    if (!empty($order_field) && !empty($order_mode)) $sql .= " ORDER BY $order_field $order_mode ";

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

    include 'views/v_index.php';
?>