new

<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>