indeeeex

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

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

    cekLogin();

    // Membuat query SQL mengambil data siswa
    $sql = 'SELECT * FROM siswa';

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

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