<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "bmkg";
$stasiun = $_POST['stsn'];
$source = $_POST['src'];
$balai = $_POST['REGION'];
$tanggal = $_POST['tanggal'];
$file = $_POST['file'];

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

$sql = "INSERT INTO transaksi (id_stasiun, id_source, ID_REGION,tanggal,data)
VALUES ('$stasiun', '$source', '$balai', '$tanggal','$file')";

if (mysqli_query($conn, $sql)) {
    echo '<script language="javascript">
	alert("Data Berhasil Di Input");
	window.location="index1.php";
	</script>';
	exit();
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

mysqli_close($conn);
?>