forked from priyansh007/Faith-1
-
Notifications
You must be signed in to change notification settings - Fork 0
/
linegraph.php
52 lines (44 loc) · 1.17 KB
/
linegraph.php
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
<?php
$dataPoints = array();
//Best practice is to create a separate file for handling connection to database
// Creating a new connection.
// Replace your-hostname, your-db, your-username, your-password according to your database
$data=mysqli_connect("localhost","root","","mess") or die();
$i=0;
$ram=array("1000","2000");
while($i<2){
array_push($dataPoints, array(
"label" => $ram[$i],
"y" => $ram[$i]
)
);
$i++;
}
$link = null;
?>
<!DOCTYPE HTML>
<html>
<head>
<script>
window.onload = function () {
var chart = new CanvasJS.Chart("chartContainer", {
animationEnabled: true,
exportEnabled: true,
theme: "light1", // "light1", "light2", "dark1", "dark2"
title:{
text: "PHP Column Chart from Database"
},
data: [{
type: "line", //change type to bar, line, area, pie, etc
dataPoints: <?php echo json_encode($dataPoints, JSON_NUMERIC_CHECK); ?>
}]
});
chart.render();
}
</script>
</head>
<body>
<div id="chartContainer" style="height: 370px; width: 100%;"></div>
<script src="https://canvasjs.com/assets/script/canvasjs.min.js"></script>
</body>
</html>