database not connected

16 views

Skip to first unread message

Gullit Gagas

unread,

Feb 29, 2016, 7:30:51 AM2/29/16

to Google Visualization API

hai sir i'm fresher to google charts..can anyone guide to connect the database

here is my coding..

<?php

$servername="localhost";

$username="root";

$password="";

$database="charts";

$mysqli=new mysqli($servername, $username, $password, $database);

if($mysqli->connect_error){

die("Connection Failed: " .$mysqli->connect_error);

}

$query="select * from piechart";

$qresult=$mysqli->query($query);

$results=array();

while($res=$qresult->fetch_assoc()){

$results[]=$res;

}

$pie_chart_data=array();

foreach($results as $result)

{

$pie_chart_data[]=array($result['status'],(int)$result['num of patitent']);

}

$pie_chart_data= json_encode($pie_chart_data);

mysqli_free_result($qresult);

<html>

<head>

google.charts.load('current', {'packages':['corechart']});

google.charts.setOnLoadCallback(drawChart);

function drawChart() {

var data = google.visualization.arrayToDataTable([$pie_chart_data]);

var options = {

title: 'My Daily Activities'

};

var chart = new google.visualization.PieChart(document.getElementById('piechart'));

chart.draw(data, options);

}

</script>

</head>

<body>

</body>

</html>

Reply all

Reply to author

Forward

0 new messages