问Arduino没有正确地将数字发送到SQL (通过PHP)

EN

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

int rand1 = 0;
int rand2 = 0;



//EthServer(80);

//IPAddress server(10,0,0,1);
char server[] =("10.0.0.1");



EthernetClient client;


byte mac[] = {
  0x00, 0xAA, 0xBB, 0xCC, 0xDE, 0x0
};

byte ip[] = { 10, 0, 0, 2 }; 



void setup(void)
{
  // start serial port
  Serial.begin(9600);
  Ethernet.begin(mac, ip);
}

void printIPAddress()
{
  Serial.print("My IP address: ");
  for (byte thisByte = 0; thisByte < 4; thisByte++) {
    // print the value of each byte of the IP address:
    Serial.print(Ethernet.localIP()[thisByte], DEC);
    Serial.print(".");
  }

  Serial.println();
}

 void loop() {

  delay(1000);
    rand1 = random(1, 3);
    rand2 = random(25);
    Serial.println(rand1);
    Serial.println(rand2);

 // Connect to the server (your computer or web page)  
  if (client.connect(("http://10.0.0.1"), 80)) {
    client.print("GET /myapp/write_data.php?"); // This
    client.print("value1="); // This
    client.print(rand1); // And this is what we did in the testing section above. We are making a GET request just like we would from our browser but now with live data from the sensor
    client.print(";");
    client.print("value2=");
    client.print(rand2);
    client.println(" HTTP/1.1"); // Part of the GET request
    client.println("Host: 10.0.0.1"); // IMPORTANT: If you are using XAMPP you will have to find out the IP address of your computer and put it here (it is explained in previous article). If you have a web page, enter its address (ie.Host: "www.yourwebpage.com")
    client.println("Connection: close"); // Part of the GET request telling the server that we are over transmitting the message
    client.println(); // Empty line
    client.println(); // Empty line
    client.stop();    // Closing connection to server
  }
    else {

    // If Arduino can't connect to the server (your computer or web page)
    Serial.println("--> connection failed\n");
    printIPAddress();

  }
  delay(10000);

}

    //connect

    $link=new mysqli("localhost", "root", "", "myappdb");

    //check connection

    if ($link==false) {
        die("Connection failed: " . mysqli_connect_error());
        } 


    //insert values

    $sql = "INSERT INTO resistence (phase, max_reading) 
            VALUES (". $_GET['value1'] .",". $_GET['value2'].")";

    //// Check if values have been inserted, confirm with user that values are correct.

    if(mysqli_query($link, $sql)){

        echo "Records inserted successfully.";
        echo "Values inserted are Phase " . $_GET['value1']. " and Max_Reading ". $_GET['value2']. ".";
    }
        else
    {
        echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
    }

    /////


//close connection
mysqli_close($link);

?>