<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "bmkg";
$stasiun = $_POST['stsn'];
$source = $_POST['src'];
$balai = $_POST['region'];
$tanggal = $_POST['tanggal'];
$file = $_POST['file'];
$target_dir = "upload";
$target_file = $target_dir . basename($_FILES["fileToUpload"]["file"]);
$uploadOk = 1;
$FileType = pathinfo($target_file,PATHINFO_EXTENSION);

// 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($FileType != "jpg" && $FileType != "png" && $FileType != "jpeg"
&& $FileType != "pdf" ) {
    echo "Sorry, only JPG, JPEG, PNG & PDF files are allowed.";
    $uploadOk = 0;
}

if ($uploadOk == 0) {
    echo "Sorry, your file was not uploaded.";
// if everything is ok, try to upload file
} else {
    if (move_uploaded_file($_FILES["fileToUpload"]["file"], $target_file)) {
        echo "The file ". basename( $_FILES["fileToUpload"]["file"]). " has been uploaded.";
    } else {
        echo "Sorry, there was an error uploading your file.";
    }
}

if (mysqli_query($conn, $sql)) {
    echo 'msk';
	exit();
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

mysqli_close($conn);
?>