Hi Guys:
I'm looking for some help on creating a basic line chart on my hosted web server I built using a Raspberry Pi. I'm running a LAMP (Linux, Apache, MySQL, PHP) system. I have a Python script that continuously runs and collects the weather data from various sensors and in 5 minute intervals, writes the data into the appropriate columns into the database table. Then web server who is running the PHP script, retrieves the appropriate data from the table and displays it into a web format. <https://lh3.googleusercontent.com/-f4hE368KoH4/V7DD1_EqxFI/AAAAAAAAACs/aYIH9ow2F6E8rMb88LK_-8i3On4TRjSPQCLcB/s1600/Screen%2BShot%2B2016-08-14%2Bat%2B3.17.13%2BPM.png> The screen shot above shows the weather data being displayed and updating every 5 minutes. So now the next thing I want to do is to add a basic line graph (using google charts) that connects to my database and then displays that information at the bottom. For starters, lets say I just want to graph the temperature (y-axis) vs. the time (x-axis). This data is already stored and available in my database table (see below). <https://lh3.googleusercontent.com/-P80QqWwAnVI/V7DEciEqyjI/AAAAAAAAACw/_GJsCDhtKNwEpzokecMOz9ehrtAtqz_gACLcB/s1600/Screen%2BShot%2B2016-08-12%2Bat%2B4.12.14%2BPM.png> So, if you look at my table columns, you can see I have the temperature readings (column = temperature) and then the date/time (column = stamp). So the goal is to take my current code in my index file (file used on web-server) and the code to create this simple graph. Lastly, I've included a copy of my current PHP code that displays the data. I'm very illiterate on this interface I'm trying to build but any help is greatly appreciated. <https://lh3.googleusercontent.com/-DTH_3ELRnJs/V7DGULZe4OI/AAAAAAAAAC8/35k_kQGfoLYPxJz6F2oUbXA-26yUppwWwCLcB/s1600/Screen%2BShot%2B2016-08-14%2Bat%2B3.26.04%2BPM.png> <https://lh3.googleusercontent.com/-xGR20DKt6V0/V7DJTpHkjmI/AAAAAAAAADg/ckTRTzdPEaoxcek5oM3WWkS4ZBcYNbQ_wCLcB/s1600/Screen%2BShot%2B2016-08-14%2Bat%2B3.40.25%2BPM.png> <https://lh3.googleusercontent.com/-WTZTFjSQAyU/V7DGmSZDCyI/AAAAAAAAADI/sFVjHQrHKM8eJk2W6QRv8ckgtYc0KO2UACLcB/s1600/Screen%2BShot%2B2016-08-14%2Bat%2B3.27.19%2BPM.png> Thanks, Andrew -- 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 https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/68f31130-5a4c-4ae1-b2b4-a5b65acf43d9%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
