DATALOGGER

28Feb07

For this exercise in Sensor Workshop i decided to try the third option in the given data-logging methods:
1. Arduino -> Processing -> PHP -> Text
2. Arduino -> Processing -> PHP -> MySQL
3. Arduino -> Xport -> PHP -> MySQL
Sending the byte value from the Arduino through the Lantronics XPortxport-data.jpg

where it calls upon a php script to write the incoming values and time stamp into a mySQL table on the itp server. Through much trial and error due o lack of experience with mySQL and php, i managed to get this. But half way though, and in the midst of WTF!!!, i did the first option – just in case. Here’s a screen shot of the data stored from a potentiometer.

picture-2.png

I had worked with the XPort before, though not in conjunction with php and mySQL. The starting point in the code was taken from here.

My first mySQL setup, ever:

picture-5.png

Ardunio was calling the server and waiting for it to respond, waiting for an ASCI “C” to be sent back to let it know that it had connected. I however did not get that message. As seen in terminal through telnet:picture-1.png

picture-4.png

As yet, i do not know the reasons why….

Advertisements


No Responses Yet to “DATALOGGER”

  1. Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: