data.php

<?php require_once "../auth/header.php"; ?>

    <div class="box">
        <h1> NILAI TF</h1>
        <h4>
            <small>Data Obat</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 {
                    $query = "SELECT * FROM tb_nilai LIMIT $posisi, $batas";
                    $queryJml = "SELECT * FROM tb_nilai";
                    $no = $posisi + 1;
                }
                $nama_user = $_SESSION['akun_nama'];
                $querry     = mysqli_query($link, "SELECT * FROM tb_user WHERE nama_user = '$nama_user'");
                $sql_obat = mysqli_query($link, $query) or die (mysqli_error($link));
                if(mysqli_num_rows($sql_obat) > 0){
                    while($data = mysqli_fetch_array($sql_obat)){ ?>
                        <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_obat']?>" class="btn btn-warning btn-xs"><i class="glyphicon glyphicon-edit"></i></a>
                                <a href="del.php?id=<?=$data['id_obat']?>" 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"; ?>