TKK_E32210823/user_log_up.php

55 lines
1.6 KiB
PHP

<table cellpadding="0" cellspacing="0" border="0">
<tbody>
<?php
session_start();
//Connect to database
require'connectDB.php';
if (isset($_POST['log_date'])) {
if ($_POST['date_sel'] != 0) {
$_SESSION['seldate'] = $_POST['date_sel'];
}
else{
$_SESSION['seldate'] = date("Y-m-d");
}
}
if ($_POST['select_date'] == 1) {
$_SESSION['seldate'] = date("Y-m-d");
$seldate = $_SESSION['seldate'];
}
else if ($_POST['select_date'] == 0) {
$seldate = $_SESSION['seldate'];
}
$sql = "SELECT *,IF(rekap_keluar='00:00:00','',rekap_keluar) AS keluar FROM data_absen WHERE tgl='$seldate' group by tgl,idrfid";
// echo $sql;
$result = mysqli_stmt_init($conn);
if (!mysqli_stmt_prepare($result, $sql)) {
echo '<p class="error">SQL Error</p>';
}
else{
mysqli_stmt_execute($result);
$resultl = mysqli_stmt_get_result($result);
if (mysqli_num_rows($resultl) > 0){
while ($row = mysqli_fetch_assoc($resultl)){
?>
<tr>
<td><?php echo $row['tgl'];?></td>
<td><?php echo $row['idrfid'];?></td>
<td><?php echo $row['rekap_masuk'];?></td>
<td><img src="images/photos/<?php echo $row['gambar1'];?>" width="100px"></td>
<td><?php echo $row['keluar'];?></td>
<td><img src="images/photos/<?php echo $row['gambar2'];?>" width="100px"></td>
</tr>
<?php
}
}
}
?>
</tbody>
</table>