Hallo! Selamat Datang di Marketplace produk digital, Freelancer terbaik di indonesia (67423 Members, 783 Products, 5280 Topic, 12953 Comments)

Menampilkan jumlah absen SIASELAH KTSP

Dibuat
Login Terakhir 7 Hari lalu,
Telah Dilihat 1189 Kali
Rahmat Sasmita Mengatakan : Sultan Account
  1. Bagaimana cara menampilkan jumlah absen pada raport halaman 6 SIASELAH KTSP ?

Ada 4 Jawaban

PHPMU.COM Support
commented on 20 Nov 2017 14:08:55
  1. Asslaam, coba begini mas :
  2. SELECT count(*) as total_hadir FROM `rb_absensi_siswa` a JOIN rb_jadwal_pelajaran b ON a.kodejdwl=b.kodejdwl
  3. where a.nisn='$_GET[id]' AND b.id_tahun_akademik='$_GET[tahun]' AND a.kode_kehadiran='H'
  4.  
  5. echo "$row[total_hadir]";
Rahmat Sasmita
commented on 20 Nov 2017 17:01:49
  1. Kalau disini gimana nyimpen nya ya pk? Saya masih bingung
  2.  
  3. echo "<b>E. Ketidakhadiran</b>
  4. <table id='tablemodul1' width=85% border=1>
  5. <tr><td width='70%'>Sakit</td> <td width='10px'> : </td> <td align=center>0</td> </tr>
  6. <tr><td>Izin</td> <td> : </td> <td align=center>0</td> </tr>
  7. <tr><td>Tanpa Keterangan</td> <td> : </td> <td align=center>0</td> </tr>
  8. </table>";
PHPMU.COM Support
commented on 20 Nov 2017 18:12:17
  1. Coba gini saja mas,..
  2.  
  3. $row1 = mysql_fetch_array(mysql_query("SELECT count(*) as total_sakit FROM `rb_absensi_siswa` a JOIN rb_jadwal_pelajaran b ON a.kodejdwl=b.kodejdwl
  4. where a.nisn='$_GET[id]' AND b.id_tahun_akademik='$_GET[tahun]' AND a.kode_kehadiran='S'"));
  5.  
  6. $row2 = mysql_fetch_array(mysql_query("SELECT count(*) as total_izin FROM `rb_absensi_siswa` a JOIN rb_jadwal_pelajaran b ON a.kodejdwl=b.kodejdwl
  7. where a.nisn='$_GET[id]' AND b.id_tahun_akademik='$_GET[tahun]' AND a.kode_kehadiran='I'"));
  8.  
  9. $row3 = mysql_fetch_array(mysql_query("SELECT count(*) as total_alpa FROM `rb_absensi_siswa` a JOIN rb_jadwal_pelajaran b ON a.kodejdwl=b.kodejdwl
  10. where a.nisn='$_GET[id]' AND b.id_tahun_akademik='$_GET[tahun]' AND a.kode_kehadiran='A'"));
  11.  
  12. echo "<b>E. Ketidakhadiran</b>
  13. <table id='tablemodul1' width=85% border=1>
  14. <tr><td width='70%'>Sakit</td> <td width='10px'> : </td> <td align=center>$row1[total_sakit]</td> </tr>
  15. <tr><td>Izin</td> <td> : </td> <td align=center>$row2[total_izin]</td> </tr>
  16. <tr><td>Tanpa Keterangan</td> <td> : </td> <td align=center>$row3[total_alpa]</td> </tr>
  17. </table>";
Rahmat Sasmita
commented on 21 Nov 2017 05:11:10
  1. Alhamdulillah bisa pa robby. Terima Kasih :)
Maaf, Untuk Memberikan Komentar Anda Harus Login !!!