Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <div class="row wrapper border-bottom white-bg page-heading">
- <div class="col-lg-10">
- <h2>Form </h2>
- <ol class="breadcrumb">
- <li>
- <a href="index.php">Home</a>
- </li>
- <li class="active">
- <strong>Report Kas</strong>
- </li>
- </ol>
- </div>
- <div class="col-lg-2">
- </div>
- </div>
- </br>
- <div class="wrapper wrapper-content animated fadeInRight">
- <div class="row">
- <div class="col-lg-12">
- <div class="ibox float-e-margins">
- <div class="ibox-title">
- <h5>REPORT KAS</h5>
- <div class="ibox-tools">
- <a class="collapse-link">
- <i class="fa fa-chevron-up"></i>
- </a>
- </div>
- </div>
- <div class="ibox-content">
- <div class="table-responsive">
- <table class="table table-striped table-bordered table-hover dataTables-example" >
- <thead>
- <tr>
- <th>No</th>
- <th>ID. Pendaftar</th>
- <th>Nama Pendaftar</th>
- <th>Nominal</th>
- </tr>
- </thead>
- <tbody>
- <?php
- $localhost = "localhost";
- $user = "root";
- $pass = "";
- $database = "reg_siswa";
- $no =1;
- $sql = $koneksi->query("select * from kas");
- while ($data=$sql->fetch_assoc()) {
- $query = "SELECT SUM(nominal) FROM kas";
- $result = mysql_query($query) or die(mysql_error());
- while($row = mysql_fetch_array($result)){
- ?>
- <tr>
- <td><?php echo $no++; ?></td>
- <td><?php echo $data["id_pendaftar"]; ?></td>
- <td><?php echo $data["nm_siswa"]; ?></td>
- <td><?php echo $data["nominal"]; ?></td>
- </tr>
- </tbody>
- <tr>
- <th colspan="3" style="text-align: center; font-size: 20px"> Total Kas</th>
- <th colspan="1" style="text-align: right; font-size: 17px"><?php echo " = Rp.". $row['SUM(total)']; echo "<br />";?></th>
- <?php }?>
- </tr>
- </table>
- </div>
- </div>
- </div>
- </div>
- </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement