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

    $sql = 'SELECT * FROM murid';

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

    //order
    $order_field = @$_GET['sort'];
    $order_mode = @$_GET['order'];

    if(!empty($order_field) && !empty($order_mode)) $sql .= " ORDER BY $order_field $order_mode";


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

    include 'view/v_index.php';
?>