<!--
        search4.php
-->
<CENTER>
<?php
        // p.63 search.php

        $genre = $_POST['genre'];

        $host = 'localhost';
        $user = 'brmorrison';
        $passwd = 'cs389';
        $database = 'brmorrison';

        $connect = mysqli_connect($host, $user, $passwd);
        $query = "select TITLE, GENRE, PLOT_RATING, ACTING_RATING, ENJOYMENT_RATING, OVERALL_RECOMMENDATION from MOVIEREVIEWS where GENRE = '$genre' ";
        // print "The query is <i> $query </i> ";

        mysqli_select_db($connect, $database);
        $result_id = mysqli_query($connect, $query);

        if($result_id)
        {
		print '<table border=1>';
                print '<TH> Title <TH> Genre <TH> Plot_Rate <TH> Acting_Rate <TH> Enjoyment_Rate <TH> Overall_Rec';
                while($row = mysqli_fetch_row($result_id))
                {       print '<TR>';
                        foreach ($row as $field)
                                print "<TD> $field </TD> ";
                        print '</TR>';
                }
        }
        else
                print "Fail.<p>";
        mysqli_close($connect);
?>
</CENTER>

<!-- add a link for going back the form -->
<HR>
<A HREF=search4.html> Back to Search by Genre </A> |
<A HREF=finalProject.html> Movie Review Home Page </A> |
<A HREF=movieEvalForm.html> Leave a Review of Your Own </A> |
<A HREF=index.html> Course Home </A>