Advertisement
Guest User

Untitled

a guest
Jan 5th, 2019
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.58 KB | None | 0 0
  1. <div class="row wrapper border-bottom white-bg page-heading">
  2. <div class="col-lg-10">
  3. <h2>Form </h2>
  4. <ol class="breadcrumb">
  5. <li>
  6. <a href="index.php">Home</a>
  7. </li>
  8. <li class="active">
  9. <strong>Report Kas</strong>
  10. </li>
  11. </ol>
  12. </div>
  13. <div class="col-lg-2">
  14. </div>
  15. </div>
  16. </br>
  17. <div class="wrapper wrapper-content animated fadeInRight">
  18. <div class="row">
  19. <div class="col-lg-12">
  20. <div class="ibox float-e-margins">
  21. <div class="ibox-title">
  22. <h5>REPORT KAS</h5>
  23. <div class="ibox-tools">
  24. <a class="collapse-link">
  25. <i class="fa fa-chevron-up"></i>
  26. </a>
  27. </div>
  28. </div>
  29. <div class="ibox-content">
  30. <div class="table-responsive">
  31. <table class="table table-striped table-bordered table-hover dataTables-example" >
  32. <thead>
  33. <tr>
  34. <th>No</th>
  35. <th>ID. Pendaftar</th>
  36. <th>Nama Pendaftar</th>
  37. <th>Nominal</th>
  38. </tr>
  39. </thead>
  40. <tbody>
  41. <?php
  42. $localhost = "localhost";
  43. $user = "root";
  44. $pass = "";
  45. $database = "reg_siswa";
  46. $no =1;
  47. $sql = $koneksi->query("select * from kas");
  48. while ($data=$sql->fetch_assoc()) {
  49. $query = "SELECT SUM(nominal) FROM kas";
  50. $result = mysql_query($query) or die(mysql_error());
  51. while($row = mysql_fetch_array($result)){
  52. ?>
  53. <tr>
  54. <td><?php echo $no++; ?></td>
  55. <td><?php echo $data["id_pendaftar"]; ?></td>
  56. <td><?php echo $data["nm_siswa"]; ?></td>
  57. <td><?php echo $data["nominal"]; ?></td>
  58. </tr>
  59. </tbody>
  60. <tr>
  61. <th colspan="3" style="text-align: center; font-size: 20px"> Total Kas</th>
  62. <th colspan="1" style="text-align: right; font-size: 17px"><?php echo " = Rp.". $row['SUM(total)']; echo "<br />";?></th>
  63. <?php }?>
  64. </tr>
  65. </table>
  66. </div>
  67. </div>
  68. </div>
  69. </div>
  70. </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement