hey i really need some help please , i am trying to make pie chart from
data base i have but it looks like i am doing something wrong i suppose to
get 50% in Female and 50% in Male but i got this like parts is missing and
i can get whats wrong i can really use some helppppp
attaching the code in here
<?php
require('database.php');
$connect = mysqli_connect("localhost","root", " ","servername");?>
<?php
global $database;
$query ="SELECT Gender,count(*) as Number FROM users GROUP BY Gender";
$result=$database->query($query);
?>
<!DOCTYPE html>
<html lang="en-US">
<head>
<meta charset="UTF-8">
<meta name="viewport"
content="width=device-width,user-scalable=no,initial-scale=1.0,maximum-scale=1.0,minimum-scale=1.0">
<meta http-equiv="x-UA-compatibile" content="ie-edge">
<title>Data</title>
<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([
['Female','Male'],
<?php
while($chart =mysqli_fetch_assoc($result))
{
echo"['".$chart['Gender']."','".$chart['Number']."'],";
}
?>
]);
var options = {
title: 'who likes are websit better Female or Male?',
};
var chart = new
google.visualization.PieChart(document.getElementById('piechart'));
chart.draw(data, options);
}
</script>
</head>
<body>
<div id="piechart" style="width: 900px; height: 500px;"></div>
</body>
</html>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-visualization-api/7dcdb977-a9d4-4dad-aa37-8d5d85c85c35n%40googlegroups.com.
