function findAllKevins($db, $firstname, $lastname)
{
$kevinID = findActorID($db, "Kevin", "Bacon");
$actorID = findActorID($db, $firstname, $lastname);
$rows = $db->prepare("SELECT m.* FROM movies m JOIN roles r1 ON r1.movie_id = m.id JOIN roles r2 ON r2.movie_id = m.id JOIN actors a1 ON r1.actor_id = a1.id JOIN actors a2 ON r2.actor_id = a2.id WHERE a1.id = '{$kevinID}' AND a2.id = '{$actorID}' ORDER BY m.year DESC");
$rows->execute();
$movies = $rows->fetchAll(PDO::FETCH_ASSOC);
return $movies;
}
function findAllMovies($db, $firstname, $lastname)
{
try {
$actorID = findActorID($db, $firstname, $lastname);
$rows = $db->prepare("SELECT a.first_name, a.last_name, r.actor_id, m.name, m.year FROM roles r JOIN movies m ON r.movie_id = m.id JOIN actors a ON r.actor_id = a.id WHERE r.actor_id = '{$actorID}' ORDER BY m.year DESC");
$rows->execute();
$movies = $rows->fetchAll(PDO::FETCH_ASSOC);
return $movies;
} catch (Exception $e) {
echo $e;
}
}
