ngurah

<!Doctype html>
<html lang="en">
<head>
<title>Popup Tampil Data Barang</title>
<meta content="width=device-width, initial-scale=1.0, user-scalable=no, minimum-scale=1.0, maximum-scale=1.0" name="viewport"/>
 <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="description" content="">
    <meta name="author" content="">

<link href="bootstrap/css/bootstrap.css" rel="stylesheet">
<script src="bootstrap/js/jquery.min.js"></script>
<script src="bootstrap/js/bootstrap.min.js"></script>
</head>
<body>

 <center><img src="gambar/The-Layar-3Br-Poolside-Recovered1.jpg" class="img-responsive" alt="Responsive image">
        </center>
	<div class="container">
    <nav class="navbar navbar-default">

    <div class="navbar-header">
      <button type="button" class="navbar-toggle collapsed"
      data-toggle="collapse" data-target="#bs-example-navbar-collapse-1" aria-expanded="false">
        <span class="sr-only">Toggle navigation</span>
        <span class="icon-bar"></span>
        <span class="icon-bar"></span>
        <span class="icon-bar"></span>
      </button>
      <a class="navbar-brand" href="home_staff.php".php">Sistem Laporan Pekerjaan</a>
    </div>


    <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
      <ul class="nav navbar-nav">

        <li><a href="barang/index_staff.php">Data Staff</a></li>

           <li class="dropdown">
          <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true"
          aria-expanded="false">Pekerjaan<span class="caret"></span></a>
          <ul class="dropdown-menu">
            <li><a href="barang/index_kerja.php".php">Data Pekerjaan</a></li>
            <li><a href="barang/lapor_kerja.php">Laporan Pekerjaan</a></li>
           </ul>

           <li><a href="#">Data Barang</a></li>
        </li>
      </ul>

      <ul class="nav navbar-nav navbar-right">
        <li><a class="btn" data-toggle="modal" data-target=".bs-example-modal-sm">Logout
            <div class="modal bs-example-modal-sm" tabindex="-1" role="dialog" aria-hidden="true">
              <div class="modal-dialog modal-sm">
                <div class="modal-content">
                  <div class="modal-header"><h4>Logout <i class="fa fa-lock"></i></h4></div>
                  <div class="modal-body" ><i class="fa fa-question-circle"></i> Apakah Anda yakin ingin keluar?</div>
                  <div class="modal-footer"><a href="login.php".php" class="btn btn-primary btn-block">Logout</a></div>
                </div>
              </div>
            </div>
            </a>
		</li>
        </ul>
    </div><!-- /.navbar-collapse -->
</nav>

<div class="jumbotron">
<div class="container">
  <h2>Data Barang</h2>

<?php
	$host="localhost";
	$user="root";
	$pass="";
	$data="sislap";
	$link=new mysqli($host,$user,$pass,$data);

	if ($link->connect_error) {
    die("Koneksi Gagal : " . $link->connect_error);
	}
	$tabel = 'bm';

?>


<table width="99%" class="table table-bordered" id="mytable">
    <thead>
    <th >No</th>
      <th>Nama Barang</th>
      <th>Jumlah</th>
    </thead>

    <?php
	$no = 0;
			$query = "SELECT DISTINCT brg FROM $tabel";   // QUERY UNTUK MENGUMPULKAN SEMUA NAMA BARANG
    if ($result = $link->query($query))
    {
        /* fetch object array */
        while ($sql = $result->fetch_array(MYSQLI_ASSOC))
            {
                $brgx = $sql['brg']; //////////QUERY UNTUK PENJUMLAH QTY BARANG
                $query = "SELECT SUM(qty) AS total FROM $tabel Where brg='$brgx'; ";

                $xresult = $link->query($query);
                $crud_x = $xresult->fetch_array(MYSQLI_ASSOC);
                $tqty = $crud_x['total'];
                $xresult->close();
                echo $brgx."=".$tqty."<br/>";
            }
        /* free result set */
        $result->close();
    }
	$no++;
	?>

<tr>
	<td> <?php echo $no; ?></td>
	<td> <?php echo $brgx; ?></td>
    <td> <?php echo $tqty; ?></td>
    </tr>

</table>
</div>
</div>
<!-- footer -->
<hr>
<footer class="footer">
	<div class="container">
    <center>
    	<p class="text-muted">Copyright by Admin</p>
    </center>
    </div>
    </footer>
</body>
</html>