query("SELECT DISTINCT android_id FROM logs_v2 ORDER BY android_id")->fetchAll(PDO::FETCH_COLUMN);
$selected_id = isset($_GET['android_id']) ? $_GET['android_id'] : '';
$query = "SELECT * FROM logs_v2";
if ($selected_id) {
$query .= " WHERE android_id = ?";
$stmt = $pdo->prepare($query);
$stmt->execute([$selected_id]);
} else {
$stmt = $pdo->query($query);
}
$logs = $stmt->fetchAll(PDO::FETCH_ASSOC);
function formatLogTime($timestamp) {
return date("m-d-H:i:s.", floor($timestamp / 1000)) . str_pad($timestamp % 1000, 3, '0', STR_PAD_LEFT);
}
function formatLogMessage($message) {
return '' . htmlspecialchars($message) . '
';
}
?>
Logs
| id |
log_time |
android_id |
log_message |
|
|
|
|