<?php
    /* movieEvaluationAction.php */

    // Establish database connection
    $host = 'localhost';
    $user = 'brmorrison';
    $passwd = 'cs389';
    $database = 'brmorrison';
    $connect = mysqli_connect($host, $user, $passwd);

    if (!$connect) {
        die('Could not connect: ' . mysqli_error($connect));
    }

    // Select database
    mysqli_select_db($connect, $database);

    // Get form data
    $title = $_POST['title'];
    $genre = $_POST['genre'];
    $plot_rating = $_POST['plot_rating'];
    $acting_rating = $_POST['acting_rating'];
    $enjoyment_rating = $_POST['enjoyment_rating'];
    $overall_recommendation = $_POST['overall_recommendation'];

    // Insert data into database
    $query = "INSERT INTO MOVIEREVIEWS (title, genre, plot_rating, acting_rating, enjoyment_rating, overall_recommendation) VALUES ('$title', '$genre', '$plot_rating', '$acting_rating', '$enjoyment_rating', '$overall_recommendation')";

    $result = mysqli_query($connect, $query);

    if (!$result) {
        die('Query failed: ' . mysqli_error($connect));
    } else {
        // Display a success message
        echo "<p>Thank you for your review!</p>";
	include("display4.php");
    }

    // Close connection
    mysqli_close($connect);
?>