} elseif (!empty($email) && empty($log_type) && !empty($start_date) && !empty($end_date)) {
$query = $con->prepare("SELECT * FROM user_log WHERE user_id=:user_id AND date BETWEEN :start_date AND :end_date ORDER BY datetime DESC");
$query->execute(array(':user_id' => $user_id, ':start_date' => $start_date, ':end_date' => $end_date));
} elseif (!empty($email) && !empty($log_type) && !empty($start_date) && !empty($end_date)) {
$query = $con->prepare("SELECT * FROM user_log WHERE user_id=:user_id AND log_type=:log_type AND date BETWEEN :start_date AND :end_date ORDER BY datetime DESC");
$query->execute(array(':user_id' => $user_id, ':log_type' => $log_type, ':start_date' => $start_date, ':end_date' => $end_date));
} elseif (empty($email) && empty($log_type) && empty($start_date) && empty($end_date)) {
return false;
}
echo '<table class="table">
<tr class="table_head">
<!--<td style="width:5%">Username</td>-->
<td style="width:15%">User</td>
<td style="width:20%">Date Time</td>
<td style="width:20%">IP</td>
<td style="width:5%">Type</td>
<td style="width:30%">Remark</td>
</tr>';
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
echo '<tr class="table_data">';
echo '<td>' . display_email_from_user_id($con, $row['user_id']) . '</td>';
echo '<td>' . show_date_time($row['datetime']) . '</td>';
echo '<td>' . $row['ip'] . '</td>';
echo '<td>' . display_log_type($row['log_type']) . '</td>';
echo '<td>' . $row['remark'] . '</td>';
echo '</tr>';
}
echo '</table>';
//*/
}
//End user_log search script
<div class="col-md-10">
<div class="categorii-info">
<div class="categorii-info-text">
<h2><?php
echo $album['name_' . $lng];
?>
</h2>
<p><?php
echo $album['text_' . $lng];
?>
</p>
</div>
<div class="date-social-posts">
<div class="date-time-posts"><span><i class="mdi mdi-calendar-clock"></i><?php
echo show_date_time($album['data']);
?>
</span></div>
<!--div class="likes-posts"><span class="visible-lg"><i class="mdi mdi-eye"></i>2</span></div-->
</div>
</div>
</div>
</div>
</div>
</div>
<div class="container">
<div class="row margin">
<img src="<?php
echo $photo['photo_medium'];
?>
"/> <?php
}
?>
<div class="multimedia-title">
<p><?php
echo $photo['name_' . $lng];
?>
</p>
</div>
<div class="date-social-posts">
<div class="date-time-posts">
<span><i class="mdi mdi-calendar-clock"></i><?php
echo show_date_time($photo['data']);
?>
</span>
</div>
</div>
</div>
</div>
<?php
}
?>
</div>
</div>
</div>
</div>
</div>
<img class="img-responsive" src="http://i1.ytimg.com/vi/<?php
echo get_youtube_id_from_url($value['iframe']);
?>
/sddefault.jpg"/>
</div>
<div class="multimedia-title">
<p class="center"><?php
echo $value['name_' . $lng];
?>
</p>
</div>
</a>
<div class="date-time-posts">
<span class="center"><i class="mdi mdi-calendar-clock"></i> <?php
echo show_date_time($value['data']);
?>
</span>
</div>
</div>
<?php
}
?>
</div>
<?php
}
?>
</div>
</div>