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>
Load balance : Server 00
