Advertisement
Guest User

nyoba

a guest
Apr 1st, 2020
1,244
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.61 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4.     <title>Tampil Barang</title>
  5.     <meta charset="utf-8">
  6.     <meta name="viewport" content="width=device-widht, initial-scale=1">
  7.     <link rel="stylesheet" href="css/bootstrap.min.css">
  8.     <script src="jquery-3.4.1.min.js"></script>
  9.     <script src="js/bootstrap.min.js"></script>
  10. </head>
  11. <body>
  12.  
  13.     <?php
  14.     include"conf/koneksi.php";
  15.     $tampil=mysqli_query($con,"select a.kd_barang as kd_barang, a.nama as nama, b.nama_kategori as nama_kategori,a.deskripsi as deskripsi,a.jumlah as jumlah
  16.                  from barang a left join kategori b on a.id_kategori=b.id_kategori");
  17.  
  18.      ?>
  19.  
  20.     <div class="container">
  21.   <h2>Tampil Data Barang</h2>
  22.   <p>Ini Adalah data - data barang
  23.   <a href="add.php"><button type='button' class='btn btn-info'>Tambah Data Barang</button>
  24.  
  25.   </p>            
  26.   <table class="table table-hover">
  27.     <thead>
  28.       <tr>
  29.         <th>No</th>
  30.         <th>Kode Barang</th>
  31.         <th>Nama Barang</th>
  32.         <th>Kategori</th>
  33.         <th>Deskripsi</th>
  34.         <th>Jumlah</th>
  35.         <th>Aksi</th>
  36.      
  37.       </tr>
  38.     </thead>
  39.     <tbody>
  40.     <?php
  41.         $no=1;
  42.             // print_r($tampil);exit;
  43.             while ($r=mysqli_fetch_array($tampil)){
  44.   echo"      <tr><td>$no</td>
  45.                 <td>$r[kd_barang]</td>
  46.                 <td>$r[nama]</td>
  47.                 <td>$r[nama_kategori]</td>
  48.                 <td>$r[deskripsi]</td>
  49.          <td>$r[jumlah]</td>
  50.                 <td><button type='button' class='btn btn-primary'>Edit</button>
  51.                 <button type='button' class='btn btn-danger'>Hapus</button>
  52.          </td></tr>";
  53.                 $no++;
  54.                 }
  55.             ?>
  56.      </tbody>
  57.   </table>
  58. </div>
  59.  
  60. </body>
  61. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement