Thank you !
On Fri, 18 Oct 2019 at 11:19 AM, Jim Shaffer <[email protected]> wrote:
> Here's my use of MySQL (in PHP) for a simple line graph:
>
> <html>
> <?php
> // Start MySQL Connection
> include('connect.php');
> $SQL="SELECT DATE(recdate) AS 'RecordDate',FORMAT(AVG(Temperature),1) AS
> 'Temp',FORMAT(AVG(Humidity),1) AS 'Humidity' ,FORMAT(AVG(AmbientTemp),1) AS
> 'Ambient' FROM ResDataLog WHERE ABS(DATEDIFF(recdate,NOW())) < 375 GROUP BY
> DATE(recdate) ORDER BY recdate"; //,FORMAT(AVG(Pressure),1) AS Pressure
> $result=mysqli_query($dbh,$SQL);
> $rowCount=mysqli_num_rows($result);
>
> while ($row = mysqli_fetch_array($result)) {
> $entry .=
> "['".$row{'RecordDate'}."',".$row{'Temp'}.",".$row{'Humidity'}.",".$row{'Ambient'}."],";
> };
> //echo "Entry Array: </br>" . $entry . "</br>";
> //close the connection
> mysqli_close($dbh);
> ?>
>
> <head>
> <script type="text/javascript" src="
> https://www.gstatic.com/charts/loader.js";></script>
> <script type="text/javascript">
> google.charts.load('current', {'packages':['corechart']});
> google.charts.setOnLoadCallback(drawChart);
>
>
> function drawChart() {
> var data = google.visualization.arrayToDataTable([
> ['Date', 'Temp', 'Humidity', 'Ambient'],
> <?php echo $entry ?>
> ]);
>
> var options = {
> title: 'Average Telemetry by Day',
> curveType: 'function',
> legend: { position: 'top' },
> colors: ['black', 'blue', 'red']
> };
>
> var chart = new
> google.visualization.LineChart(document.getElementById('curve_chart'));
>
> chart.draw(data, options);
> }
> </script>
> </head>
> <body>
> <div id="curve_chart" style="width: 1200px; height: 600px"></div>
> </body>
> </html>
>
>
> -------- Connect.php:
>
> <?php
> $MyUsername = ""; // enter your username for mysql
> $MyPassword = ""; // enter your password for mysql
> $MyHostname = ""; // this is usually "localhost" unless your database
> resides on a different server
> $MyDBName = "";
>
> //mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
>
> $dbh = mysqli_connect($MyHostname , $MyUsername, $MyPassword, $MyDBName);
>
> // Check connection
>
> if (mysqli_connect_errno()) {
> die('<br><p>{Connect.php} Failed to connect to MySQL:
> '.mysqli_connect_error().'</p>');
> }
> // else {
> // echo '<br><p>{Connect.php} Connection to MySQL server successfully
> established.</p >';
> // }
>
>
>
> ?>
>
> On Fri, Oct 18, 2019 at 1:50 PM Shivakumar Chandrashekar <[email protected]>
> wrote:
>
>> Thanks Mike. Will wait :-)
>>
>> On Friday, October 18, 2019 at 5:47:42 AM UTC-7, Michael Brown wrote:
>>>
>>> I am trying to use MySQL as a data source for Gauge, but it's not
>>> working yet.
>>>
>>> All of the examples I see have the Javascript in your Chart web page
>>> call a PHP script on the database server. The PHP accesses the MySQL
>>> database and formats the return data as JSON. The Javascript then feeds
>>> the JSON to the Google chart API. It's too bad that Google didn't include
>>> direct SQL handling in the Chart API.
>>>
>>> While the Google documentation shows the expected format of the JSON
>>> data with row and col definitions, whatever I feed to the gauge causes it
>>> to not display *anything*, the gauge just vanishes on the page. And there
>>> is no error code or message being returned by the gauge, so I have no idea
>>> what is wrong, short of trying dozens of slightly different formats.
>>>
>>> This is my general frustration with anything from Google, and I've done
>>> a LOT of Android coding for my own needs. They provide a powerful and
>>> useful system, but it's unnecessarily difficult to program to, and it's not
>>> documented well enough to show examples for all use cases and error
>>> handling is non-existent. And then they deprecate it a few years later and
>>> you're screwed.
>>>
>>> When I get it working I'll come back and paste in the relevant code.
>>>
>>> --
>>>
>>> Mike Brown
>>>
>>> "Driving a gasoline sports car is going to feel like a steam engine with
>>> a side of quiche." Elon Musk
>>>
>>>
>>> On Thu, Oct 17, 2019 at 6:50 PM Shivakumar Chandrashekar <
>>> [email protected]> wrote:
>>>
>>>> Friends, I am newbie for this. Just wanted to know if anyone used excel
>>>> (preferably) or MySQL as data source and used this API. If yes, could you
>>>> please share how to use ? any challenges faced ?
>>>>
>>>> --
>>>> 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/b9cffd23-1f20-4dfe-b0b2-6c0f2988a44d%40googlegroups.com
>>>> <https://groups.google.com/d/msgid/google-visualization-api/b9cffd23-1f20-4dfe-b0b2-6c0f2988a44d%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>> .
>>>>
>>> --
>> 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/78de08b8-f76b-4995-9717-d3884170fb9f%40googlegroups.com
>> <https://groups.google.com/d/msgid/google-visualization-api/78de08b8-f76b-4995-9717-d3884170fb9f%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>
>
>>
>
> --
> Jim
>
> --
> 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/CAEo%2BXt2aH_BKpbLe5dD1AOmgYkddssujjsqz6909%2B8W7wnC%2BEQ%40mail.gmail.com
> <https://groups.google.com/d/msgid/google-visualization-api/CAEo%2BXt2aH_BKpbLe5dD1AOmgYkddssujjsqz6909%2B8W7wnC%2BEQ%40mail.gmail.com?utm_medium=email&utm_source=footer>
> .
>
--
Sent from Gmail Mobile
--
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/CAFh0iF8fA1tHsWO5k5cGmeSaqt2dZVJdBBmqJYLPcTuA1%2B8t9A%40mail.gmail.com.
