<?php
include "../koneksi/koneksi.php";
$title = "Exporting Sederhana dari SQL ke XLS";
$content_header = "<table><tr><th>NoPendaftaran</th><th>TglPendaftaran</th><th>NoUrut</th><th>NamaPeg</th><th>Nama Pasien</th><th>Alamat Pasien</th><th>KodePoli</th><th>NamaPoli</th></tr>";
$content_footer = "</table>";
$content_dalam = "";
$sql = "SELECT * FROM pendaftaran join pegawai ON pendaftaran.NIP=pegawai.NIP
join pasien ON pendaftaran.NoPasien=pasien.NoPasien
join poliklinik ON pendaftaran.KodePoli=poliklinik.KodePoli ";
$q = mysql_query( $sql );
while( $r=mysql_fetch_array( $q ) ){
$data = "<tr><td>".$r['NoPendaftaran']."</td><td>".$r['TglPendaftaran']."</td><td>".$r['NoUrut']."</td><td>".$r['NamaPeg']."</td>
<td>".$r['NamaPas']."</td><td>".$r['AlmPas']."</td><td>".$r['KodePoli']."</td><td>".$r['NamaPoli']."</td></tr>";
$content_dalam = $content_dalam ."\n". $data;
}
$content_sheet = $title . "\n" . $content_header . "\n" . $content_dalam . "\n" . $content_footer;
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=excel.xls");
header("Pragma: no-cache");
header("Expires: 0");
print $content_sheet;
?>
include "../koneksi/koneksi.php";
$title = "Exporting Sederhana dari SQL ke XLS";
$content_header = "<table><tr><th>NoPendaftaran</th><th>TglPendaftaran</th><th>NoUrut</th><th>NamaPeg</th><th>Nama Pasien</th><th>Alamat Pasien</th><th>KodePoli</th><th>NamaPoli</th></tr>";
$content_footer = "</table>";
$content_dalam = "";
$sql = "SELECT * FROM pendaftaran join pegawai ON pendaftaran.NIP=pegawai.NIP
join pasien ON pendaftaran.NoPasien=pasien.NoPasien
join poliklinik ON pendaftaran.KodePoli=poliklinik.KodePoli ";
$q = mysql_query( $sql );
while( $r=mysql_fetch_array( $q ) ){
$data = "<tr><td>".$r['NoPendaftaran']."</td><td>".$r['TglPendaftaran']."</td><td>".$r['NoUrut']."</td><td>".$r['NamaPeg']."</td>
<td>".$r['NamaPas']."</td><td>".$r['AlmPas']."</td><td>".$r['KodePoli']."</td><td>".$r['NamaPoli']."</td></tr>";
$content_dalam = $content_dalam ."\n". $data;
}
$content_sheet = $title . "\n" . $content_header . "\n" . $content_dalam . "\n" . $content_footer;
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=excel.xls");
header("Pragma: no-cache");
header("Expires: 0");
print $content_sheet;
?>
Comments
Post a Comment