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

6v6gt:
OK. Look very carefully at the example at https://www.arduino.cc/en/Tutorial/WebClient

I tried to run the webclient code and it successfully connected.

In my code, I've changed the code, and remove some code in void setup(), but still, my database cannot store the data from the sensor.

This is my code:

#include <Ethernet.h>
#include <SPI.h>

byte mac[] = { 0x00, 0xAA, 0xBB, 0xCC, 0xDE, 0x02 };
byte ip[] = { 192, 168, 0, 127 };
byte server[] = { 192, 168, 0, 121 };

//Initialize the Ethernet server library
EthernetClient client;

int LED = 13; // Use the onboard Uno LED
int isSensePin = 7;  // This is our input pin
int isSensePin2 = 8;
int isSensePin3 = 9;
int sensor1 = HIGH;  // HIGH MEANS NO OBSTACLE
int sensor2 = HIGH;
int sensor3 = HIGH;

void setup()
{
  pinMode(LED, OUTPUT);
  pinMode(isSensePin, INPUT);
  pinMode(isSensePin2, INPUT);
  pinMode(isSensePin3, INPUT);

  Serial.begin(9600);
  Ethernet.begin(mac, ip);
}


void loop()
{
  sensor1 = digitalRead(isSensePin);
  sensor2 = digitalRead(isSensePin2);
  sensor3 = digitalRead(isSensePin3);

  if (client.connect(server, 80))
  {
    Serial.println("---connection ok---");

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

    client.print(" HTTP/1.1");
    client.println("Host: 192.168.0.121");
    client.println("Connection: close");
    client.println();

    Serial.print("sensor1=");
    Serial.println(sensor1);
    Serial.print("sensor2=");
    Serial.println(sensor2);
    Serial.print("sensor3=");
    Serial.println(sensor3);

    client.stop();
  }

  else
  {
    Serial.println("---connection failed---\n");
    client.stop();
  }

  delay (500);

  
  if (sensor1 == LOW)
  {
    Serial.println("Occupied1");
    digitalWrite(LED, HIGH);
  }
  else
  {
    Serial.println("Available1");
    digitalWrite(LED, LOW);
  }
  delay(1000);

 
  if (sensor2 == LOW)
  {
    Serial.println("Occupied2");
    digitalWrite(LED, HIGH);
  }
  else
  {
    Serial.println("Available2");
    digitalWrite(LED, LOW);
  }
  delay(1000);

  
  if (sensor3 == LOW)
  {
    Serial.println("Occupied3");
    digitalWrite(LED, HIGH);
  }
  else
  {
    Serial.println("Available3");
    digitalWrite(LED, LOW);
  }
  delay(1000);
}