<?php
$link =connection
	or die(mysql_error());
mysql_select_db("moviesite")
	or die(mysql_error());
	$query = "SELECT movie_name, movie_director, movie_leadactor " .
			"FROM movie";
			
$result = mysql_query($query, $link)
	or die(mysql_error());
$num_movies = mysql_num_rows($result);
$movie_header=<<<EOD
<h2><center>Movie Review Database</center</h2>
<table width="70%" border="1" cellpadding="2"
	cellspacing="2" align="center">
		<tr>
			<th>Movie Title</th>
			<th>Year of Release</th>
			<th>Movie Director</th>
			<th>Movie Lead Actor</th>
			<th>Movie Type</th>
		</tr>

EOD;

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 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_details = '';
while ($row = mysql_fetch_array($result)){
	$movie_name = $row['movie_name'];
	$movie_director = $row['movie_director'];
	$movie_leadactor = $row['movie_leadactor'];
	
	get_director();
	get_leadactor();
	
	$movie_details .=<<<EOD
		<tr>
			<td>$movie_name</td>
			<td>$director</td>
			<td>$leadactor</td>
		</tr>
EOD;
}
	$movie_details .=<<<EOD
		<tr>
			<td>&nbsp</td>
		</tr>
		<tr>
			<td>Total :$num_movies Movies</td>
		</tr>
EOD;
$movie_footer ="</table>";
$movie=<<<MOVIE
	$movie_header
	$movie_details
	$movie_footer
MOVIE;
echo "There are $num_movies movies in our database";
echo $movie;
?>

<?php
$connect = 
or die ("You do not have a server connection.");


mysql_select_db("moviesite");

$insert = "INSERT INTO movie (movie_id, movie_name, movie_type, " .
			"movie_year, movie_leadactor, movie_director) " .
			"VALUES (1, 'Bruce Almighty', 5, 2003, 1, 2), " .
			"(2, 'Office Space', 5, 1999, 5, 6), " .
			"(3, 'Grand Canyon', 2, 1991, 4, 3)";
$results = mysql_query($insert)
	or die(mysql_error());
	
$type = "INSERT INTO movietype (movietype_id, movietype_label) " .
		"VALUES (1, 'sci fi'), " .
		"(2, 'drama'), " .
		"(3, 'adventure'), " .
		"(4, 'war'), " .
		"(5, 'comedy'), " .
		"(6, 'horror'), " .
		"(7, 'action'), " .
		"(8, 'kids')";
$results = mysql_query($type)
	or die(mysql_error());
	
$people = "INSERT INTO people (people_id, people_fullname, " .
			"people_isactor, people_isdirector) " .
			"VALUES (1, 'jim carrey', 1, 0), " .
			"(2, 'tom shadyac', 0, 1), " .
			"(3, 'lawrence kasdan', 0, 1), " .
			"(4, 'kevin kline', 1, 0), " .
			"(5, 'ron livingston', 1, 0), " .
			"(6, 'mike judge', 0, 1)";
$results = mysql_query($people)
	or die(mysql_error());

	echo "data inserted successfully";
		
?>