Hey there! I've been looking at some code examples, but they don't really do everything that I want. And I'm not perfectly understanding all the ways to use the SQL statements and such!
-- I have a project to try and get the Arduino to upload data to an SQL server! [url=https://pastebin.com/xyPvpj92]https://pastebin.com/xyPvpj92[/url] -This is the PHP code that sends data into SQL database (my version is secured when it comes to SQL injections, but this one works exactly the same way, just less secure). I wrote on this old topic long time ago and kinda gave up, but I revived the project for some days ago, and managed to send my data to my SQL using an Arduino by sending data in URL form and made the webpage I wrote in PHP to get variables from the URL and store it in the SQL database, everything works now! SQL database layout: - ID - Time (Date&Time) - Temperature reading - Humidity Reading - Radio signal - [img width=500 height=447]http://infernusweb.net/img/SQL-Data_Collected.png[/img] Now I'm trying to use Google Charts to make graphs with the data I collected. But I don't understand how to only load data from dateTime from the browser entered the site and maybe 31 days back in time. Is there a way to find out the time the page got loaded and then load 1 month of data? Or the last 24 hours? Also I want to use gauges or meters showing only the most latest reading, Something like "Temperature is now 26'C" Also some security related code would be nice, like blocking SQL injections and such! Also the time is in both date and time in the same value, so if there is no way to use a date with hours, minutes and seconds, I have to be able to truncate the numbers not needed, but I will want all the right numbers and time on the graph, but might have to be date and time seperately..? -- 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/d90ce2f3-bbe9-4603-a07b-2130d6144c9f%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
