want to add multiple mysql queries in combo chart

26 views

Skip to first unread message

Umesh Poman

unread,

Jan 17, 2017, 12:53:50 AM1/17/17

to Google Visualization API

Want to add multiple mysql queries in combo chart

i m trying this code but its not working

<head>

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

google.charts.setOnLoadCallback(drawVisualization);

function drawVisualization() {

var data = google.visualization.arrayToDataTable([

['Group', 'Location 1', 'WEST', 'SOUTH', 'NORTH', 'CENTRAL'],

<?php $sql = "select count(serial_number) as asset_no from asset";

// Location 1

$sqlboxa1 = "select count(boxa1) as boxa1 from location_1 Where category='Lock'";

$exeboxa1 = mysql_query($sqlboxa1,$conn);

$rowboxa1 = mysqli_fetch_assoc($exeboxa1);

$sqlboxa2 = "select count(boxa1) as boxa1 from location_1 Where category='Key'";

$exeboxa2 = mysql_query($sqlboxa2,$conn);

$rowboxa2 = mysqli_fetch_assoc($exeboxa2);

$sqlboxa3 = "select count(boxa1) as boxa1 from location_1 Where category='Ring'";

$exeboxa3 = mysql_query($sqlboxa3,$conn);

$rowboxa3 = mysqli_fetch_assoc($exeboxa3);

// Location 2

$sqlboxa4 = "select count(boxa1) as boxa1 from location_2 Where category='Lock'";

$exeboxa4 = mysql_query($sqlboxa4,$conn);

$rowboxa4 = mysqli_fetch_assoc($exeboxa4);

$sqlboxa5 = "select count(boxa1) as boxa1 from location_2 Where category='Key'";

$exeboxa5 = mysql_query($sqlboxa5,$conn);

$rowboxa5 = mysqli_fetch_assoc($exeboxa5);

$sqlboxa6 = "select count(boxa1) as boxa1 from location_2 Where category='Ring'";

$exeboxa6 = mysql_query($sqlboxa6,$conn);

$rowboxa6 = mysqli_fetch_assoc($exeboxa6);

// Location 3

$sqlboxa7 = "select count(boxa1) as boxa1 from location_3 Where category='Lock'";

$exeboxa7 = mysql_query($sqlboxa7,$conn);

$rowboxa7 = mysqli_fetch_assoc($exeboxa7);

$sqlboxa8 = "select count(boxa1) as boxa1 from location_3 Where category='Key'";

$exeboxa8 = mysql_query($sqlboxa8,$conn);

$rowboxa8 = mysqli_fetch_assoc($exeboxa8);

$sqlboxa9 = "select count(boxa1) as boxa1 from location_3 Where category='Ring'";

$exeboxa9 = mysql_query($sqlboxa9,$conn);

$rowboxa9 = mysqli_fetch_assoc($exeboxa9);

// Location 4

$sqlboxa10 = "select count(boxa1) as boxa1 from location_4 Where category='Lock'";

$exeboxa10 = mysql_query($sqlboxa10,$conn);

$rowboxa10 = mysqli_fetch_assoc($exeboxa10);

$sqlboxa11 = "select count(boxa1) as boxa1 from location_4 Where category='Key'";

$exeboxa11 = mysql_query($sqlboxa11,$conn);

$rowboxa11 = mysqli_fetch_assoc($exeboxa11);

$sqlboxa12 = "select count(boxa1) as boxa1 from location_4 Where category='Ring'";

$exeboxa12 = mysql_query($sqlboxa12,$conn);

$rowboxa12 = mysqli_fetch_assoc($exeboxa12);

// Location 5

$sqlboxa13 = "select count(boxa1) as boxa1 from location_5 Where category='Lock'";

$exeboxa13 = mysql_query($sqlboxa13,$conn);

$rowboxa13 = mysqli_fetch_assoc($exeboxa13);

$sqlboxa14 = "select count(boxa1) as boxa1 from location_5 Where category='Key'";

$exeboxa14 = mysql_query($sqlboxa14,$conn);

$rowboxa14 = mysqli_fetch_assoc($exeboxa14);

$sqlboxa15 = "select count(boxa1) as boxa1 from location_5 Where category='Ring'";

$exeboxa15 = mysql_query($sqlboxa15,$conn);

$rowboxa15 = mysqli_fetch_assoc($exeboxa15);

['Lock','<?php echo $rowboxa1['boxa1'];?>','<?php echo $rowboxa4['boxa1'];?>','<?php echo $rowboxa7['boxa1'];?>','<?php echo $rowboxa10['boxa1'];?>','<?php echo $rowboxa13['boxa1'];?>'],

['Key','<?php echo $rowboxa2['boxa1'];?>','<?php echo $rowboxa5['boxa1'];?>','<?php echo $rowboxa8['boxa1'];?>','<?php echo $rowboxa11['boxa1'];?>','<?php echo $rowboxa14['boxa1'];?>'],

['Ring','<?php echo $rowboxa3['boxa1'];?>','<?php echo $rowboxa6['boxa1'];?>','<?php echo $rowboxa9['boxa1'];?>','<?php echo $rowboxa12['boxa1'];?>','<?php echo $rowboxa15['boxa1'];?>']

]);

var options = {

title : 'Total Number Of Assets',

seriesType: 'bars',

backgroundColor: 'yellow'

};

var chart = new google.visualization.ComboChart(document.getElementById('chart_div'));

chart.draw(data, options);

}

</script>

</head>

<h3>Total Number Of Assets</h3>

Reply all

Reply to author

Forward

0 new messages