php

<?php
$host="localhost";
$username="root";
$password="";
$db="experiment";
$conn=mysql_connect($host,$username,$password);
mysql_select_db($db,$conn);
?>
<table border="1" width="100%">
    <tr>
        <td align="center" rowspan="2">NID</td>
        <td align="center" rowspan="2">NAMA</td>
        <td align="center" rowspan="2">FAKTORIAL</td>
        <td align="center" colspan="31" rowspan="1">TANGGAL</td>
        <td align="center" rowspan="2">TOTAL LEMBUR</td>
    </tr>
    <tr>
        <?php
        for($i=1;$i<32;$i++){
            echo "<td align='center'>".$i."</td>";
        }
        ?>
    </tr>
    <?php
    $sql="SELECT * FROM lembur_1";
    $query=mysql_query($sql);
    while($row=mysql_fetch_array($query)){
        $nid=$row['nid'];
        ?>
        <tr>
            <td rowspan="4"><?php echo $row['nid']; ?></td>
            <td rowspan="4"><?php echo $row['nama']; ?></td>
            <td>F1</td>
            <?php
            for($i=1;$i<32;$i++){
                $sql="SELECT tanggal,f1 FROM lembur_1 WHERE nid='$nid'  ORDER BY tanggal ASC";
                $query=mysql_query($sql);
                $num=mysql_num_rows($query);
                while($row=mysql_fetch_array($query)){
                    if($i==date('d',strtotime($row['tanggal']))){
                        echo "<td>".$row['f1']."</td>";
                    }else{
                        echo "<td></td>";
                    }
                }
            }
            ?>
            <td rowspan="4"><?php echo $num; ?></td>
        </tr>
        <tr>
            <td>F2</td>
            <?php
            for($i=1;$i<32;$i++){
                $sql="SELECT tanggal,f1 FROM lembur_1 WHERE nid='$nid'  ORDER BY tanggal ASC";
                $query=mysql_query($sql);
                $num=mysql_num_rows($query);
                while($row=mysql_fetch_array($query)){
                    if($i==date('d',strtotime($row['tanggal']))){
                        echo "<td>".$row['f1']."</td>";
                    }else{
                        echo "<td></td>";
                    }
                }
            }
            ?>
        </tr>
        <tr>
            <td>F3</td>
            <?php
            for($i=1;$i<32;$i++){
                $sql="SELECT tanggal,f3 FROM lembur_1 WHERE nid='$nid'  ORDER BY tanggal ASC";
                $query=mysql_query($sql);
                $num=mysql_num_rows($query);
                while($row=mysql_fetch_array($query)){
                    if($i==date('d',strtotime($row['tanggal']))){
                        echo "<td>".$row['f3']."</td>";
                    }else{
                        echo "<td></td>";
                    }
                }
            }
            ?>
        </tr>
        <tr>
            <td>F4</td>
            <?php
            for($i=1;$i<32;$i++){
                $sql="SELECT tanggal,f4 FROM lembur_1 WHERE nid='$nid'  ORDER BY tanggal ASC";
                $query=mysql_query($sql);
                $num=mysql_num_rows($query);
                while($row=mysql_fetch_array($query)){
                    if($i==date('d',strtotime($row['tanggal']))){
                        echo "<td>".$row['f4']."</td>";
                    }else{
                        echo "<td></td>";
                    }
                }
            }
            ?>
        </tr>
        <?php
    }
    ?>
</table>