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

Projects Programming
2

OK. The PHP code works when you type a URL manually in a web browser. Something like:

http://192.168.0.121/arduino/getdata.php?sensor1=91&sensor2=92&sensor3=93

If that is the case, this is odd:

    client.print("GET /arduino/getdata.php?");
    client.print("sensor1 = ");
    client.print(sensor1);
    client.print("&sensor2 = \n");
    client.print(sensor2);
    client.print("&sensor3 = \n");
    client.print(sensor3);

maybe this instead ?:

    client.print("GET /arduino/getdata.php?");
    client.print("sensor1=");
    client.print(sensor1);
    client.print("&sensor2=");
    client.print(sensor2);
    client.print("&sensor3=");
    client.print(sensor3);

You have also structured your loop() oddly, in that if this test fails:

if (rc)

You carry on at this statement instead of giving up:

delay (500);

  sensor1 = digitalRead(isSensePin);
  if (sensor1 == LOW)
  {
    Serial.println("Occupied1");
    digitalWrite(LED, HIGH);
  }
  . . .
  . . .

You are not using status.php in your Arduino code.