WebSimpleCRUD/export.php at main · FadilAdz/WebSimpleCRUD · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
<?php

require 'controller/koneksi.php';
$db = new Db();

header("Content-type: application/vnd-ms-excel");
header("Content-Disposition: attachment; filename=Laporan Showroom.xls");
?>

<h2>LAPORAN DATA SHOWROOM</h2>

<table border="1">
    <tr>
        <th>No</th>
        <th>kode Mobil</th>
        <th>Nama Mobil</th>
        <th>Jenis Mobil</th>
        <th>Stok</th>
        <th>Tanggal update</th>
    </tr>
    <?php
              $no = 1;
              foreach ($db->tampil_data() as $x) {
              ?>
                <tr>
                  <td><?php echo $no++; ?></td>
                  <td><?php echo $x['kode_mobil']; ?></td>
                  <td><?php echo $x['nama_mobil']; ?></td>
                  <td><?php echo $x['jenis_mobil']; ?></td>
                  <td><?php echo $x['stok']; ?></td>
                  <td><?php echo $x['tgl_update']; ?></td>
                </tr>
              <?php
              }
              ?>

</table>