This repository has been archived by the owner on Jan 22, 2022. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathplot-santri.php
108 lines (104 loc) · 2.37 KB
/
plot-santri.php
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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
<?php
$jk = array('Laki-Laki','Perempuan');
$j = array(array('Pra-Tahsin','Tahsin 1','Tahsin 2'),array('Takhossus','Tahfizh'),array('Tingkat 0','Tingkat 1'));
$h = array('Minggu','Senin','Selasa','Rabu','Kamis','Jumat','Sabtu');
require "inc/connect.php";
$query = "SELECT * FROM plot_view";
$result = mysqli_query($connect, $query);
?>
<html>
<head>
<title>Plot Santri LPQ Al-Hurriyyah Angkatan 11</title>
<style type="text/css">
body {
font-family: "Helvetica Neue", Helvetica, Arial;
font-size: 14px;
line-height: 20px;
font-weight: 400;
color: #3b3b3b;
-webkit-font-smoothing: antialiased;
font-smoothing: antialiased;
}
.wrapper {
margin: 0 auto;
padding: 40px;
max-width: 800px;
}
.table {
margin: 0 0 40px 0;
width: 100%;
box-shadow: 0 1px 3px rgba(0, 0, 0, 0.2);
display: table;
}
@media screen and (max-width: 580px) {
.table {
display: block;
}
}
.row {
display: table-row;
background: #f6f6f6;
}
.row:nth-of-type(odd) {
background: #e9e9e9;
}
.row.header {
font-weight: 900;
color: #ffffff;
background: #ea6153;
}
.row.green {
background: #27ae60;
}
.row.blue {
background: #2980b9;
}
@media screen and (max-width: 580px) {
.row {
padding: 8px 0;
display: block;
}
}
.cell {
padding: 6px 12px;
display: table-cell;
}
@media screen and (max-width: 580px) {
.cell {
padding: 2px 12px;
display: block;
}
}
</style>
</head>
<body>
<table class="table">
<tr class="row header">
<th class="cell">Jenis Kelamin</th>
<th class="cell">Jenjang</th>
<th class="cell">Hari</th>
<th class="cell">Waktu</th>
<th class="cell">Nama Santri</th>
<th class="cell">Nomor Identitas</th>
<th class="cell">Nama Instruktur</th>
<th class="cell">Nomor HP</th>
</tr>
<?php
while($data = mysqli_fetch_object($result)) {
?>
<tr class="row">
<td class="cell"><?php echo $jk[$data->jk-1]; ?></td>
<td class="cell"><?php echo $j[$data->pr-1][$data->j-1]; ?></td>
<td class="cell"><?php echo $h[$data->h-1]; ?></td>
<td class="cell"><?php echo date('H:i', strtotime($data->w)); ?></td>
<td class="cell"><?php echo $data->nama_lengkap; ?></td>
<td class="cell"><?php echo $data->id_status; ?></td>
<td class="cell"><?php echo $data->nama_instruktur; ?></td>
<td class="cell"><?php echo $data->nomor_instruktur; ?></td>
</tr>
<?php
}
?>
</table>
</body>
</html>