Sending data from arduino to mysql database using ethernet shield v1

Projects Networking, Protocols, and Devices
1

I am trying to send the data read by the cheap RFID scanner to the mysql database, my program can access the database already but the problem is no data was been record , plain blank . Its my first time to use this module, Im not a good programmer Im willing to learn with your guidance ,I really need help heres my the code for arduino

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

#define RST_PIN 9
#define SDA_PIN 8 // slave for mfrc522

byte mac[] = { 0x00, 0xAA, 0xBB, 0xCC, 0xDE, 0x01 }; // RESERVED MAC ADDRESS
byte ip[] = { 192, 168 ,1 ,177 };
byte server[] = { 192, 168 ,1 ,38 };
EthernetClient client;

char str[32] = "";
byte readCard[4];
MFRC522 mfrc522(SDA_PIN, RST_PIN);

void setup(){
  Serial.begin(9600);
  Ethernet.begin(mac, ip);
  Serial.println("Check serial read");
  SPI.begin(); // Init SPI bus
  mfrc522.PCD_Init(); // Init MFRC522  
  Serial.print("server is at ");
  Serial.println(Ethernet.localIP());
}
void loop(){

  Readcard();
}

void Readcard(){
    while(mfrc522.PICC_IsNewCardPresent() && mfrc522.PICC_ReadCardSerial()){
   if (mfrc522.uid.uidByte[0] != readCard[0] || 
    mfrc522.uid.uidByte[1] != readCard[1] || 
    mfrc522.uid.uidByte[2] != readCard[2] || 
    mfrc522.uid.uidByte[3] != readCard[3] ) {
    Serial.println(F("A new card has been detected."));   
    for (int i = 0; i < 4; i++) { 
     readCard[i] = mfrc522.uid.uidByte[i];
     Serial.print(readCard[i], HEX);
    }
    array_to_string(readCard,4,str);
    Serial.println();
    Serial.println(str);

    int res = client.connect(server,80);
    Serial.println(res);
    if (res) {
    Serial.println("connected");
    // Make a HTTP request:
    Serial.println("Sending to Server: ");
    client.println("GET /add.php?");
    client.print("value=");
    client.print(str);
    client.println(" HTTP/1.1");
    client.println("Host: 192.168.1.38");
    client.println("Connection: close");
    client.println();
    client.println();
    client.stop();
    }else {
    // if you didn't get a connection to the server:
    Serial.println("connection failed");
  }
  }
   else Serial.println(F("Card read previously"));
  mfrc522.PICC_HaltA();
  mfrc522.PCD_StopCrypto1();
}
}
void array_to_string(byte array[], unsigned int len, char buffer[])
{
    for (unsigned int i = 0; i < len; i++)
    {
        byte nib1 = (array[i] >> 4) & 0x0F;
        byte nib2 = (array[i] >> 0) & 0x0F;
        buffer[i*2+0] = nib1  < 0xA ? '0' + nib1  : 'A' + nib1  - 0xA;
        buffer[i*2+1] = nib2  < 0xA ? '0' + nib2  : 'A' + nib2  - 0xA;
    }
    buffer[len*2] = '\0';
}

This is the php code

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "micro";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

	$temp1=$_GET['value'];
	echo "$temp1";
	$que = "INSERT INTO students(id_number, student_name) 
		VALUES ('$temp1' , '$temp1')";
   	
   	if($conn->query($que) == TRUE){
		echo "nice!";
	}
	else{
		echo $link->error();
	}

?>

And my database looks like this

So thanks in advance

22345430_1945311302162642_1589005630_o.png
22345430_1945311302162642_1589005630_o.png1085×146 28.2 KB

2

Try changing the first println to print. I do not understand the program or the php so this is just a guess.

    client.println("GET /add.php?");
    client.print("value=");
    client.print(str);
    client.println(" HTTP/1.1");
3

It works thanks sir :smiley: