Sending data to a page using the ESP8266-01 wifi-module from Arduino

Question

Hi friends, I've been using my Arduino Uno to put together an attendance system through a rfid reader using an esp8266-01 wifi module. What need is to do is store the unique id number in a database after reading it from a webpage where the rfid card publishes it. The webpage is coded in PHP. And, I've been sending commands to the Wi-Fi module from arduino ide serial monitor through the Uno board.
I initially tried using Serial_ophttp POST method to send it to the webpage and also the GET method, but couldn't get it to work.

    <?php
    error_reporting(E_ALL ^ E_DEPRECATED);
    $dbhost = 'localhost';
    $dbuser = 'root';
    $dbpass = '';
    $conn = mysql_connect($dbhost, $dbuser, $dbpass);
    if(! $conn ) {
    die('Could not connect: ' . mysql_error());
    }
    $Data=$_GET['Data'];
    //$Data='Data test';
    echo "Data is :" . $Data;
    $sql = "INSERT INTO test_tab (Data) VALUES ('$Data')";
    mysql_select_db('robot');
    $retval = mysql_query( $sql, $conn );
    if(! $retval ) {
    die('Could not enter data: ' . mysql_error());
    }   
    echo "Entered data successfully\n";
    mysql_close($conn);
    ?>

Answer 1

Well, I think there are some \r \n missing in them and also, the AT+CIPSEND is being sent the wrong length.
You should try sending it again, like this:

AT+CIPSEND=43\r\n
GET /test.php?Data=2\r\nHost:192.168.1.13\r\n\r\n

Just hit enter to send \r\n and ensure that you select "Both NL & CR" in your serial monitor. And of course, you will need to hit Enter twice at the end.

So, here I am sending 2 as my value and hence, after subtracting the 1 for every \r & \n from the size o your GET(), i.e., 49 will become 49 - 6 = 43.

Try to send the value directly from the URL and make sure that your PHP script is error-free and working.