I joined the tables together into one query statement, which should substantially simplify things, and fixed up the DataTable creation code. I also made a few minor edits here and there. Try the attached file and see if it works. If it doesn't work, open it in a browser and view the page source. If that is empty (or contains error codes pertaining to PHP or PostgreSQL) then there is a problem in the PHP. If it is populated, then there is a problem with the javascript. In the latter case, copy the source from the browser and post here so I can help debug it.
On Saturday, April 27, 2013 7:41:47 AM UTC-4, Alex wrote:
>
> thanks my code:
> <?php
>
> // Aceder a base de dados
> $host = "...";
> $user= "...";
> $pass = "....";
> $db="....";
>
> $acessoDB = pg_connect("host=$host dbname=$db user=$user password=$pass");
> if (!$acessoDB){
> die ("Não foi possível aceder à base de dados.");
> }
>
>
> $queryData =pg_query("SELECT start_time, media_cssr_cs_2g_quinzenal
> FROM huawei.quinzenal_cssr_cs_2g
> ORDER BY start_time");
>
> $queryData1 =pg_query("SELECT start_time, media_cssr_cs_3g_quinzenal
> FROM huawei.quinzenal_cssr_cs_3g
> ORDER BY start_time");
>
>
> $queryData2 =pg_query("SELECT start_time, media_cssr_ps_2g_quinzenal
> FROM huawei.quinzenal_cssr_ps_2g
> ORDER BY start_time");
>
>
> $queryData3 =pg_query("SELECT start_time, media_cssr_ps_3g_quinzenal
> FROM huawei.quinzenal_cssr_ps_3g
> ORDER BY start_time");
>
> $table = array();
> $table['cols'] = array(
>
> array('label' => 'start_time', 'type' => 'string'),
> array('label' => 'CSSR CS 2G', 'type' => 'number'),
> array('label' => 'CSSR CS 3G', 'type' => 'number'),
> array('label' => 'CSSR PS 2G', 'type' => 'number'),
> array('label' => 'CSSR PS 3G', 'type' => 'number')
> );
>
> //1 Series
> $rows = array();
> while($r = pg_fetch_assoc($queryData)) {
> $temp = array();
> // the following line will used to slice the Pie chart
> $temp[] = array('v' => (string) $r['start_time']);
>
> //Values of the each slice
> $temp[] = array('v' => (float) $r['media_cssr_cs_2g_quinzenal']);
> $rows[] = array('c' => $temp);
> }
>
> $table['rows'] = $rows;
> $jsonTable = json_encode($table);
> //echo $jsonTable;
>
> //2 Series
> $rows = array();
> while($r = pg_fetch_assoc($queryData1)) {
> $temp = array();
> // the following line will used to slice the Pie chart
> $temp[] = array('v' => (string) $r['start_time']);
>
> //Values of the each slice
> $temp[] = array('v' => (float) $r['media_cssr_cs_3g_quinzenal']);
> $rows[] = array('c' => $temp);
> }
>
> $table['rows'] = $rows;
> $jsonTable1 = json_encode($table);
> //echo $jsonTable1;
>
> //3 Series
> $rows = array();
> while($r = pg_fetch_assoc($queryData2)) {
> $temp = array();
> // the following line will used to slice the Pie chart
> $temp[] = array('v' => (string) $r['start_time']);
>
> //Values of the each slice
> $temp[] = array('v' => (float) $r['media_cssr_ps_2g_quinzenal']);
> $rows[] = array('c' => $temp);
> }
>
> $table['rows'] = $rows;
> $jsonTable2 = json_encode($table);
> //echo $jsonTable2;
>
> //4 Series
> $rows = array();
> while($r = pg_fetch_assoc($queryData3)) {
> $temp = array();
> // the following line will used to slice the Pie chart
> $temp[] = array('v' => (string) $r['start_time']);
>
> //Values of the each slice
> $temp[] = array('v' => (float) $r['media_cssr_ps_3g_quinzenal']);
> $rows[] = array('c' => $temp);
> }
>
> $table['rows'] = $rows;
> $jsonTable3 = json_encode($table);
> //echo $jsonTable3;
>
> ?>
>
>
> <html>
> <head>
> <!--Load the AJAX API-->
> <script type="text/javascript" src="https://www.google.com/jsapi
> "></script>
> <script type="text/javascript" src="
> http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js";></script>
> <script type="text/javascript">
>
>
> google.load('visualization', '1', {'packages':['coreChart']});
>
> // Set a callback to run when the Google Visualization API is loaded.
> google.setOnLoadCallback(drawChart);
>
> function drawChart() {
>
> // Create our data table out of JSON data loaded from server.
> var data = new google.visualization.DataTable();
> data.addColumn('string', 'start_time');
> data.addColumn('number', 'CSSR CS 2G');
> data.addColumn('number', 'CSSR CS 3G');
> data.addColumn('number', 'CSSR PS 2G');
> data.addColumn('number', 'CSSR PS 3G');
> data.addRows([
> [(<?=$jsonTable?>),'CSSR CS 2G'],
> [(<?=$jsonTable1?>),'CSSR CS 3G'],
> [(<?=$jsonTable2?>),'CSSR PS 2G'],
> [(<?=$jsonTable3?>),'CSSR PS 3G']
> ]);
>
> var options = {
> title: 'Acessibility',
> //chartArea: {width: 0, top: 30, left: 140, width: "50%",
> height: "50%"},
> //backgroundColor: 'yellow', //cor do fundo do grafico
> //axisTitlesPosition: 'out',
> //vAxis: {title: "Valor"}, //legenda horizontal
> //hAxis: {title: "Data"}, //legenda vertical
> //colors: ['#AA00CC'], // cor da linha do gráfico
> //is3D: 'True',
> width: 1500, //largura
> height: 400, //Altura
> };
>
> // Instantiate and draw our chart, passing in some options.
> var chart = new
> google.visualization.LineChart(document.getElementById('graf31'));
>
> chart.draw(data,options);
>
> }
>
>
> </script>
> </head>
>
> <body>
> <!--Div that will hold the chart-->
> <div id="graf31"></div>
>
> </body>
> </html>
>
>
> Sexta-feira, 26 de Abril de 2013 15:52:07 UTC-1, Alex escreveu:
>>
>> Hello
>> A need a help .
>> My Code don't work. I don't now why.
>>
>> <!--Load the AJAX API-->
>> <script type="text/javascript" src="https://www.google.com/jsapi
>> "></script>
>> <script type="text/javascript" src="
>> http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js
>> "></script>
>> <script type="text/javascript">
>>
>>
>> google.load('visualization', '1', {'packages':['coreChart']});
>>
>> // Set a callback to run when the Google Visualization API is loaded.
>> google.setOnLoadCallback(drawChart);
>>
>> function drawChart() {
>>
>> // Create our data table out of JSON data loaded from server.
>> var data = new google.visualization.DataTable();
>> data.addColumn('string', 'start_time');
>> data.addColumn('number', 'CSSR CS 2G');
>> data.addColumn('number', 'CSSR CS 3G');
>> data.addColumn('number', 'CSSR PS 2G');
>> data.addColumn('number', 'CSSR PS 3G');
>> data.addRows([
>> [(<?=$jsonTable?>),'CSSR CS 2G'],
>> [(<?=$jsonTable1?>),'CSSR CS 3G'],
>> [(<?=$jsonTable2?>),'CSSR PS 2G'],
>> [(<?=$jsonTable3?>),'CSSR PS 3G']
>> ]);
>>
>> var options = {
>> title: 'Acessibility',
>> //chartArea: {width: 0, top: 30, left: 140, width: "50%",
>> height: "50%"},
>> //backgroundColor: 'yellow', //cor do fundo do grafico
>> //axisTitlesPosition: 'out',
>> //vAxis: {title: "Valor"}, //legenda horizontal
>> //hAxis: {title: "Data"}, //legenda vertical
>> //colors: ['#AA00CC'], // cor da linha do gráfico
>> //is3D: 'True',
>> width: 1500, //largura
>> height: 400, //Altura
>> };
>>
>> // Instantiate and draw our chart, passing in some options.
>> var chart = new
>> google.visualization.LineChart(document.getElementById('graf31'));
>>
>> chart.draw(data,options);
>>
>> }
>>
>>
>>
>
--
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 post to this group, send email to [email protected].
Visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
<<attachment: chart.php>>
