Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- date_default_timezone_set('Europe/Warsaw');
- function wykres($db, $table, $description, $rgbcolor)
- {
- echo "<canvas id=\"".$table."\"></canvas>";
- $labels = "";
- $data = "";
- $query = mysqli_query($db, "SELECT * FROM ( SELECT id, data, value FROM `".$table."` ORDER BY id DESC LIMIT 60 ) sub ORDER BY id ASC");
- while ($row = mysqli_fetch_array($query)) {
- $labels .= "\"".date('G:i d-m', $row{'data'})."\",";
- $data .= "".$row{'value'}.",";
- }
- echo "<script>
- var ctx = document.getElementById('".$table."').getContext('2d');
- var chart = new Chart(ctx, {
- // The type of chart we want to create
- type: 'line',
- // The data for our dataset
- data: {
- labels: [".$labels."],
- datasets: [{
- label: \"".$description."\",
- backgroundColor: 'rgb(".$rgbcolor.")',
- borderColor: 'rgb(".$rgbcolor.")',
- data: [".$data."],
- fill: false,
- }]
- },
- // Configuration options go here
- options: {}
- });
- </script>";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement