01.
<?php
02.
03.
$host
=
"localhost"
;
04.
$user
=
"root"
;
05.
$pwd
=
""
;
06.
$db
=
"test"
;
07.
global
$link
;
08.
$link
= mysql_connect(
$host
,
$user
,
$pwd
)
or
die
(
"Could not connect to MySQL"
);
09.
mysql_query(
"SET NAMES UTF8"
,
$link
);
10.
mysql_select_db(
$db
,
$link
)
or
die
(
"Could not select $db database"
);
11.
12.
$dormitory
=
array
();
13.
$id
=
array
();
14.
15.
$sql
=
"select dormitory,COUNT(id) AS id1 from student group by dormitory"
;
16.
17.
18.
19.
$result
= mysql_query(
$sql
);
20.
while
(
$row
=mysql_fetch_array(
$result
)) {
21.
22.
23.
array_push
(
$dormitory
,
$row
[
'dormitory'
]);
24.
array_push
(
$id
,
$row
[
'id1'
]);
25.
}
26.
?>
27.
<!DOCTYPE HTML>
28.
<html>
29.
<head>
30.
<meta http-equiv=
"Content-Type"
content=
"text/html; charset=utf-8"
>
31.
<title></title>
32.
36.
<script>
37.
$(
function
() {
38.
$(
'#container'
).highcharts({
39.
chart: {
40.
type:
'column'
41.
},
42.
title: {
43.
text:
''
44.
},
45.
xAxis: {
46.
47.
categories: [
'<?= implode('
,
', $dormitory); ?>'
]
48.
49.
},
50.
yAxis: {
51.
title: {
52.
text:
'ร้อยละ(%)'
53.
}
54.
},
55.
tooltip: {
56.
headerFormat:
'<span style="font-size:10px">{point.key}</span><table>'
,
57.
pointFormat:
'<tr><td style="color:{series.color};padding:0">{series.name} </td>'
+
'<td style="padding:0"><b>{point.y:.lf} %</b></td></tr>'
,
58.
footerFormat:
'</table>'
,
59.
shared: true,
60.
userHTML: true
61.
},
62.
legend: {
63.
layout:
'vertical'
,
64.
align:
'right'
,
65.
verticalAlign:
'top'
,
66.
x: -10,
67.
y: 1000,
68.
borderWidth: 1
69.
},
70.
plotOptions: {
71.
line: {
72.
dataLabels: {
73.
enabled: true
74.
},
75.
enableMouseTracking: false
76.
}
77.
},
78.
series: [{
79.
name:
'คิดเป็น'
,
80.
81.
data: [<?= implode(
','
,
$id
)
82.
}]
83.
});
84.
});
85.
</script>