Pages: [1]   Go Down
Author Topic: PHP question: controlling Arduino over Ethernet using LAMP  (Read 1190 times)
0 Members and 1 Guest are viewing this topic.
0
Offline Offline
Newbie
*
Karma: 0
Posts: 15
Arduino rocks
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

I'm working on a data-logging project that connects an Arduino based weather-station to a linux server via ethernet. I'm using the LAMP stack on my server and am calling a PHP script to transfer sensor data from the Arduino to the server and store it in a MySQL database, and then another PHP script and Open Flash Chart v2 to to display the data in graphs. That part works pretty well.

Right now the weather station is programmed to automatically send its data to the server at a fixed interval. In addition to that, what I would like to be able to do is execute a PHP script on the linux server that tells the Arduino to take a current reading of all its sensors and send the data back to the server: I want to be able to remotely trigger a sensor poll.

I'm not very experienced with PHP. I can get the Arduino to wait, look, and interpret data coming from the server, but I have no idea what the PHP script to send data back over TCP/IP to the Arduino looks like. I imagine I have to define the Arduino's IP address, port, then initialize some sort of handshake with the Arduino, and send my data packet.

I don't really understand how to do that in PHP, or if it is even possible. Any suggestions, ideas, or example/pseudo code would be greatly appreciated!

Yours Truly.
Logged

0
Offline Offline
Newbie
*
Karma: 0
Posts: 15
Arduino rocks
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

If this wasn't the right forum to find help in, maybe a moderator could move my thread into the "Networking, Protocols, and Devices"-Forum?   

Much appreciated!
Logged

Miramar Beach, Florida
Offline Offline
Faraday Member
**
Karma: 115
Posts: 5371
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Here is another thread that covers php with an Arduino.
http://arduino.cc/forum/index.php/topic,124289.0.html
Code examples for both the Arduino and the server there.
Logged

ਪੰਜਾਬ
Offline Offline
Edison Member
*
Karma: 7
Posts: 1545
Another year! Alone! :(
View Profile
WWW
 Bigger Bigger  Smaller Smaller  Reset Reset

The way you can do it is change a SQL variable in database and conitnously just poll the script in arduino with a GET element and put that variable from your webserver to the similar variable defined in your uC programme and then utilise a IF statement to take action that's , What you have done already I have done that with both Ethernet ,WiFi and GPRS as well, I personally like to develop Internet of things systems with GPRS internet.
Logged

"Real Men can Accomplish  Anything"
-  Website  
- skype : nishants5  

ਫ਼ਤੇਹ ਕਰੂਂ !

0
Offline Offline
Newbie
*
Karma: 0
Posts: 15
Arduino rocks
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Thx SurferTim, but I got that part figured out pretty well!

Unfortunately polling the sensor is just the first step, a test to establish communication from the apache server to the arduino; the end goal is much more sophisticated: ultimately I want to be able to have a network that can handle dozens of sensor stations, with potentially hundreds of individual sensors. I want to be able to remotely adjust all kinds of settings on the sensor stations: recalibrating sensors, changing sensors poll intervals, setting clock chips, downloading/clearing micro sd backup data to name just a few. I don't know if the continuous polling method is suitable for a scenario where I want a large and growing number of sensor stations, that just seems like it would spell out trouble; wouldn't I essentially be doing a DDOS attack on my own server?

Is there a way that I could just execute a php GET on the server that contains a predefined data (maybe just a single character) and targets the IP of the Arduino sensor station? Does the Arduino have to answer in a specific way for the transaction to be completed?

I think what I am trying to do is possible, I just can't quite wrap my head around the actual coding part of it. I've been looking for some kind of example code, even if it were just some one who turned a LED on and off using a PHP script on an apache server with the arduino connected ethernet. Anyways, I appreciate all ideas and suggestions smiley

Logged

Miramar Beach, Florida
Offline Offline
Faraday Member
**
Karma: 115
Posts: 5371
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

I don't see a problem with what you want to do, but working out the details of each transaction will be your challenge. You may need to send more variables with the GET, and return more data from the server to the arduino and parse that out for your settings.

At 30 seconds per request, a couple dozen units should not be a problem. The exact number will depend on the server speed.

edit: I have added more code to the other thread in the link I posted above. I have the code sending a value every 30 seconds and inserting it into a database, and both are working well together. I recommend getting that working first, then go from there.
« Last Edit: September 26, 2012, 06:01:34 pm by SurferTim » Logged

Pages: [1]   Go Up
Jump to: