<?php

//CREATE DATABASE CONNECTION

$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
$dbname = "movie-club";

$conn = mysqli_connect("$dbhost", "$dbuser", "$dbpass", "$dbname");

// Test if there was a connection made.

if(mysqli_connect_errno()){
	die("Database connection failed: " .
	     mysqli_connect_error() .
		 " (" . mysqli_connect_errno() . ")"
		 );
}

?>

 <?php
 
//PERFORM DATABASE QUERY 

	 
$title = "title";
$dateOfRelease = "dateOfRelease";
$length = "length";
$genre = "genre";
$directorFirstName = "directorFirstName";
$directorLastName = "directorLastName";
$directorGender = "directorGender";
$directorNationality = "directorNationality";
$producerFirstName = "producerFirstName";
$producerLastName = "producerLastName";
$producerGender = "producerGender";
$producerNationality = "producerNationality";
$nationality = "nationality";
$starFirstName = "starFirstName";
$starLastName = "starLastName";
$distributor = "distributor";
$selectStarRating = "selectStarRating";

$query1 = "INSERT INTO movie (Title, ReleaseDate, MinuteLength)
VALUES ('$title', '$dateOfRelease', '$length')";

$query2 = "INSERT INTO genre (Genre)
VALUES ('$genre')";

$query3 = "INSERT INTO director (Fname, Lname, Gender)
VALUES ('$directorFirstName', '$directorLastName', '$directorGender')";

$query4 = "INSERT INTO producer (Fname, Lname, Gender)
VALUES ('$producerFirstName', '$producerLastName', '$producerGender')";

$query5 = "INSERT INTO nationality (Nationality)
VALUES ('$nationality')";

