We have sensors around the building that monitor the temp and humidity and save the data to a text file on our server. We would like to be able to use this data to create a line graph based on choosing the day or period selected. I assume this data will have to be imported to a database, then use php to display the line graph based on the selected data. Anyone having idea how to do this please answer this post. We already have php and mysql on server so that is not an issue. Just wondering how this would be accomplished for example: display line graph of temp and humidity for June 2-18, 2009. Or show line graph of temps from 12:00am Monday to 11:59pm Friday. Any help appreciated 🙂

P.S. The sensors write to the text file about every 15 minutes, every day. (constantly monitoring).

    Take a look at http://jpgraph.net/ , but check out their license policy to find out if you can use the free versjon, or need the pro one.

    There are lots of examples in their documentation. The examples also shows the code that creates the image, so its easy to copy, paste and modify. For the most part you only need to add/replace the "we need some data" part of the example code with some code that fetches the needed data from the database.

      Thanks for the info. I hadn't thought about a commercial software solution. The pro version single license is only about 100 bucks so I will experiment with it over the next few days. It looks like it will do what we need.

        when im lazy, i usually end up using google charts its quite easy to implement for nay project with nothing to install.

          Write a Reply...