Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host = "localhost";
- $username = "xxx";
- $password = "xxx";
- $database = "xxx";
- $con = mysqli_connect($host,$username,$password,$database);
- $countryList = array();
- $countryNumber = array();
- $genderList = array();
- $genderNumber = array();
- $data = "['Countries', 'People per country'],";
- $get = mysqli_query($con, "SELECT * FROM website_visits");
- while($row = mysqli_fetch_assoc($get)){
- if(in_array($row["country"], $countryList)){
- $countryNumber[$row["country"]] = $countryNumber[$row["country"]]+1;
- }else{
- array_push($countryList, $row["country"]);
- $countryNumber[$row["country"]] = 1;
- }
- }
- $i = 0;
- foreach($countryNumber as $number){
- $data = $data . "['" . $countryList[$i] . "'," . $number . "],";
- $i++;
- }
- $get = mysqli_query($con, "SELECT * FROM website_visits");
- $data2 = "['Gender', 'Gender per person'],";
- while($row = mysqli_fetch_assoc($get)){
- if(in_array($row["gender"], $genderList)){
- $genderNumber[$row["gender"]] = $genderNumber[$row["gender"]]+1;
- }else{
- array_push($genderList, $row["gender"]);
- $genderNumber[$row["gender"]] = 1;
- }
- }
- $i = 0;
- foreach($genderNumber as $number){
- $data2 = $data2 . "['" . $genderList[$i] . "'," . $number . "],";
- $i++;
- }
- ?>
- <html>
- <head>
- <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
- <script type="text/javascript">
- google.charts.load("current", {packages:["corechart"]});
- google.charts.setOnLoadCallback(drawChart);
- function drawChart() {
- var data = google.visualization.arrayToDataTable([
- <?php echo $data; ?>
- ]);
- var options = {
- title: 'Countries',
- is3D: true,
- };
- var chart = new google.visualization.PieChart(document.getElementById('piechart_3d'));
- chart.draw(data, options);
- }
- google.charts.setOnLoadCallback(drawChart2);
- function drawChart2() {
- var data = google.visualization.arrayToDataTable([
- <?php echo $data2; ?>
- ]);
- var options = {
- title: 'Gender',
- is3D: true,
- };
- var chart = new google.visualization.PieChart(document.getElementById('2piechart_3d'));
- chart.draw(data, options);
- }
- </script>
- </head>
- <body>
- <div id="piechart_3d" style="width: 500px; height: 500px;"></div>
- <div id="2piechart_3d" style="width: 500px; height: 500px;"></div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement