| Server IP : 93.86.61.54 / Your IP : 216.73.216.60 Web Server : Apache/2.4.62 (Ubuntu) System : Linux rasin.ddns.net 6.8.0-124-generic #124~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Tue May 26 21:05:19 UTC x86_64 User : www-data ( 33) PHP Version : 8.4.22 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/html/projects/vreme/ |
Upload File : |
<!DOCTYPE html>
<html>
<head>
<title>Event Log</title>
<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
</head>
<body>
<h2>Signal Events</h2>
<canvas id="eventChart" width="400" height="200"></canvas>
<?php
$conn = new mysqli("localhost", "user", "password", "database");
$result = $conn->query("SELECT DATE(event_time) as day, COUNT(*) as count FROM events GROUP BY day");
$labels = [];
$data = [];
while($row = $result->fetch_assoc()) {
$labels[] = $row['day'];
$data[] = $row['count'];
}
$conn->close();
?>
<script>
const ctx = document.getElementById('eventChart').getContext('2d');
const eventChart = new Chart(ctx, {
type: 'bar',
data: {
labels: <?php echo json_encode($labels); ?>,
datasets: [{
label: 'Broj događaja po danu',
data: <?php echo json_encode($data); ?>,
backgroundColor: 'rgba(54, 162, 235, 0.6)'
}]
}
});
</script>
</body>
</html>