Tab Jadwal Sidang Hari Ini

{source}
<?php
$conn = mysqli_connect(‘localhost’,’paandool_sipp’,’web4nd@@l@’,’paandool_sipp’);

$tgl = date(‘d’);
$bln = date(‘m’);
$thn = date(‘Y’);
$tglsekarang = $thn.’-‘.$bln.’-‘.$tgl;
?>

<?PHP
$no = 1;
$qsatu =”
SELECT A.noPerkara, B.ruangan, B.agenda
FROM dataumumweb AS A
INNER JOIN jadwalsidangweb AS B ON A.IDPerkara = B.IDPerkara
WHERE B.tglSidang= ‘$tglsekarang’
ORDER BY A.IDPerkara ASC”;

$satu = mysqli_query($conn, $qsatu);
?>

<table border=”0″ class=”uk-table uk-table-striped” cellspacing=”0″ cellpadding=”0″>
<thead>
<tr class=”odd”>
<td width =”1%”><center><strong>NO</strong></center></td>
<td width =”23%”><center><strong>NOMOR PERKARA</strong></center></td>
<td width =”30%”><center><strong>RUANG SIDANG</strong></center></td>
<td><center><strong>AGENDA</strong></center></td>
</tr>
</thead>

<?PHP if (mysqli_num_rows($satu) > 0 ){ ?>
<tbody>
<?PHP
$no = 0;
while($rsatu = mysqli_fetch_array($satu)){
$no++;
?>
<tr class=”odd”>
<td><center><?PHP echo $no;?></center></td>
<td><center><?PHP echo $rsatu[‘noPerkara’];?></center></td>
<td><center><?PHP echo $rsatu[‘ruangan’];?></center></td>
<td><?PHP echo $rsatu[‘agenda’];?></td>
</tr>
<?PHP } ?>
</tbody>
<?PHP } else{ ?>
<tbody>
<tr>
<td colspan=”4″><center>Tidak Ada Sidang Hari Ini</center></td>
</tr>
</tbody>
<?PHP } ?>
</table>
{/source}