$query6 = "INSERT INTO star (Fname, Lname)
VALUES ('$starFirstName', $starLastName')";

$query7 = "INSERT INTO distributor (Name)
VALUES ('$distributor')";

$query8 = "INSERT INTO rating (Description)
VALUES ('$selectStarRating')";



//Test if there was a query error
  $result1 = mysqli_query($conn, $query1);
 if ($result1) {
	 //Query successful
	 echo ("Thank you for submitting your movie to our database.");
 }
 else{
	 //Query Failure
	die("Database update failed." . mysqli_error($conn)); 
 }
 
 $result2 = mysqli_query($conn, $query2);

//Test if there was a query error
 
 if ($result2) {
	 //Query successful
	 echo ("Thank you for submitting your movie to our database.");
 }
 else{
	 //Query Failure
	die("Database update failed." . mysqli_error($conn)); 
 }
 
 $result3 = mysqli_query($conn, $query3);

//Test if there was a query error
 
 if ($result3) {
	 //Query successful
	 echo ("Thank you for submitting your movie to our database.");
 }
 else{
	 //Query Failure
	die("Database update failed." . mysqli_error($conn)); 
 }
 
 $result4 = mysqli_query($conn, $query4);

//Test if there was a query error
 
 if ($result4) {
	 //Query successful
	 echo ("Thank you for submitting your movie to our database.");
 }
 else{
	 //Query Failure
	die("Database update failed." . mysqli_error($conn)); 
 }
 
  $result5 = mysqli_query($conn, $query5);

//Test if there was a query error
 
 if ($result5) {
	 //Query successful
	 echo ("Thank you for submitting your movie to our database.");
 }
 else{
	 //Query Failure
	die("Database update failed." . mysqli_error($conn)); 
 }

 
 $result6 = mysqli_query($conn, $query6);

//Test if there was a query error
 
 if ($result6) {
	 //Query successful
	 echo ("Thank you for submitting your movie to our database.");
 }
 else{
	 //Query Failure
	die("Database update failed." . mysqli_error($conn)); 
 }

  $result7 = mysqli_query($conn, $query7);

//Test if there was a query error
 
 if ($result7) {
	 //Query successful
	 echo ("Thank you for submitting your movie to our database.");
 }
 else{
	 //Query Failure
	die("Database update failed." . mysqli_error($conn)); 
 }
 
 
  $result8 = mysqli_query($conn, $query8);

//Test if there was a query error
 
 if ($result8) {
	 //Query successful
	 echo ("Thank you for submitting your movie to our database.");
 }
 else{
	 //Query Failure
	die("Database update failed." . mysqli_error($conn)); 
 }


 
 ?>






 
 
<!doctype html>

<html lang="en">
<head>
  <meta charset="utf-8">
  <title>The Movie Club - Add movie</title>
  <link rel="stylesheet" href="movieClubStyles.css">
</head>

<body>


  <H1>Add a Movie</H1>
  <h2>Help us decide which movie to show at our next Movie Club night!</h2>
  <br><br><br><br>
  
  <?php
//define error variables

$titleErr = $dateOfReleaseErr = $lengthErr = $genreErr = $directorFirstNameErr = $directorLastNameErr = $directorGenderErr = 
$directorNationalityErr = $producerFirstNameErr = $producerLastNameErr = $producerGenderErr = $producerNationalityErr = 
$starFirstNameErr = $starLastNameErr = $distributorErr = $selectStarRatingErr = "";

//define each field variable and initialise with empty value

$title = $dateOfRelease = $length = $genre = $directorFirstName = $directorLastName = $directorGender = 
$directorNationality = $producerFirstName = $producerLastName = $producerGender = $producerNationality = 
$starFirstName = $starLastName = $distributor = $selectStarRating = "";





if ($_SERVER["REQUEST_METHOD"] == "POST") {
    if (empty($_POST["title"])) {
        echo $titleErr = "Please enter the title of the movie <br><br>";
    }
    else {
        $title = $_POST["title"]; 
    }

    if (empty($_POST["dateOfRelease"])) {
        echo $dateOfReleaseErr = "Please enter the date of release <br><br>";
    }
    else {
        $dateOfRelease = $_POST["dateOfRelease"];
    }
	
	

    if (empty($_POST["length"]))  {
       echo $lengthErr = "Please enter the length of the movie in minutes - no decimals <br><br>";
    }
    else {
        $length = $_POST["length"];
    }
	$int = "length";
	$min = "2";
	$max = "3";
	if(filter_var($int, FILTER_VALIDATE_INT, array ("options" => array("min_range" < $min, "max_range" > $max))) === false) {
		
		echo ("Please enter a minimum of two digits, or a maximum of three digits for the movie length <br><br>");
		
	} else {
		
		echo("");
	}

    if (!isset($_POST["genre"])) {
        echo $genreErr = "You must select a genre from the drop-down list <br><br>";
    }
    else {
        $genre = $_POST["genre"];
    }

    if (empty($_POST["directorFirstName"])) {
        echo $directorFirstNameErr = "Please enter the first name of the director <br><br>";
    }
    else {
        $directorFirstName = $_POST["directorFirstName"];
			
    }
	 if (empty($_POST["directorLastName"])) {
        echo $directorLastNameErr = "Please enter the last name of the director <br><br>";
    }
    else {
        $directorLastName = $_POST["directorLastName"];
    }
	
	 if (empty($_POST["directorGender"])) {
       echo $directorGenderErr = "Please select gender of director from the drop-down list <br><br>";
    }
    else {
        $directorGender = $_POST["directorGender"];
    }
		 if (empty($_POST["directorNationality"])) {
        echo $directorNationalityErr = "Please select the nationality of the director from the drop-down list <br><br>";
    }
    else {
        $directorNationality = $_POST["directorNationality"];
    }
	
	 if (empty($_POST["producerFirstName"])) {
       echo $producerFirstNameErr = "Please enter the first name of the producer <br><br>";
    }
    else {
        $producerFirstName = $_POST["producerFirstName"];
    }
	
	 if (empty($_POST["producerLastName"])) {
        echo $producerLastNameErr = "Please enter the last name of the producer <br><br>";
    }
    else {
        $producerLastName = $_POST["producerLastName"];
    }
	 if (empty($_POST["producerGender"])) {
        echo $producerGenderErr = "Please select gender of producer from the drop-down list <br><br>";
    }
    else {
        $producerGender = $_POST["producerGender"];
    }
	 if (empty($_POST["producerNationality"])) {
       echo $producerNationalityErr = "Please select nationality of producer from the drop-down list <br><br>";
    }
    else {
        $producerNationality = $_POST["producerNationality"];
    }
	 if (empty($_POST["starFirstName"])) {
        echo $starFirstNameErr = "Please enter the first name of the star <br><br>";
    }
    else {
        $starFirstName = $_POST["starFirstName"];
    }
	 if (empty($_POST["starLastName"])) {
       echo $starLastNameErr = "Please enter the last name of the star <br><br>";
    }
    else {
        $starLastName = $_POST["starLastName"];
    }
	 if (empty($_POST["distributor"])) {
       echo $distributorErr = "Please select the distributor from the drop-down list <br><br>";
    }
    else {
        $distributor = $_POST["distributor"];
    }
	 if (empty($_POST["selectstarRating"])) {
       echo $selectStarRatingErr = "Please select your star rating from the drop-down list <br><br><br><br>";
    }
    else {
        $selectStarRating = $_POST["selectStarRating"];
    }
		
}
?>

 
  <form method = "post" action = "<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>">

  
  <table>
  
  Movie Title: <input type="text" maxlength="50" name="title" value=""/>
  Date of release: <input type="date"  name= "dateOfRelease"  value=""/>
  Length (in mins - no decimals): <input type="text" name="length" value=""/>
  Genre:  <select name="genre" value="">
    <option value="Select Genre">Select genre</option>
    <option value="drama">Drama</option>
    <option value="documentary">Documentary</option>
    <option value="science Fiction">Science Fiction</option>
    <option value="comedy">Comedy</option>
	<option value="biopic">Biopic</option>
    <option value="horror">Horror</option>
    <option value="western">Western</option>
    <option value="thriller">Thriller</option>
	<option value="animation">Animation</option>
    <option value="adventure">Adventure</option>
    <option value="romCom">Rom Com</option>
    <option value="action">Action</option>
	<option value="romance">Romance</option>
  </select>
  <br><br><br><br>
  <h3>Director:</h3>
  <br>
  First Name: <input type="text" maxlength="20" name="directorFirstName" value=""/>
  Last Name: <input type="text" maxlength="20" name="directorLastName" value=""/>
  Gender: <select name="directorGender" value="">
    <option value="Select Gender">Select gender</option>
    <option value="Male">Male</option>
    <option value="Female">Female</option>
	</select>
  Nationality: <select name="directorNationality" value="">
    <option value="Select Nationality" name="nationality">Select nationality</option>
    <option value="Spanish">Spanish</option>
    <option value="English">English</option>
	 <option value="American">American</option>
    <option value="Australian">Australian</option>
	 <option value="Mexican">Mexican</option>
    <option value="Columbian">Columbian</option>
	 <option value="Italian">Italian</option>
    <option value="Scottish">Scottish</option>
	 <option value="French">French</option>
    <option value="Ukrainian">Ukrainian</option>
	 <option value="German">German</option>
    <option value="Indian">Indian</option>
	</select>
  <br><br><br><br>
  <h3>Producer</h3>
  <br>
  First Name: <input type="text" maxlength="20" name="producerFirstName" value=""/>
  Last Name: <input type="text" maxlength="20" name="producerLastName" value=""/>
  Gender: <select name="producerGender" value ="">
    <option value="Select gender">Select gender</option>
    <option value="Male">Male</option>
    <option value="Female">Female</option>
	</select>
  Nationality: <select name="producerNationality" value="">
    <option value="Select nationality">Select nationality</option>
    <option value="Spanish">Spanish</option>
    <option value="English">English</option>
	 <option value="American">American</option>
    <option value="Australian">Australian</option>
	 <option value="Mexican">Mexican</option>
    <option value="Columbian">Columbian</option>
	 <option value="Italian">Italian</option>
    <option value="Scottish">Scottish</option>
	 <option value="French">French</option>
    <option value="Ukrainian">Ukrainian</option>
	 <option value="German">German</option>
    <option value="Indian">Indian</option>
	</select>
  <br><br><br><br>
  <h3>Star</h3>
  <br>
  First Name: <input type="text" maxlength="20" name="starFirstName" value=""/>
  Last Name: <input type="text" maxlength="20" name="starLastName" value= ""/>
  <br><br><br><br>
  <h3>Distributor (e.g. Sony Pictures):</h3>
  <br>
 <select name="distributor" value= "">
    <option value="Select distributor">Select distributor</option>
    <option value="Icon">Icon Entertainment</option>
    <option value="Palm">Palm Pictures</option>
	 <option value="Osc">Oscilloscope Laboratories</option>
    <option value="Warner">Warner Bros.</option>
	 <option value="Gram">Gramercy Pictures</option>
    <option value="Tri">TriStar Pictures</option>
	 <option value="Fox">Fox Searchlight Pictures</option>
    <option value="Para">Paramount Pictures</option>
	 <option value="Sony">Sony Pictures</option>
    <option value="Lions">Lionsgate</option>
	 <option value="Uni">Universal</option>
	</select>
  <br><br><br><br>
  <h3>Your star rating:</h3>
<br>
  <select name="selectStarRating" value= "">
    <option value="Select star rating">Select star rating</option>
    <option value="1 star">1 star</option>
    <option value="2 stars">2 stars</option>
	 <option value="3 stars">3 stars</option>
    <option value="4 stars">4 stars</option>
	 <option value="5 stars">5 stars</option>
	</select>
	 &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp<input type= "submit" name= "submit" value= "Submit" />
 <br><br><br><br>
 
 </table>

 </form>
 
 <?php if (isset($_POST['submit'])) {
	 //IF FORM WAS SUBMITTED
	 
$title = $_POST["title"];
$dateOfRelease = $_POST["dateOfRelease"];
$length = $_POST["length"];
$genre = $_POST["genre"];
$directorFirstName = $_POST["directorFirstName"];
$directorLastName = $_POST["directorLastName"];
$directorGender = $_POST["directorGender"];
$directorNationality = $_POST["directorNationality"];
$producerFirstName = $_POST["producerFirstName"];
$producerLastName = $_POST["producerLastName"];
$producerGender = $_POST["producerGender"];
$producerNationality = $_POST["producerNationality"];
$starFirstName = $_POST["starFirstName"];
$starLastName = $_POST["starLastName"];
$distributor = $_POST["distributor"];
$selectStarRating = $_POST["selectStarRating"];
$message = "Movie details have been added to our database. Thank you." ;    
 }
 else {
	 
	 $message = "";
 }
 
echo "<p style='font-size:3em;color:red;'>" .$message; "</p>"

 ?>
 
 </body>
</html>

<?php 
// CLOSE DATABASE CONNECTION

mysqli_close($conn);
?>