Advertisement
riansaadillah

Untitled

Jul 1st, 2018
464
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.80 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4.     <title>CETAK PRINT DATA DARI DATABASE DENGAN PHP - RIAN-SS</title>
  5. </head>
  6. <body>
  7.  
  8.     <center>
  9.  
  10.         <h2>DATA LAPORAN BARANG</h2>
  11.         <h4>RIAN-SS</h4>
  12.  
  13.     </center>
  14.  
  15.     <?php
  16.     include 'config.php';
  17.     ?>
  18.  
  19.     <table border="1" style="width: 100%">
  20.         <tr>
  21.             <th width="1%">No</th>
  22.             <th>Tanggal</th>
  23.             <th>Nama Barang</th>
  24.             <th width="5%">Jumlah</th>
  25.         </tr>
  26.         <?php
  27.         $no = 1;
  28.         $sql = mysqli_query($koneksi,"select * from barang_masuk");
  29.         while($data = mysqli_fetch_array($sql)){
  30.         ?>
  31.         <tr>
  32.             <td><?php echo $no++; ?></td>
  33.             <td><?php echo $data['tanggal']; ?></td>
  34.             <td><?php echo $data['nama']; ?></td>
  35.             <td><?php echo $data['jumlah']; ?></td>
  36.         </tr>
  37.         <?php
  38.         }
  39.         ?>
  40.     </table>
  41.  
  42.     <script>
  43.         window.print();
  44.     </script>
  45.  
  46. </body>
  47. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement