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

 $sql = 'SELECT * FROM siswa';

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


//ordering

 $order_field = @$_GET['sort']; //mengambil field yang akan di order
 $order_mode = @$_GET['order']; //mengambil mode ascend 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';
 ?>