<h1>
Results for
<?php
echo $_GET["firstname"] . " " . $_GET["lastname"];
?>
</h1>
<div id="title">
Films with
<?php
echo $_GET["firstname"] . " " . $_GET["lastname"];
?>
</div>
<table>
<?php
include 'common.php';
$conn = getdataconnection();
$fname = $_GET["firstname"];
$lname = $_GET["lastname"];
$id_actor = getactorid($fname, $lname);
foreach ($id_actor as $id) {
$actor_id = $id['id'];
}
if (isset($actor_id)) {
$sql = $conn->query("SELECT movie.year, movie.name FROM movies movie JOIN roles role ON role.movie_id = movie.id JOIN actors actor ON role.actor_id = actor.id WHERE role.actor_id = '" . $actor_id . "' ORDER BY movie.year DESC, movie.name ASC");
$row_num = 0;
createtablehead();
foreach ($sql as $row) {
echo "<tr><td>";
echo $row_num + 1;
echo "</td><td>";
echo $row['name'];
function getactorid($fname, $lname)
{
$conn = getdataconnection();
$id_actor = $conn->query("SELECT id FROM actors a WHERE a.first_name = '" . $fname . "' AND a.last_name = '" . $lname . "'");
return $id_actor;
}
