My sensor send values 0 to my database in MySQL ESP32

Projects Programming
1

Good afternoon, I'm doing a project where I use a ESP32 wifi module and a uv sensor. This will allow me to capture the intensity and the uv index that is recorded in real time. The problem is that I made my connections, I created my database in phpmyadmin with Windows and it sends me values ​​in 0, but I wanted to do the same in Ubuntu via wifi but it does not send anything. What I'm looking for is that you can send the data to Ubuntu and send me the data that is registered, not that sent 0.

I do not know what can happen or that I will have bad in my code, beforehand thanks to the people who answer this question. I'll leave the php code and my Arduino code. Thank you!

It's my first time doing a post here, if I have something wrong an apology in advance.

Arduino Code.

#include <WiFi.h>
int UVsensorIn = A0; //salida del sensor
const char* ssid = "INFINITUMBAF06B";
const char* password = "9983955063";

const char* host = "192.168.1.82";

void setup()
{
pinMode(UVsensorIn, INPUT);
Serial.begin(115200);

// We start by connecting to a WiFi network

Serial.println();
Serial.println();
Serial.print("Connecting to ");
Serial.println(ssid);

WiFi.begin(ssid, password);

while (WiFi.status() != WL_CONNECTED) {
delay(500);
Serial.print(".");
}

Serial.println("");
Serial.println("WiFi connected");
Serial.println("IP address: ");
Serial.println(WiFi.localIP());
}

int value = 0;

void loop()
{
int uvLevel = averageAnalogRead(UVsensorIn);

float outputVoltage = 3.3 * uvLevel/4095;
float uvIntensity2 = mapfloat(outputVoltage, 0.99, 2.9, 0.0, 15.0);
++value;
int uvIntensity=uvIntensity2*100;
int variable = 5;

Serial.print("connecting to ");
Serial.println(host);

// Use WiFiClient class to create TCP connections
WiFiClient client;
const int httpPort = 80;
if (!client.connect(host, httpPort)) {
Serial.println("connection failed");
return;
}

Serial.println(uvIntensity);

// We now create a URI for the request
String url = "/SunLight/config.php/";
String indice_uv = "&indice_uv=";

Serial.print("Requesting URL: ");
Serial.println(url);

// This will send the request to the server
client.print(String("GET http://192.168.1.84/SunLight/config.php?variable=") + variable + " HTTP/1.1\r\n" +
"Host: " + host + "\r\n" +
"Connection: close\r\n\r\n");
unsigned long timeout = millis();
while (client.available() == 0) {
if (millis() - timeout > 5000) {
Serial.println(">>> Client Timeout !");
client.stop();
return;
}
}

// Read all the lines of the reply from server and print them to Serial
while(client.available()) {
String line = client.readStringUntil('\r');
Serial.print(line);
delay(10000);
}

Serial.println();
Serial.println("closing connection");
}
//Takes an average of readings on a given pin
//Returns the average
int averageAnalogRead(int pinToRead)
{
byte numberOfReadings = 8;
unsigned int runningValue = 0;

for(int x = 0 ; x < numberOfReadings ; x++)
runningValue += analogRead(pinToRead);
runningValue /= numberOfReadings;

return(runningValue);

}

float mapfloat(float x, float in_min, float in_max, float out_min, float out_max)
{
return (x + in_min) * (out_max - out_min) / (in_max - in_min) + out_min;
}

PHP Code

<?php $conexion=mysqli_connect('localhost','root','','sensor'); $sql = "INSERT INTO valores (indice_uv) VALUES ('".$_GET["$uvIntensity"]."')"; echo mysqli_query($conexion,$sql); ?>