chart-php/index.php at main · salahddik/chart-php · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>chart bank </title>
    <script src="https://cdn.jsdelivr.net/npm/chart.js"></script>

</head>

<?php
$con =new mysqli ('localhost','root','','test');
$query= $con->query("
 SELECT
 MONTHNAME(created) as monthname,
   SUM(amount) as amount
FROM transactions
GROUP BY monthname

 ");
foreach ($query as $data)
{

    $month[] = $data ['monthname'];
    $amount[]= $data ['amount'];


}


?>


<body>

<div style="width: 800px;">
  <canvas id="myChart"></canvas>
</div>


<script>


const labels = <?php echo json_encode($month) ?>;
const data = {
  labels: labels,
  datasets: [{
    label: 'My First Dataset',
    data: <?php echo json_encode($amount) ?>,
    backgroundColor: [
      'rgba(255, 99, 132, 0.2)',
      'rgba(255, 159, 64, 0.2)',
      'rgba(255, 205, 86, 0.2)',
      'rgba(75, 192, 192, 0.2)',
      'rgba(54, 162, 235, 0.2)',
      'rgba(153, 102, 255, 0.2)',
      'rgba(201, 203, 207, 0.2)'
    ],
    borderColor: [
      'rgb(255, 99, 132)',
      'rgb(255, 159, 64)',
      'rgb(255, 205, 86)',
      'rgb(75, 192, 192)',
      'rgb(54, 162, 235)',
      'rgb(153, 102, 255)',
      'rgb(201, 203, 207)'
    ],
    borderWidth: 1
  }]
};

const config = {
  type: 'bar',
  data: data,
  options: {
    scales: {
      y: {
        beginAtZero: true
      }
    }
  },
};

  // === include 'setup' then 'config' above ===

  var myChart = new Chart(
    document.getElementById('myChart'),
    config
  );


</script>


</body>
</html>