php

<?php
//INISIALISASI VARIABEL UNTUK KONEK KE MY SQL
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "uts";
//MENDAPATKAN NILAI RATA2,MINIMAL,MAKSIMAL SUHU DAN RATA2,MINIMAL,MAKSIMAL LEMBAB MENGGUNAKAN METODE GET PADA HTTP
if( $_GET["avg_suhu"] || $_GET["min_suhu"] || $_GET["max_suhu"] || $_GET["avg_lembab"] || $_GET["min_lembab"] || $_GET["max_lembab"] ){
	$avg_suhu = $_GET["avg_suhu"];
	$min_suhu = $_GET["min_suhu"];
	$max_suhu = $_GET["max_suhu"];
	$avg_lembab = $_GET["avg_lembab"];
	$min_lembab = $_GET["min_lembab"];
	$max_lembab = $_GET["max_lembab"];

	//PEMBENTUKAN KONEKSI DENGAN DATABASE MYSQL
$conn = new mysqli($servername, $username, $password, $dbname);
	//CEK KONEKSI APAKAH EROR
if($conn->connect_error){
	die("Connection failed : ". $conn->connect_error);
}
//UNTUK MEMASUKKAN DATA RATA2,MINIMAL,MAKSIMAL SUHU DAN RATA2,MINIMAL,MAKSIMAL LEMBAB
$sql = "INSERT INTO uts_piranti (avg_suhu, min_suhu, max_suhu, avg_lembab, min_lembab, max_lembab) VALUES (".$avg_suhu.",".$min_suhu.",".$max_suhu.",".$avg_lembab.",".$min_lembab.",".$max_lembab.")";
//MENJALANKAN SQL
if($conn->query($sql) === TRUE){
	echo "New record created successfully";
} else {
	echo "Error : ".$sql."<br>".$conn->error;
}
//MENUTUP OBJEK KONEKSI KE SQL
$conn->close();
exit();
}
?>