01.
<?php
02.
03.
$servername
=
"localhost"
;
04.
$username
=
"username"
;
05.
$password
=
"password"
;
06.
$dbname
=
"database_name"
;
07.
08.
09.
$conn
=
new
PDO(
"mysql:host=$servername;dbname=$dbname"
,
$username
,
$password
);
10.
11.
12.
$stmt
=
$conn
->prepare(
"SELECT year, value1, value2, value3 FROM data_table"
);
13.
$stmt
->execute();
14.
$result
=
$stmt
->fetchAll();
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
$labels
=
array
();
32.
$value1
=
array
();
33.
$value2
=
array
();
34.
$value3
=
array
();
35.
36.
foreach
(
$result
as
$row
) {
37.
$labels
[] =
$row
[
'year'
];
38.
$value1
[] =
$row
[
'value1'
];
39.
$value2
[] =
$row
[
'value2'
];
40.
$value3
[] =
$row
[
'value3'
];
41.
}
42.
43.
$data
=
array
(
44.
"labels"
=>
$labels
,
45.
"datasets"
=>
array
(
46.
array
(
47.
"label"
=>
"Value 1"
,
48.
"data"
=>
$value1
,
49.
"borderColor"
=>
"red"
,
50.
"backgroundColor"
=>
"red"
,
51.
"fill"
=> false
52.
),
53.
array
(
54.
"label"
=>
"Value 2"
,
55.
"data"
=>
$value2
,
56.
"borderColor"
=>
"blue"
,
57.
"backgroundColor"
=>
"blue"
,
58.
"fill"
=> false
59.
),
60.
array
(
61.
"label"
=>
"Value 3"
,
62.
"data"
=>
$value3
,
63.
"borderColor"
=>
"green"
,
64.
"backgroundColor"
=>
"green"
,
65.
"fill"
=> false
66.
)
67.
)
68.
);
69.
70.
71.
?>
72.
73.
<!DOCTYPE html>
74.
<html>
75.
<head>
76.
<title>Multiple Line Chart Example</title>
78.
</head>
79.
<body>
80.
<canvas id=
"myChart"
></canvas>
81.
82.
<script>
83.
var
ctx = document.getElementById(
"myChart"
).getContext(
"2d"
);
84.
var
myChart =
new
Chart(ctx, {
85.
options: {plugins: {title: {display: true, text:
'Multiple-lines data from DB'
}}},
86.
type:
'line'
,
87.
data: <?php
echo
json_encode(
$data
); ?>
88.
});
89.
</script>
90.
</body>
91.
</html>