I'm having a problem receiving my data in Mysql data base

Projects Networking, Protocols, and Devices
1

Dear sir,
please help us
Through Arduino Uno + Ethernet-shield i am getting problems. i am writing two Arduino code 1 st one is running, send data to serial monitor & Mysql data base But my second Arduino Code running , send data to serial monitor but & data does not received in Mysql data base.

First Code

#include <SPI.h>
#include <Ethernet.h>
byte mac[] = { 0xDE, 0xAD, 0xBE, 0xEF, 0xFE, 0xED }; //Setting MAC Address

int ledPin=7;
int inPin=7;
int rpm;
char X;
int Time;
int val = 0;
int sensorPin = A0;
int sensorValue = 0;


char server[] = "192.168.137.1";
IPAddress ip(192,168,137,40); 
EthernetClient client; 

/* Setup for Ethernet and RFID */

void setup() {
 pinMode(ledPin,OUTPUT);
 pinMode(inPin, INPUT);
 Serial.begin(9600);
 if (Ethernet.begin(mac) == 0) {
 Serial.println("Failed to configure Ethernet using DHCP");
 Ethernet.begin(mac, ip);
 }
 delay(1000);
}
//------------------------------------------------------------------------------


/* Infinite Loop */
void loop(){
 long duration;
 val = digitalRead(inPin);
 digitalWrite(ledPin, val);
 duration = pulseIn(inPin, LOW);
 Time = duration/60;
 rpm= 600000/Time;
 Sending_To_phpmyadmindatabase(); 
 delay(10000); // interval
}


 void Sending_To_phpmyadmindatabase()   //CONNECTING WITH MYSQL
{
  if (client.connect(server, 80)) {
   Serial.println("connected");
   // Make a HTTP request:
   Serial.print("GET /testcode/dht.php?humidity=");
   client.print("GET /testcode/dht.php?humidity=");     //YOUR URL
   Serial.println(rpm);
   client.print(rpm);
   client.print("&temperature=");
   Serial.println("&temperature=");
   client.print(Time);
   Serial.println(Time);
   client.print(" ");      //SPACE BEFORE HTTP/1.1
   client.print("HTTP/1.1");
   client.println();
   client.println("Host: 192.168.137.1");
   client.println("Connection: close");
   client.println();
 } else {
   // if you didn't get a connection to the server:
   Serial.println("connection failed");
 }
}

Second Code

#include <SPI.h>
#include <Ethernet.h>
byte mac[] = { 0xDE, 0xAD, 0xBE, 0xEF, 0xFE, 0xED }; //Setting MAC Address

int ledPin=7;
int inPin=7;
int rpm;
char X;
int Time;
int val = 0;
int sensorPin = A0;
int sensorValue = 0;


char server[] = "192.168.137.1";
IPAddress ip(192,168,137,40); 
EthernetClient client; 

/* Setup for Ethernet and RFID */

void setup() {
 pinMode(ledPin,OUTPUT);
 pinMode(inPin, INPUT);
 Serial.begin(9600);
 if (Ethernet.begin(mac) == 0) {
 Serial.println("Failed to configure Ethernet using DHCP");
 Ethernet.begin(mac, ip);
 }
 delay(1000);
}
//------------------------------------------------------------------------------


/* Infinite Loop */
void loop(){
 long duration;
 val = digitalRead(inPin);
 digitalWrite(ledPin, val);
 duration = pulseIn(inPin, LOW);
 Time = duration/60;
 rpm= 600000/Time;
 if (rpm==-1){
   sensorValue = analogRead(sensorPin);
   if (sensorValue<20){
     char X[]="Weft St";}
   if (sensorValue >50 && sensorValue<350){
     char X[]="Warp St";}
   if (sensorValue > 800){
     char X[]="Weft Jam";}
   else {
      char X[]=" ";
   }
   }
 Sending_To_phpmyadmindatabase(); 
 delay(10000); // interval
}


 void Sending_To_phpmyadmindatabase()   //CONNECTING WITH MYSQL
{
  if (client.connect(server, 80)) {
   Serial.println("connected");
   // Make a HTTP request:
   Serial.print("GET /testcode/dht.php?humidity=");
   client.print("GET /testcode/dht.php?humidity=");     //YOUR URL
   Serial.println(rpm);
   client.print(rpm);
   client.print("&temperature=");
   Serial.println("&temperature=");
   client.print(X);
   Serial.println(X);
   client.print(" ");      //SPACE BEFORE HTTP/1.1
   client.print("HTTP/1.1");
   client.println();
   client.println("Host: 192.168.137.1");
   client.println("Connection: close");
   client.println();
 } else {
   // if you didn't get a connection to the server:
   Serial.println("connection failed");
 }
}

Thanks & best Regards
Pramod Goswami
Whats app No.:- +918058718545

2

data does not received in Mysql data base.

Sure, it is written to a variable defined locally and immediately thrown away:

   if (sensorValue<20){
     char X[]="Weft St";}
   if (sensorValue >50 && sensorValue<350){
     char X[]="Warp St";}

If you want to send that X variable to the PHP script, you have to define it correctly:

char * X;

and assign it correctly:

   if (sensorValue<20){
     X="Weft St";}
   if (sensorValue >50 && sensorValue<350){
     X="Warp St";}

(only part of your code, change the rest accordingly).