In the following line the round brackets around the conditions were missing:
while($r = mysql_fetch_assoc($result) && $r_API =
mysql_fetch_assoc($result_API)) {
had to be changed to
while(($r = mysql_fetch_assoc($result)) && ($r_API =
mysql_fetch_assoc($result_API))) {
RBTCGP schrieb am Montag, 21. September 2020 um 14:53:15 UTC+2:
> With this solution I get the following Jason form the PHP:
>
>
>
> {"cols":[{"label":"DatumZeit","type":"string"},{"label":"Origin AZ
> [ms]","type":"number"},{"label":"API AZ
> [ms]","type":"number"}],"rows":[{"c":[{"v":""},{"v":0},{"v":58}]},{"c":[{"v":""},{"v":0},{"v":72}]},{"c":[{"v":""},{"v":0},{"v":72}]},{"c":[{"v":""},{"v":0},{"v":67}]},{"c":[{"v":""},{"v":0},{"v":69}]},{"c":[{"v":""},{"v":0},{"v":88}]},{"c":[{"v":""},{"v":0},{"v":70}]},{"c":[{"v":""},{"v":0},{"v":68}]},{"c":[{"v":""},{"v":0},{"v":271}]},{"c":[{"v":""},{"v":0},{"v":70}]}]}
>
>
> But I do not know, why the first v:-values are empty and the second
> v-values are all 0?
> In fact with one line in the graph these values are not missing. (And they
> are present in the DB).
>
>
> <?php
> //$_ra = $_GET["ra"];
> mysql_connect("XXXXXX:YYY","USer","PW");
> mysql_select_db("test");
>
> $result = mysql_query("SELECT (DATE_FORMAT(t, '%T')), rt FROM
> zdf_rt_testzdf Order by t DESC LIMIT 10");
> $result_API = mysql_query("SELECT (DATE_FORMAT(t, '%T')), rt FROM
> zdf_rt_testzdf_API Order by t DESC LIMIT 10");
>
> $table = array();
> $table['cols'] = array(
>
> // Labels for your chart, these represent the column titles
> // Note that one column is in "string" format and another one is in
> "number" format as pie chart only required "numbers" for calculating
> percentage and string will be used for column title
> array('label' => 'DatumZeit', 'type' => 'string'),
> array('label' => 'Origin AZ [ms]', 'type' => 'number'),
> array('label' => 'API AZ [ms]', 'type' => 'number')
>
> );
>
> $rows = array();
> while($r = mysql_fetch_assoc($result) && $r_API =
> mysql_fetch_assoc($result_API)) {
> $temp = array();
> // the following line will be used to slice the Pie chart
> $temp[] = array('v' => (string) $r["(DATE_FORMAT(t, '%T'))"]);
>
> // Values of each slice
> $temp[] = array('v' => (int) $r['rt']);
> $temp[] = array('v' => (int) $r_API['rt']);
> $rows[] = array('c' => $temp);
> }
>
> $table['rows'] = $rows;
> $jsonTable = json_encode($table);
> echo $jsonTable;
> //$json_data = json_encode($data);
> //print $json_data;
> //file_put_contents('your_json_file.json', $json_data);
> mysql_close();
> ?>
>
>
> RBTCGP schrieb am Samstag, 19. September 2020 um 21:36:26 UTC+2:
>
>> I have a line chart, that gets data from a DB by the use of a PHP-Script.
>>
>> Now I would like to display a second line in the same chart getting data
>> from the same DB but from another table.
>>
>> Do I have to add code in the google graph HTML-page or just in the
>> PHP-Script?
>>
>> <?php
>> //$_ra = $_GET["ra"];
>> mysql_connect("<IP>:<PORT>","<USER>","<PW>");
>> mysql_select_db("test");
>>
>> $result = mysql_query("SELECT (DATE_FORMAT(t, '%T')), rt FROM <Table>
>> Order by t DESC LIMIT 10");
>>
>> $table = array();
>> $table['cols'] = array(
>>
>> // Labels for your chart, these represent the column titles
>> // Note that one column is in "string" format and another one is in
>> "number" format as pie chart only required "numbers" for calculating
>> percentage and string will be used for column title
>> array('label' => 'DatumZeit', 'type' => 'string'),
>> array('label' => 'AZ [ms]', 'type' => 'number')
>>
>> );
>>
>> $rows = array();
>> while($r = mysql_fetch_assoc($result)) {
>> $temp = array();
>> // the following line will be used to slice the Pie chart
>> $temp[] = array('v' => (string) $r["(DATE_FORMAT(t, '%T'))"]);
>>
>> // Values of each slice
>> $temp[] = array('v' => (int) $r['rt']);
>> $rows[] = array('c' => $temp);
>> }
>>
>> $table['rows'] = $rows;
>> $jsonTable = json_encode($table);
>> echo $jsonTable;
>>
>> mysql_close();
>> ?>
>>
>>
--
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/63addccf-8283-4acb-9068-5fba5578f319n%40googlegroups.com.
