Send data to MySQL (Arduino Uno, Eth shield W5100, IR obstacle sensor) [solved]

OK. I'm happy that problem has been solved.

Do I understand your next question correctly ? When a user types http://192.168.0.121/arduino/status.php in a web browser, you want to display some images and the images displayed should be dependent on the value of the sensor readings ? For example, if sensor1 returns a value of 0, you want to display a specific image and if sensor 1 returns a value of 1 you want to display another ?

If so, that is a pure PHP/HTML matter and really nothing more to do with an Arduino.

You would progress as follows:

  1. Identify some images you want to use and store these in such a way that these are accessible from you web server using, for example the link http://192.168.0.121/arduino/image1.jpg , http://192.168.0.121/arduino/image2.jpg etc.

  2. Write some test html which formats the page you want to display to the user, which includes the images.

  3. once you are happy with the display format, embed the essential elements of the html in the PHP script and make the display of the images conditional on the sensor results retrieved from the database.