Google Charts + Mysql+PHP(N gráficos com N Tabelas)Problema Básico de Lógica.
Bom dia! Por favor me ajudem! Tenho problemas com lógica.Tenho certeza que não posso usar o for 9 vezes. O sistema de gráfico funciona, o problema surge quando vou adicionar o segundo for. Nesse código só fui até a segunda tabela e são 9. Vou cita-lo nas referências de meu trabalho
A parte do código que estou com problema é essa:
<?php
$k = $i;
for ($i = 0; $i < $k; $i++) {
?>
data.setValue(<?php echo $i ?>, 0, '<?php echo $ano[$i] ?>');
data.setValue(<?php echo $i ?>, 1, <?php echo $Numero_de_pacientes_HIV_em_tratamento[$i] ?>);
<?php
}
?>
Tento dar continuidade criando $k1 e $i1 porém tenho certeza que não pode.
Abaixo o código completo
<?php
$host = "localhost";
$user = "root";
$pass = "";
$banco = "sida";
$conexao = mysql_connect($host, $user, $pass) or die (mysql_error());
mysql_select_db($banco) or die (mysql_error());
#declaracao grafico Numero_de_pacientes_HIV_em_tratamento
$Ano = array();
$Numero_de_pacientes_HIV_em_tratamento = array();
$i = 0;
$sql = "SELECT * FROM sage_nphvitrat";
$resultado = mysql_query($sql);
while ($row = mysql_fetch_object($resultado)){
$ano[$i] = $row->ano;
$Numero_de_pacientes_HIV_em_tratamento[$i] = $row->Numero_de_pacientes_HIV_em_tratamento;
$i = $i + 1;
}
#declaraçao grafico 2
$ano1 = array();
$Branca = array();
$Amarela = array();
$Ignorada = array();
$Indigena = array();
$Parda = array();
$Preta = array();
$i1 = 0;
$sql1 = "SELECT * FROM sage_pcsrc";
$resultado1 = mysql_query($sql1);
while ($row = mysql_fetch_object($resultado1)){
$ano1[$i1] = $row->Ano_pcsrc;
$Branca[$i1] = $row->Branca;
$Amarela[$i1] = $row->Amarela;
$Ignorada[$i1] = $row->Ignorada;
$Indigena[$i1] = $row->Indigena;
$Parda[$i1] = $row->Parda;
$Preta[$i1] = $row->Preta;
$i1 = $i1 + 1;
}
?>
<html>
<head>
<!--Load the AJAX API-->
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript">
// Load the Visualization API and the piechart package.
google.load('visualization', '1.0', {'packages':['corechart']});
// Set a callback to run when the Google Visualization API is loaded.
google.setOnLoadCallback(drawChart);
// Callback that creates and populates a data table,
// instantiates the pie chart, passes in the data and
// draws it.
function drawChart() {
// Create the data table.
var data = new google.visualization.DataTable();
data.addColumn('string', 'ano');
data.addColumn('number', 'Numero_de_pacientes_HIV_em_tratamento');
data.addRows(<?php echo $i ?>);
// Create the data table.
var data2 = new google.visualization.DataTable();
data2.addColumn('string', 'ano1');
data2.addColumn('number', 'Branca');
data2.addColumn('number', 'Amarela');
data2.addColumn('number', 'Ignorada');
data2.addColumn('number', 'Indigena');
data2.addColumn('number', 'Parda');
data2.addColumn('number', 'Preta');
data2.addRows(<?php echo $i1 ?>);
// Create the data table.
var data3 = new google.visualization.DataTable();
data3.addColumn('string', 'Year');
data3.addColumn('number', 'Sales');
data3.addColumn('number', 'Expenses');
data3.addRows([
['2004', 1000, 400],
['2005', 1170, 460],
['2006', 860, 580],
['2007', 1030, 540]
]);
// Create the data table.
var data4 = new google.visualization.DataTable();
data4.addColumn('string', 'Topping');
data4.addColumn('number', 'Slices');
data4.addRows([
['Mushrooms', 3],
['Onions', 1],
['Olives', 1],
['Zucchini', 1],
['Pepperoni', 2]
]);
// Create the data table.
var data5 = new google.visualization.DataTable();
data5.addColumn('string', 'Topping');
data5.addColumn('number', 'Slices');
data5.addRows([
['Mushrooms', 3],
['Onions', 1],
['Olives', 15],
['Zucchini', 1],
['Pepperoni', 2]
]);
// Create the data table.
var data6 = new google.visualization.DataTable();
data6.addColumn('string', 'Year');
data6.addColumn('number', 'Sales');
data6.addColumn('number', 'Expenses');
data6.addRows([
['2004', 1000, 400],
['2005', 1170, 460],
['2006', 860, 580],
['2007', 1030, 540]
]);
// Create the data table.
var data7 = new google.visualization.DataTable();
data7.addColumn('string', 'Topping');
data7.addColumn('number', 'Slices');
data7.addRows([
['Mushrooms', 3],
['Onions', 1],
['Olives', 1],
['Zucchini', 1],
['Pepperoni', 2]
]);
// Create the data table.
var data8 = new google.visualization.DataTable();
data8.addColumn('string', 'Topping');
data8.addColumn('number', 'Slices');
data8.addRows([
['Mushrooms', 3],
['Onions', 1],
['Olives', 15],
['Zucchini', 1],
['Pepperoni', 2]
]);
// Create the data table.
var data9 = new google.visualization.DataTable();
data9.addColumn('string', 'Year');
data9.addColumn('number', 'Sales');
data9.addColumn('number', 'Expenses');
data9.addRows([
['2004', 1000, 400],
['2005', 1170, 460],
['2006', 860, 580],
['2007', 1030, 540]
]);
<?php
$k = $i;
for ($i = 0; $i < $k; $i++) {
?>
data.setValue(<?php echo $i ?>, 0, '<?php echo $ano[$i] ?>');
data.setValue(<?php echo $i ?>, 1, <?php echo $Numero_de_pacientes_HIV_em_tratamento[$i] ?>);
<?php
}
?>
// Set chart options
var options = {'title':'NÚMERO DE PACIENTES HIV EM TRATAMENTO',
'width':400,
'height':300,
'colors':['red']
};
// Set chart options
var options2 = {'title':'Pacientes por Raça e Cor',
'width':400,
'height':300};
// Set chart options
var options3 = {'title':'3',
'width':400,
'height':300};
// Set chart options
var options4 = {'title':'4',
'width':400,
'height':300};
// Set chart options
var options5 = {'title':'5',
'width':400,
'height':300};
// Set chart options
var options6 = {'title':'6',
'width':400,
'height':300};
// Set chart options
var options7 = {'title':'7',
'width':400,
'height':300};
// Set chart options
var options8 = {'title':'8',
'width':400,
'height':300};
// Set chart options
var options9 = {'title':'9',
'width':400,
'height':300};
// Instantiate and draw our chart, passing in some options.
var chart = new google.visualization.ColumnChart(document.getElementById('chart_div'));
chart.draw(data, options);
var chart2 = new google.visualization.ColumnChart(document.getElementById('chart_div2'));
chart2.draw(data2, options2);
var chart3 = new google.visualization.ColumnChart(document.getElementById('chart_div3'));
chart3.draw(data3, options3);
var chart4 = new google.visualization.ColumnChart(document.getElementById('chart_div4'));
chart4.draw(data4, options4);
var chart5 = new google.visualization.ColumnChart(document.getElementById('chart_div5'));
chart5.draw(data5, options5);
var chart6 = new google.visualization.ColumnChart(document.getElementById('chart_div6'));
chart6.draw(data6, options6);
var chart7 = new google.visualization.ColumnChart(document.getElementById('chart_div7'));
chart7.draw(data7, options7);
var chart8 = new google.visualization.ColumnChart(document.getElementById('chart_div8'));
chart8.draw(data8, options8);
var chart9 = new google.visualization.ColumnChart(document.getElementById('chart_div9'));
chart9.draw(data9, options9);
}
</script>
</head>
<body>
<!--Divs that will hold the charts-->
<div id="chart_div"></div>
<div id="chart_div2"></div>
<div id="chart_div3"></div>
<div id="chart_div4"></div>
<div id="chart_div5"></div>
<div id="chart_div6"></div>
<div id="chart_div7"></div>
<div id="chart_div8"></div>
<div id="chart_div9"></div>
</body>
</html>Discussão (1)
Carregando comentários...