37 lines
1.3 KiB
PHP
37 lines
1.3 KiB
PHP
<?php
|
|
$Servername = ",,,.,,,.,,,.,,,:,,,,";
|
|
$username = "....";
|
|
$password = ".....";
|
|
$dbname = ".......";
|
|
$conn = new mysqli($Servername, $username, $password,
|
|
$dbname);
|
|
// Check connection
|
|
if ($conn->connect_error) {
|
|
die("Connection failed: " . $conn->connect_error);
|
|
}
|
|
// Retrieve data from GET request and allow null values
|
|
$voltage = isset($_GET['voltage']) ? $_GET['voltage'] :
|
|
null;
|
|
$pressure = isset($_GET['pressure']) ? $_GET['pressure']
|
|
: null;
|
|
$device = isset($_GET['device']) ? $_GET['device']:null;
|
|
$distance = isset($_GET['distance']) ? $_GET['distance']
|
|
: null;
|
|
$now = date('Y-m-d H:i:s'); // Get current timestamp
|
|
// Convert null values to 'NULL' for SQL insertion
|
|
$voltage = $voltage !== null ? "'$voltage'" : "NULL";
|
|
$pressure = $pressure !== null ? "'$pressure'" : "NULL";
|
|
$device = $device !== null ? "'$device'" : "NULL";
|
|
$distance = $distance !== null ? "'$distance'" : "NULL";
|
|
// Insert data into the database, allowing null values
|
|
$sql = "INSERT INTO sensor_data (voltage, pressure,
|
|
device_name, distance, created_at, updated_at)
|
|
VALUES ($voltage, $pressure, $device, $distance, '$now',
|
|
'$now')";
|
|
if ($conn->query($sql) === TRUE) {
|
|
echo "New record created successfully";
|
|
|
|
} else {
|
|
echo "Error: " . $sql . "<br>" . $conn->error;}
|
|
$conn->close();
|
|
?>
|