40 lines
1.4 KiB
PHP
40 lines
1.4 KiB
PHP
<?php
|
|
// Koneksi ke database
|
|
$servername = "localhost";
|
|
$username = "u451812435_NelsenProject";
|
|
$password = "Nelsen123.";
|
|
$database = "u451812435_NelsenProject";
|
|
|
|
$conn = new mysqli($servername, $username, $password, $database);
|
|
|
|
// Periksa koneksi
|
|
if ($conn->connect_error) {
|
|
die("Koneksi ke database gagal: " . $conn->connect_error);
|
|
}
|
|
|
|
// Ambil data dari payload JSON
|
|
$postData = json_decode(file_get_contents("php://input"));
|
|
|
|
if ($postData && isset($postData->soil_moisture) && isset($postData->buzzer_state) && isset($postData->relay_state) && isset($postData->kebun_id) && isset($postData->created_at)) {
|
|
$calibratedMoisture = floatval($postData->soil_moisture); // Konversi nilai menjadi float
|
|
$buzzerState = $postData->buzzer_state;
|
|
$relayState = $postData->relay_state;
|
|
$kebun_id = intval($postData->kebun_id);
|
|
$created_at = $postData->created_at;
|
|
|
|
// Simpan data ke database
|
|
$sql = "INSERT INTO sensors (calibrated_moisture, buzzer_state, relay_state, kebun_id, created_at) VALUES ('$calibratedMoisture', '$buzzerState', '$relayState', '$kebun_id', '$created_at')";
|
|
|
|
if ($conn->query($sql) === TRUE) {
|
|
echo "Data berhasil disimpan ke database.";
|
|
} else {
|
|
echo "Error: " . $sql . "<br>" . $conn->error;
|
|
}
|
|
} else {
|
|
echo "Data kelembaban tanah, buzzer state, relay state, kebun_id atau timestamp tidak diterima atau tidak lengkap.";
|
|
}
|
|
|
|
// Tutup koneksi
|
|
$conn->close();
|
|
?>
|