Advertisement
Guest User

code

a guest
Mar 8th, 2016
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.70 KB | None | 0 0
  1. <?php
  2. $host = "localhost";
  3. $username = "xxx";
  4. $password = "xxx";
  5. $database = "xxx";
  6. $con = mysqli_connect($host,$username,$password,$database);
  7. $countryList = array();
  8. $countryNumber = array();
  9.  
  10. $genderList = array();
  11. $genderNumber = array();
  12.  
  13. $data = "['Countries', 'People per country'],";
  14.  
  15. $get = mysqli_query($con, "SELECT * FROM website_visits");
  16.  
  17.  
  18. while($row = mysqli_fetch_assoc($get)){
  19. if(in_array($row["country"], $countryList)){
  20. $countryNumber[$row["country"]] = $countryNumber[$row["country"]]+1;
  21. }else{
  22. array_push($countryList, $row["country"]);
  23. $countryNumber[$row["country"]] = 1;
  24. }
  25. }
  26.  
  27.  
  28.  
  29.  
  30. $i = 0;
  31. foreach($countryNumber as $number){
  32. $data = $data . "['" . $countryList[$i] . "'," . $number . "],";
  33. $i++;
  34. }
  35.  
  36. $get = mysqli_query($con, "SELECT * FROM website_visits");
  37.  
  38. $data2 = "['Gender', 'Gender per person'],";
  39. while($row = mysqli_fetch_assoc($get)){
  40. if(in_array($row["gender"], $genderList)){
  41. $genderNumber[$row["gender"]] = $genderNumber[$row["gender"]]+1;
  42. }else{
  43. array_push($genderList, $row["gender"]);
  44. $genderNumber[$row["gender"]] = 1;
  45. }
  46. }
  47.  
  48. $i = 0;
  49. foreach($genderNumber as $number){
  50. $data2 = $data2 . "['" . $genderList[$i] . "'," . $number . "],";
  51. $i++;
  52. }
  53. ?>
  54. <html>
  55. <head>
  56. <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
  57. <script type="text/javascript">
  58. google.charts.load("current", {packages:["corechart"]});
  59. google.charts.setOnLoadCallback(drawChart);
  60. function drawChart() {
  61. var data = google.visualization.arrayToDataTable([
  62. <?php echo $data; ?>
  63. ]);
  64.  
  65. var options = {
  66. title: 'Countries',
  67. is3D: true,
  68. };
  69.  
  70. var chart = new google.visualization.PieChart(document.getElementById('piechart_3d'));
  71. chart.draw(data, options);
  72.  
  73.  
  74. }
  75. google.charts.setOnLoadCallback(drawChart2);
  76. function drawChart2() {
  77. var data = google.visualization.arrayToDataTable([
  78. <?php echo $data2; ?>
  79. ]);
  80.  
  81. var options = {
  82. title: 'Gender',
  83. is3D: true,
  84. };
  85.  
  86. var chart = new google.visualization.PieChart(document.getElementById('2piechart_3d'));
  87. chart.draw(data, options);
  88.  
  89.  
  90. }
  91. </script>
  92. </head>
  93. <body>
  94. <div id="piechart_3d" style="width: 500px; height: 500px;"></div>
  95. <div id="2piechart_3d" style="width: 500px; height: 500px;"></div>
  96. </body>
  97. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement