0) {
$font_color ='green';
$profit_or_loss = "$" . $difference . "m";
} else {
$font_color = 'blue';
$profit_or_loss = "Broke even";
}
return "" . $profit_or_loss . "";
}
/* 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='$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'";
$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 ='" . $_GET['movie_id'] . "'";
$movie_result = mysql_query($movie_query, $link)
or die(mysql_error());
$movie_table_headings=<<
| Movie Title |
Year of Release |
Movie Director |
Movie Lead Actor |
Movie Running Time |
Movie Health |
EOD;
$review_table_headings=<<
Date of Review |
Review Title |
Reviewer Name |
Movie Review Comments |
Rating |
EOD;
$review_query = "SELECT * FROM reviews " .
"WHERE review_movie_id ='" . $_GET['movie_id'] . "' " .
"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['review_name'];
$reviewer_name[] = ucwords($review_row['review_reviewer_name']);
$review[] = $review_row['review_comment'];
$review_date[] = $review_row['review_date'];
$review_rating[] = generate_ratings($review_row['review_rating']);
}
$i = 0;
$review_details = '';
while ($i
$review_date[$i] |
$review_title[$i] |
$reviewer_name[$i] |
$review[$i] |
$review_rating[$i] |
EOD;
$i++;
}
while ($row = mysql_fetch_array($movie_result)) {
$movie_name = $row['movie_name'];
$movie_director = $row['movie_director'];
$movie_leadactor = $row['movie_leadactor'];
$movie_year = $row['movie_year'];
$movie_running_time = $row['movie_running_time']." mins";
$movie_takings = $row['movie_takings'];
$movie_cost = $row['movie_cost'];
//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);
$page_start =<<
Details and Reviews for: $movie_name
EOD;
$movie_details =<<
$movie_name: Details |
$movie_table_headings
| $movie_name |
$movie_year |
$director |
$leadactor |
$movie_running_time |
$movie_health |
EOD;
if ($review_flag) {
$movie_details .=<<
$review_table_headings
$review_details
EOD;
}
$page_end =<<
EOD;
$detailed_movie_info =<< ";
}
return $movie_rating;
}
?>