Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php require_once "../auth/header.php"; ?>
- <div class="box">
- <h1> NILAI TF</h1>
- <h4>
- <small>Data Nilai</small>
- <div class="pull-right">
- <a href="#menu-toggle" class="btn btn-default" id="menu-toggle">Toggle Menu</a>
- <a href="" class="btn btn-default btn-xs"><i class="glyphicon glyphicon-refresh"></i></a>
- <a href="add.php" class="btn btn-success btn-xs"><i class="glyphicon glyphicon-plus">Tambah Obat</i></a>
- </div>
- </h4>
- <div style="margin-bottom: 20px;">
- <form class="form-inline" action="" method="post">
- <div class="form-group">
- <input type="text" name="pencarian" class="form-control" placeholder="Pencarian">
- </div>
- <div class="form-group">
- <button type="submit" class="btn btn-primary"><span class="glyphicon glyphicon-search" aria-hidden="true"></span></button>
- </div>
- </form>
- </div>
- <div class="table-responsive">
- <table class="table table-striped table-bordered table-hover">
- <thead>
- <tr>
- <th>No.</th>
- <th>Nama Siswa</th>
- <th>Bidang Studi</th>
- <th>Kelas</th>
- <th>Lokasi Belajar</th>
- <th>Absen Harian</th>
- <th>Nilai TF</th>
- <th>Pekan</th>
- <th>Pertemuan</th>
- <th>Sikap</th>
- <th><i class="glyphicon glyphicon-cog" center></i></th>
- </tr>
- </thead>
- <tbody>
- <?php
- $batas = 5;
- $hal = @$_GET['hal'];
- if( empty($hal)) {
- $posisi = 0;
- $hal = 1;
- }else {
- $posisi = ($hal - 1) * $batas;
- }
- $no = 1;
- if($_SERVER['REQUEST_METHOD'] == "POST") {
- $pencarian = trim(mysqli_real_escape_string($link, $_POST['pencarian']));
- if($pencarian != '') {
- $sql = "SELECT * FROM tb_nilai WHERE nama_siswa LIKE '%$pencarian%'";
- $query = $sql;
- $queryJml = $sql;
- } else {
- $query = "SELECT * FROM tb_nilai LIMIT $posisi, $batas";
- $queryJml = "SELECT * FROM tb_nilai";
- $no = $posisi + 1;
- }
- } else {
- $id_user = $_SESSION['akun_id'];
- $query = "SELECT * FROM tb_nilai LIMIT $posisi, $batas";
- $queryJml = "SELECT * FROM tb_nilai";
- $no = $posisi + 1;
- }
- $id_user = $_SESSION['akun_id'];
- $sql_nilai = mysqli_query($link, "SELECT * FROM tb_user WHERE id_user = '$id_user'") or die (mysqli_error($link));
- if(mysqli_num_rows($sql_nilai) > 0) {
- while($data = mysqli_fetch_array($sql_nilai)){ ?>
- <tr>
- <td><?=$no++?>.</td>
- <td><?=$data['nama_siswa']?></td>
- <td><?=$data['bidang_studi']?></td>
- <td><?=$data['kelas']?></td>
- <td><?=$data['lok_belajar']?></td>
- <td><?=$data['absensi']?></td>
- <td><?=$data['nilai_tf']?></td>
- <td><?=$data['pekan_belajar']?></td>
- <td><?=$data['pertemuan_tf']?></td>
- <td><?=$data['sikap']?></td>
- <td class="text-center">
- <a href="edit.php?id=<?=$data['id_user']?>" class="btn btn-warning btn-xs"><i class="glyphicon glyphicon-edit"></i></a>
- <a href="del.php?id=<?=$data['id_user']?>" onclick="return confirm('Yakin akan menghapus data')" class="btn btn-danger btn-xs"><i class="glyphicon glyphicon-trash"></i></a>
- </td>
- </tr>
- <?php
- }
- }else {
- echo "<tr><td colspan=\"4\" align=\"center\">Data Tidak di temukan</td></tr>";
- }
- ?>
- </tbody>
- </table>
- </div>
- <?php
- if($_POST['pencarian'] == '') { ?>
- <div style="float: left;">
- <?php
- $jml = mysqli_num_rows(mysqli_query($link, $queryJml));
- echo"Jumlah Data : <b>$jml</b>";
- ?>
- </div>
- <div style="float: right;">
- <ul class="pagination pagination-sm" style="margin=0">
- <?php
- $jml_hal = ceil($jml / $batas);
- for ($i=1; $i <= $jml_hal; $i++) {
- if($i != $hal){
- echo "<li><a href =\"?hal=$i\">$i</a></li>";
- } else{
- echo "<li class=\"active\"><a>$i</a></li>";
- }
- }
- ?>
- </ul>
- </div>
- <?php
- } else {
- echo "<div style=\" float:left;\">";
- $jml = mysqli_num_rows(mysqli_query($link, $queryJml));
- echo "Data Hasil Pencarian : <b>$jml</b>";
- echo "</div>";
- }
- ?>
- </div>
- <?php require_once "../auth/footer.php"; ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement