-
Notifications
You must be signed in to change notification settings - Fork 0
/
admin_fetch_user.php
53 lines (45 loc) · 1.36 KB
/
admin_fetch_user.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
<?php
include 'connect.php';
header('Content-type: application/json');
// FILE UNTUK FETCH SEMUA USER YANG BUKAN KETUA
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
// Ambil Data dari Ajax
$email = $_POST['email'];
// Ambil email, nama, hp, dan umur dari DB
$sql = "SELECT email,
nama,
hp,
FLOOR(DATEDIFF(NOW(),lahir)/365.25) as umur
FROM user
WHERE ketua = 0 AND group_member = 0 AND email != 'admin@gmail.com'";
$stmt = $pdo->prepare($sql);
$stmt->execute();
// Isi DataTable
$output =
'<thead>
<tr>
<th><b>No</b></th>
<th><b>Email</b></th>
<th><b>Nama</b></th>
<th><b>No HP</b></th>
<th><b>Umur</b></th>
<th><b>Invite to Group</b></th>
</tr>
</thead>';
$output .= '<tbody>';
$count = 0;
while ($row = $stmt->fetch()) {
$checklist = '<input class="form-check-input" type="checkbox" value="">';
$output .= '<tr>
<td>' . ++$count . '</td>
<td>' . $row['email'] . '</td>
<td>' . $row['nama'] . '</td>
<td>' . $row['hp'] . '</td>
<td>' . $row['umur'] . '</td>
<td>' . $checklist . '</td>
</tr>';
}
$output .= '</tbody>';
echo json_encode(array('output' => $output));
}
?>