<?php
  $link\; =\; mysql\_connect("localhost","bp5am","bp5ampass")\; or\; die(mysql\_error());\; mysql\_select\_db("moviesite")\; or\; die\; (mysql\_error());$/* Function to calculate if a movie made a profit, 
  loss or broke even */
  function calculate_differences(takings, $cost)\; \{$difference = $takings\; -$cost;
            
    if (difference = substr($difference,\; 1);$font_color = 'red';
      $profit\_or\_loss\; =\; "$" . $difference\; .\; "m";\; \}\; elseif\; ($difference > 0) {
      $font\_color\; =\text{'}green\text{'};$profit_or_loss = "$"\; .$difference . "m";
    } else {
      $font\_color\; =\; \text{'}blue\text{'};$profit_or_loss = "Broke even";
    }
    return "<font color=\"$font\_color\backslash ">"\; .$profit_or_loss . "</font>";
  }
  
  /* Function to get the director's name from the people table */
  function get_director() {
    global $movie\_director;\; global$director;
  
    $query\_d\; =\; "SELECT\; people\_fullname\; "\; .\; "FROM\; people\; "\; .\; "WHERE\; people\_id=\text{'}$movie_director'";
    $results\_d\; =\; mysql\_query($query_d) 
      or die(mysql_error());
    $row\_d\; =\; mysql\_fetch\_array($results_d);
    extract($row\_d);$director = $people\_fullname;\; \}$/* Function to get the lead actor's name from the people table */
  function get_leadactor() {
    global movie_leadactor;
    global $leadactor;$query_a = "SELECT people_fullname " .
               "FROM people " .
               "WHERE people_id='$movie\_leadactor\text{'}";$results_a = mysql_query($query\_a)\; or\; die(mysql\_error());$row_a = mysql_fetch_array($results\_a);\; extract($row_a);
    $leadactor\; =$people_fullname;
  }
  
  $movie\_query\; =\; "SELECT\; *\; FROM\; movie\; "\; .\; "WHERE\; movie\_id\; =\text{'}"\; .$_GET['movie_id'] . "'";
  
  $movie\_result\; =\; mysql\_query($movie_query, $link)\; or\; die(mysql\_error());$movie_table_headings=<<<EOD
    <tr>
      <th>Movie Title</th>
      <th>Year of Release</th>
      <th>Movie Director</th>
      <th>Movie Lead Actor</th>
      <th>Movie Running Time</th>
      <th>Movie Health</th>
    </tr>
  EOD;
       
  <tr>
      <th>Date of Review</th>
      <th>Review Title</th>
      <th>Reviewer Name</th>
      <th>Movie Review Comments</th>
      <th>Rating</th>
    </tr>
  EOD;
  
  review_query = "SELECT * FROM reviews " .
                  "WHERE review_movie_id ='" . $\_GET[\text{'}movie\_id\text{'}]\; .\; "\text{'}\; "\; .\; "ORDER\; BY\; review\_date\; DESC";$review_result = mysql_query($review\_query,$link) 
    or die(mysql_error());
  
  while($review\_row\; =\; mysql\_fetch\_array($review_result)) {
    $review\_flag\; =1;$review_title[] = $review\_row[\text{'}review\_name\text{'}];$reviewer_name[] = ucwords($review\_row[\text{'}review\_reviewer\_name\text{'}]);$review[] = $review\_row[\text{'}review\_comment\text{'}];$review_date[] = $review\_row[\text{'}review\_date\text{'}];$review_rating[] = generate_ratings($review\_row[\text{'}review\_rating\text{'}]);\; \}$i = 0;
  $review\_details\; =\; \text{'}\text{'};\; while\; ($i<sizeof($review))\; \{$review_details .=<<<EOD
    <tr>
      <td width="15%" valign="top" align="center">$review\_date[$i]</td>
      <td width="15%" valign="top">$review\_title[$i]</td>
      <td width="10%" valign="top">$reviewer\_name[$i]</td>
      <td width="50%" valign="top">$review[$i]</td>
      <td width="10%" valign="top" align="center">$review\_rating[$i]</td>
    </tr>
  EOD;
    $i++;\; \}\; while\; ($row = mysql_fetch_array($movie\_result))\; \{$movie_name = $row[\text{'}movie\_name\text{'}];$movie_director = $row[\text{'}movie\_director\text{'}];$movie_leadactor = $row[\text{'}movie\_leadactor\text{'}];$movie_year = $row[\text{'}movie\_year\text{'}];$movie_running_time = $row[\text{'}movie\_running\_time\text{'}]."\; mins";$movie_takings = $row[\text{'}movie\_takings\text{'}];$movie_cost = $row[\text{'}movie\_cost\text{'}];$//get director's name from people table
    get_director();
  
    //get lead actor's name from people table
    get_leadactor();
  
  }     
  
  movie_health = calculate_differences($movie\_takings,$movie_cost);
  <html>
  <head>
  <title>Details and Reviews for: movie_name</title>
  </head>
  <body>
  EOD;
  
  <table width="70%" border="0" cellspacing="2" 
         cellpadding="2" align="center">
    <tr>
      <th colspan="6"><u><h2>movie_name: Details</h2></u></th>
    </tr>
    $movie\_table\_headings$<tr>
      <td width="33%" align="center">movie_name</td>
      <td align="center">$movie\_year$</td>
      <td align="center">director</td>
      <td align="center">$leadactor$</td>
      <td align="center">movie_running_time</td>
      <td>$movie\_health$</td>
    </tr> 
  </table>
  <br>
  <br>
  EOD;
  
  if (review_flag) {
    <table width="95%" border="0" cellspacing="2" 
         cellpadding="20" align="center">
    review_table_headings
    $review\_details$</table>
  EOD;
  }
  
  page_end =<<<EOD
  </body>
  </html>     
  EOD;
  page_start
       $movie\_details$page_end
  EOD;
  
  echo $detailed\_movie\_info;\; mysql\_close();\; function\; generate\_ratings($review_rating) {
    $movie\_rating\; =\; \text{'}\text{'};\; for($i=0; review_rating; $i++)\; \{$movie_rating .= "<img src=\"thumbsup.gif\">&nbsp;";
    }
    return $movie\_rating;\; \}\; ?>$