date_default_timezone_set("Asia/Jakarta");
require_once"koneksivar.php";
$conn = new mysqli($DBServer, $DBUser, $DBPass, $DBName);
if ($conn->connect_error) {
trigger_error('Database connection failed: ' . $conn->connect_error, E_USER_ERROR);
}
$NT="tb_admin";
$PK="id_admin";
if(isset($_GET["tabel"])){
$NT=$_GET["tabel"];
$PK=$_GET["pk"];
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Export Data Kuisioner - <?php echo $NT;?></title>
</head>
<body>
<style type="text/css">
body{
font-family: sans-serif;
}
table{
margin: 20px auto;
border-collapse: collapse;
}
table th,
table td{
border: 1px solid #3c3c3c;
padding: 3px 8px;
}
a{
background: blue;
color: #fff;
padding: 8px 10px;
text-decoration: none;
border-radius: 2px;
}
</style>
<?php
header("Content-type: application/vnd-ms-excel");
header("Content-Disposition: attachment; filename=$NT.xls");
?>
<center>
<h1> <?php echo strtoupper("Data Kuisioner Tracert Study ".$NT);?><br/>
https://www.upnvj.ac.id/id.html</h1>
</center>
<?php
$sql="select * from `".$NT."`";
$result = mysqli_query($conn,$sql);
$jc=mysqli_num_fields($result);
$gab="<table border='1'><tr><th>No</th>";
for($i=1;$i<$jc;$i++){
$colObj = mysqli_fetch_field_direct($result,$i);
$col= $colObj->name;
$ar[$i-1]=$col;
$gab.="<th>$col</th>";
}
$gab.="</tr>";
$sql="select * from `".$NT."` order by `".$PK."` asc";
$jum=getJum($conn,$sql);
if($jum > 0){
$arr=getData($conn,$sql);
$no=1;
foreach($arr as $d) {
$gab.="<tr><td>$no</td>";
for($i=1;$i<$jc;$i++){
$v=$ar[$i-1];
$data=$d["$v"];
$gab.="<td>$data</td>";
}//for
$gab.="</tr>";
$no++;
}//foreach
}//jum
else{
$gab.="<tr colspan='$jc'>data belum tersedia</tr>";
}
$gab.="</table>";
echo $gab;
?>
</body>
</html>
Tidak ada komentar:
Posting Komentar