addnew.php

<?php
include('conn.php');
    if(isset($_POST['add_new_hotel'])){
        $nm_htl=$_POST['nama_htl'];
		$city=$_POST['city_n'];
        $desk_htl=$_POST['desk_htl'];
		$pass=$_POST['pass'];
			
				
$target_dir = "img/collectionRoom/";
$target_file = $target_dir . basename($_FILES["fileToUpload"]["name"]);
$uploadOk = 1;
$imageFileType = strtolower(pathinfo($target_file,PATHINFO_EXTENSION));
// Check if image file is a actual image or fake image
if(isset($_POST["submit"])) {
    $check = getimagesize($_FILES["fileToUpload"]["tmp_name"]);
    if($check !== false) {
       echo "File is an image - " . $check["mime"] . ".";
        $uploadOk = 1;
    } else {
        echo "File is not an image.";
        $uploadOk = 0;
    }
}
// Check if file already exists
if (file_exists($target_file)) {
   echo "Sorry, file already exists.";
    $uploadOk = 0;
}
// Check file size
if ($_FILES["fileToUpload"]["size"] > 500000) {
   echo "Sorry, your file is too large.";
    $uploadOk = 0;
}
// Allow certain file formats
if($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg"
&& $imageFileType != "gif" ) {
   echo "Sorry, only JPG, JPEG, PNG & GIF files are allowed.";
    $uploadOk = 0;
}
// Check if $uploadOk is set to 0 by an error
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"]["tmp_name"], $target_file)) {
               $queryAdd ="INSERT INTO `hotel` (`nm_htl`,`pas` ,`city` ,`desc`, `photo_dir`, `counter`) VALUES ('$nm_htl','$pass', '$city','$desk_htl', '$target_file', '0')";
				mysqli_query($conn,$queryAdd);
				header("location:backend/index.html");
    } else {
        echo "Sorry, there was an error uploading your file.";
    }
}
header("location:backend/index.html");
    }
?>