<div class="row">
                <div class="col-md-12">
                    <!-- Advanced Tables -->
                    <div class="panel panel-default">
                         <div class="panel panel-primary">
                            <div class="panel-heading">
                             Data Transaksi
                        </div>
                        <div class="panel-body">
                            <div class="table-responsive">
                                <table class="table table-striped table-bordered table-hover" id="dataTables-example">
                                    <thead>
                                        <tr>
                                            <th>No</th>
                                            <th>Judul</th>
                                            <th>Nama</th>
                                            <th>Kelas</th>
                                            <th>Tanggal Pinjam</th>
                                            <th>Tanggal Kembali</th>
                                            <th>Terlambat</th>
                                            <th>Status</th>
                                            <th>Aksi</th>
                                        </tr>
                                    </thead>
                <tbody>
                    <?php
                      $no=1;
                      $sql =mysqli_query($conn, "SELECT * FROM tb_transaksi where status='pinjam'");
                      while($row=mysqli_fetch_array($sql)){



                    ?>
                <tr>
                  <td><?php echo $no++ ?></td>
                  <td><?php echo $row['judul']; ?></td>
                  <td><?php echo $row['nama']; ?></td>
                  <td><?php echo $row['kelas']; ?></td>
                  <td><?php echo $row['tgl_pinjam']; ?></td>
                  <td><?php echo $row['tgl_kembali']; ?></td>
                  <td>

                    <?php

                        $denda=1000;
                        $tgl_dateline2 =$row['tgl_kembali'];
                        $tgl_kembali  =date("Y-m-d");

                        $lambat = terlambat($tgl_dateline2, $tgl_kembali);
                        $denda1 = $lambat*$denda;

                        if($lambat>0){

                          echo "
                                <font color='red'>$lambat Hari<br>(Rp $denda1)</font>
                               ";
                        }else{
                          echo $lambat."Hari";



                        }

                    ?>

                </td>
                  <td><?php echo $row['status']; ?></td>
                  <td>
                    <a href="?page=transaksi&aksi=kembali&id=<?php echo $row['id']; ?>&judul=<?php echo $row['judul'];?>" <button class="btn btn-primary">Kembali</a>
                    <a href="?page=transaksi&aksi=perpanjang&id=<?php echo $row['id'];?>&judul=<?php echo $row['judul'];?>&lambat=<?php echo $lambat ?>&tgl_kembali=<?php echo $row['tgl_kembali'];?>"<button class="btn btn-danger">Perpanjang</a>
                    <a href="./laporan/cetak.php?id=<?php echo $row['id'];?>" target="blank" class="btn btn-success">CetaK</a>

                </td>
                </tr>
                <?php } ?>

         </tbody>
         </table>
                        </div>
<a href="?page=transaksi&aksi=tambah" class="btn btn-success" style="margin-top:9px">+Tambah Data</a>
<a href="./laporan/laporan_transaksi_exel.php" target="blank" class="btn btn-default" style="margin-top:9px"><i class="fa fa-print">CetaK EXEL</i></a>
<a href="./laporan/laporan_transaksi.php" target="blank" class="btn btn-default" style="margin-top:9px"><i class="fa fa-print">CetaK PDF</i></a>
  </div>
                    </div>
                </div>
            </div>
        </div>