copy skrip dibawah ini ubtuk membuat halaman exel.
<?php include "koneksi.php";
header("Content-Type: application/force-download");
header("Cache-Control: no-cache, must-revalidate");
header("Expires: Sat, 26 Jul 2017 05:00:00 GMT");
header("content-disposition: attachment;filename=Alumni.xls");
?>
<h3>Data Alumni Roudlotul Mubtadiin Balekambang Jepara</h3>
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<th>No</th>
<th>Nama</th>
<th>Jenis Kelamin</th>
<th>Provinsi</th>
<th>Kabupaten</th>
<th>Kecamatan</th>
<th>Desa</th>
<th>Tahun Lulus</th>
</tr>
</thead>
<tbody>
<?php
$no=1;
while($muni=mysqli_fetch_array($remo)){
?>
<tr>
<td><?php echo $no; ?></td>
<td><?php echo $muni['nama_alumni']; ?></td>
<td><?php echo $muni['jeniskelamin']; ?></td>
<td><?php echo $muni['provinsi']; ?></td>
<td><?php echo $muni['kabupaten']; ?></td>
<td><?php echo $muni['kecamatan']; ?></td>
<td><?php echo $muni['desa']; ?></td>
<td><?php echo $muni['tahunlulus']; ?></td>
</tr>
<?php $no++; } ?>
</tbody>
</table>
<?php echo '<meta http-equiv="Refresh" content="0.001; URL=index.php">'; ?>
#informatika
EmoticonEmoticon