Arduino Wireless Logging, Post Four: The Graphs

When I got all this data logged and running, I wanted an easier way to show data than spreadsheets or queries. The end goal was actual graphs to show trends and what not. Introducing “phpgraphlib”. This is an open source piece of code built to implement charts/graphs into webpages with ease. This took a bit of work, but here’s the idea behind it:

  • Be able to load a web page and show trends/data
  • Pull this information on demand from a database

Continue reading Arduino Wireless Logging, Post Four: The Graphs

Arduino Wireless Logging, Post Three: Mysql, PHP, and a little networking

Here’s where things started to get a little more complex. At this point, I have a wireless system to transmit data from multiple nodes to a central hub (node0) which collects and shows the data via serial connection.

The general idea/goal is this:

  • Arduino Nodes send data to central node
  • Central node is connected to home network and sends this data to a LAMP server (Linux-Apache-Mysql-PHP)
  • The server takes this data, breaks it into a mysql statement, and pushes it into the database to log

Continue reading Arduino Wireless Logging, Post Three: Mysql, PHP, and a little networking

Arduino Wireless Logging, Post Two: The Design

This is the second part of the series for my Arduino wireless project I’ve been working on for a couple weeks now. You can start reading from the first post: https://aasullivan.com/?p=1146.

We have the idea, now we have to build it. I have three Arduinos set up at this point in this manner:

  • (1) Set up as wireless receiver/hub; this will read data, print to Serial and log to ethernet eventually
  • (2) Transmitters which simply read data every ~5 seconds to blindly send to receiver (node 0)

This layout will allow me to test from a couple devices to make sure the layout of the node IDs will work properly and be read properly as well. I ran into my first set of issues at this point: I can only read one Arduino at a time off Serial from the IDE, so went and imaged an older Dell D630 to handle the receiving end of things to troubleshoot the payload issues I ran into.  Continue reading Arduino Wireless Logging, Post Two: The Design

Arduino Wireless Logging, Post One: The Idea

I’ve had a number Arduino systems for some time now along with a large number of RF24 wireless modules and DHT11 humidity/temperature sensors. The idea I’ve had for some time is this:

  1. Arduino with a DHT11 sensor and RF24 wireless device pull then transmit data.
  2. Data goes to secondary hub/master Arduino using an RF24 module along with an Ethernet adapter (Wiznet 5100)
  3. This master hub then pushes the data to a web server containing a mysql database to log and store the information

Simple right? Wrong.

Continue reading Arduino Wireless Logging, Post One: The Idea