<?php  
include("../../connection.php");
date_default_timezone_set('Australia/Perth'); 
$currentDate = date('d-M-Y');

$name = mysqli_real_escape_string($con, $_POST['title']);
$desc = mysqli_real_escape_string($con, $_POST['description']);
if($_FILES["image"]["name"]==""){
      $im_empty = 'yes';  
      $path_img2 = '';
    }else{
        $im_empty = 'no';
        
$target_path2 = "images/";  
$target_path2 = $target_path2.basename( $_FILES['image']['name']);   


$path_img2 = 'dashboard/include/images/';


  
if(move_uploaded_file($_FILES['image']['tmp_name'], $target_path2)) {  
    $path_img2 = $path_img2.$_FILES['image']['name']; 
} else{  
    echo "Sorry, file not uploaded, please try again!";  
} 
    }


        $query = "insert into flights(`title`,`image`,`description`) VALUES ('".$name."','".$path_img2."','".$desc."')";


    
            $s = mysqli_query($con,$query);
            
            if($s){
                echo "<script>
alert('Added Successfully.');
window.location.href='../home.php';
</script>";
            }else
            {
                echo "<script>
alert('Error.');
window.location.href='../home.php';
</script>";
            }
            

            
            


?>