absensi.pehape

<?php
        date_default_timezone_set('Asia/Jakarta');

        $mysqlhost = "localhost";
        $mysqluser = "mysqluser";
        $mysqlpass = "mysqlpass";
        $mydb = "databasenya";
        $mysqlId = mysql_connect($mysqlhost,$mysqluser,$mysqlpass);
        mysql_select_db($mydb);

        // asumsi udah ada konesksi mysql
        // utk ambil data absensi agustus 2014
        $bulan = 8; $tahun = 2014;

        echo "<table border=1 bordercolor=#77aaee>
                <tr height=24><td>id siswa</td><td>nama siswa</td>\n";

        // utk bikin header tabel berdasarkan data yg ada
        $arrhari = array("","Minggu","Senin","Selasa","Rabu","Kamis","Jum'at","Sabtu");
        $query = "select tanggal,DAYOFWEEK(tanggal) from tbl_absensi where MONTH(tanggal)='$bulan' AND YEAR(tanggal)='$tahun'
                group by tanggal order by tanggal";
        $result = mysql_query($query);
        while(list($tgl,$w) = mysql_fetch_row($result)) {
                $hari = $arrhari[$w];
                echo "<td align=center>$hari<br>&nbsp;$tgl&nbsp;</td>\n";
        }
        mysql_free_result($result);
        echo "</tr>\n";

        $query = "SELECT GROUP_CONCAT(DISTINCT CONCAT(\"(SELECT IF(t\",DAYOFMONTH(tanggal),\".id_hadir=1,'HADIR','TIDAK')
        FROM tbl_absensi t\",DAYOFMONTH(tanggal),\" WHERE t\",DAYOFMONTH(tanggal),\".id_siswa=S.id_siswa AND t\",
        DAYOFMONTH(tanggal),\".tanggal='\",tanggal,\"') 'Tgl-\",DAYOFMONTH(tanggal),\"'\n\" ))
        from tbl_absensi WHERE MONTH(tanggal)='$bulan' AND YEAR(tanggal)='$tahun'";

        $result = mysql_query($query);
        list($myquery) = mysql_fetch_row($result);
        mysql_free_result($result);

        $query_absen = "SELECT T.id_siswa,S.nama, \n$myquery FROM tbl_absensi T JOIN tbl_siswa S ON S.id_siswa=T.id_SISWA
                        WHERE MONTH(T.tanggal)='$bulan' AND YEAR(T.tanggal)='$tahun' GROUP BY T.id_siswa ORDER BY S.nama";

//      echo "<pre>$query_absen</pre>";         // inilah query-nya
        $result = mysql_query($query_absen);
        while($row = mysql_fetch_row($result)) {
                echo "<tr>";
                foreach($row as $k=>$a) {
                        $bg = "";
                        if($k>1) {
                                $bg = $a=='HADIR' ? "":"bgcolor=#ffaaaa";
                        }
                        echo "<td $bg>&nbsp;$a</td>\n";
                }
                echo "<tr>";
        }
        mysql_free_result($result);
        mysql_close($mysqlId);
        echo "</table>\n";

?>