<?php

// get the posted data
$DirectorID = 0; //0 means new thingy
    $DirectorName= "";
    $DirectorDOB ="";
     $DirectorNationality ="";
      


if(isset($_POST['DirectorID']))
    $DirectorID = $_POST['DirectorID'];

if(isset($_POST['DirectName']))
    $DirectorName = $_POST['DirectName'];

if(isset($_POST['DirectDOB']))
    $DirectorDOB = $_POST['DirectDOB'];

    if(isset($_POST['DirectNationality']))
    $DirectorNationality = $_POST['DirectNationality'];

    


// return to list or give error ???
if ($DirectorID == 0 && empty($DirectorName) && empty($DirectorDOB) && empty($DirectorNationality))
{
    $redirect = "location: index.php";
    header($redirect);
    exit();
    
}

// attempt to connect to the DB
$dbconn = mysqli_connect("localhost", "root", "", "moviedatabase");
if ($dbconn->connect_error > 0) {
    die('Could not connect: ' . $dbconn->connect_error);
    exit(); // you should redirect to some form of error page !!!!
}

// lets determine if this is a new Director or existing
if ($DirectorID == 0)
{
    // new Director- create the query (prepared statement
    $sql = $dbconn->prepare("INSERT INTO director (DirectorName,DirectorDOB,DirectorNationality) values (?,?,?)");
    $sql->bind_param('sss', $DirectorName, $DirectorDOB, $DirectorNationality);	
    // execute the query 
    $sql->execute();    
}
else
{
   // existing Director
    $sql = $dbconn->prepare("update director
                                    set DirectorName = ?, DirectorDOB = ?, DirectorNationality = ?
                                    where MovieID = ?");
    $sql->bind_param('sssi', $DirectorName, $DirectorDOB, $DirectorNationality, $DirectorID);	
    // execute the query 
    $sql->execute();      
}


// close the DB and connection
$sql->close();
$dbconn->close(); 

header('Location: index.php');
 ?>