Retrieving sensor values from Arduino UNO via PHP GET

Hi! I have tried pretty much everything I could think of, and Google has not been of much help unfortunately…

Basically, I have built an Arduino UNO based Ethernet thermometer and its working GREAT thanks to the valuable help from this community!

Now I’d like to push the project a bit further and monitor the sensor’s output.

As it is now, I can access the ethernet thermometer’s webpage and see the sensor’s readings so I know the Arduino side of the project is working fine. I can also store values to a MySQL database fine via a PHP script so this is also working fine. Its getting the values from the Arduino that is puzzling me. I have tried several php scripts from the internet but none have been working…

My PHP script:

header('Content-type: text/plain');

$link = mysql_connect("localhost", "username", "password") or die("Cannot login to MySQL server!!: " . mysql_error());
mysql_select_db("arduino") or die("Unable to select DB!!");
$query = "INSERT INTO temp(temp_string_a, temp_string_b, temp_string_c, temp_string_d, temp_string_e) VALUES ('" . $_GET['temp_string_a'] . "', '" . $_GET['temp_string_b'] . "','" . $_GET['temp_string_c'] . "','" . $_GET['temp_string_d'] . "', '" . $_GET['temp_string_e'] . "')";$result = mysql_query($query) or die("Request failed!!: " . mysql_error());


The Arduino sketch (Special Thanks to the devs at for their sketch!!!) is attached to this post because the overall length exceeded the forum’s maximum post length

One of the things that worries me (and I think this is pretty normal) is the fact that the PHP code has no mean to retrieve from an ethernet connection… Nowhere I indicated the device’s IP… I am very useless in PHP programming and in C++ in general so please give me a chance… :wink:

Can anyone help me tie the two ends together and successfully retrieve the sensor’s data and store to the MySQL DB?

Thank you!!

arduino_r00.ino (7.04 KB)