NO |
KELAS |
HADIR |
TIDAK HADIR |
1 |
XTB1 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
2 |
XTB2 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
3 |
XTB3 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
4 |
XIB1 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
5 |
XIB2 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
6 |
XIB3 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
7 |
XIIB1 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
8 |
XIIB2 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
9 |
XIIB3 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
10 |
XIITE1 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
11 |
XIITE2 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
12 |
XIITE3 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
13 |
XIITJKT1 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
14 |
XIITJKT2 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
15 |
XIITJKT3 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
16 |
XIITJKT4 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
17 |
XIITO1 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
18 |
XIITO2 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
19 |
XIITO3 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
20 |
XIITO4 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
21 |
XITE1 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
22 |
XITE2 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
23 |
XITE3 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
24 |
XITJKT1 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
25 |
XITJKT2 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
26 |
XITJKT3 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
27 |
XITJKT4 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
28 |
XITO1 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
29 |
XITO2 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
30 |
XITO3 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
31 |
XITO4 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
32 |
XTE1 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
33 |
XTE2 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
34 |
XTE3 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
35 |
XTJKT1 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
36 |
XTJKT2 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
37 |
XTJKT3 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
38 |
XTJKT4 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
39 |
XTO1 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
40 |
XTO2 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
41 |
XTO3 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |
42 |
XTO4 |
$hitungmasuk="SELECT COUNT(*) AS jumlah FROM absensi INNER JOIN siswa ON absensi.nisn = siswa.nisn where tanggal = '$tgl' and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungmasuk);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?>
|
$hitungalfa ="SELECT COUNT(*) AS jumlah FROM siswa WHERE NOT EXISTS ( SELECT * FROM absensi WHERE absensi.nisn=siswa.nisn and tanggal = '$tgl') and kelas = '".$data2['kelas']."' ";
$query =mysqli_query($koneksi, $hitungalfa);
$result =mysqli_fetch_array($query);
echo "{$result['jumlah']}";
?> |