Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <table class="table table-bordered table-hover table-responsive bgwhite clgray">
- <thead>
- <tr>
- <th class="text-center text-capitalize" width="20">
- No
- </th>
- <th class="text-center text-capitalize">
- idbarang
- </th>
- <th class="text-center text-capitalize">
- Kategori
- </th>
- <th class="text-center text-capitalize">
- Merk
- </th>
- <th class="text-center text-capitalize">
- Foto
- </th>
- <th class="text-center text-capitalize">
- Stok
- </th>
- </tr>
- </thead>
- <?php
- $queryStok = "SELECT SUM(stok) AS jumlahbarang FROM tabelstok WHERE idjenisusaha=1 GROUP BY idbarang";
- $resultStok = mysqli_query($link,$queryStok);
- $queryStok2 = "SELECT * FROM tabelbarang,tabelmerk WHERE tabelbarang.idmerk=tabelmerk.idmerk";
- $resultStok2= mysqli_query($link,$queryStok2);
- while ($datastok=mysqli_fetch_assoc($resultStok,$resultStok2)) {
- ?>
- <tbody>
- <tr>
- <td class="text-center text-capitalize">
- <?php echo $datastok['merk'] ?>
- </td>
- <td class="text-center text-capitalize">
- No
- </td>
- <td class="text-center text-capitalize">
- No
- </td>
- <td class="text-center text-capitalize">
- No
- </td>
- <td class="text-center text-capitalize">
- No
- </td>
- <td class="text-center text-capitalize">
- <?php echo $datastok['jumlahbarang'];?>
- </td>
- </tbody>
- <?php } ?>
- </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement