function inputValues($mName, $mYear, $actFirstName, $actLastName, $dirFirstName, $dirLastName, $db)
{
if ($mName == null || $mYear == null) {
print "Please complete mandotory fields: movie name, year and genre.";
return FALSE;
} else {
# use inputs actFirstName or actLastName or both
if ($actFirstName != "" || $actLastName != "") {
$actorID = fetchActorsID($actFirstName, $actLastName, $db);
#actor isn't in database
if ($actorID == -1) {
exit(0);
}
}
// use inputs dirFirstName or dirFirstName or both
if ($dirFirstName != "" || $dirLastName != "") {
$director_id = fetchDirectorsID($dirFirstName, $dirLastName, $db);
// director not in the db
if ($director_id == -1) {
exit(0);
}
}
return TRUE;
}
//end of movie inputs
}
$dirFirstName = htmlspecialchars($_REQUEST['dirFirstName']);
$dirLastName = htmlspecialchars($_REQUEST['dirLastName']);
$movieGenre = htmlspecialchars($_REQUEST['movie_Genre']);
#checking inputs
if (inputValues($mName, $mYear, $actFirstName, $actLastName, $dirFirstName, $dirLastName, $db)) {
try {
// get largest movie id number to prepare insertion
$newMovieID = fetchNewMovieID($db);
$stmt = $db->prepare("INSERT INTO movies (id, name, year) VALUES (:id, :mName, :mYear)");
$stmt->bindParam(":id", $newMovieID);
$stmt->bindParam(":mName", $mName);
$stmt->bindParam(":mYear", $mYear);
$stmt->execute();
# updating table movies_directors
if ($dirFirstName != "" && $dirFirstName != "") {
$director_id = fetchDirectorsID($dirFirstName, $dirLastName, $db);
$stmt = $db->prepare("INSERT INTO movies_directors (director_id, movie_id) VALUES (:director_id, :movieID)");
$stmt->bindParam(":director_id", $director_id);
$stmt->bindParam(":movieID", $newMovieID);
$stmt->execute();
}
# updating table role
if ($actFirstName != "" && $actLastName != "") {
// $actorID is not -1
$actorID = fetchActorsID($actFirstName, $actLastName, $db);
$stmt = $db->prepare("INSERT INTO roles (actor_id, movie_id) VALUES (:actorID, :movieID)");
$stmt->bindParam(":actorID", $actorID);
$stmt->bindParam(":movieID", $newMovieID);
$stmt->execute();
# updating actor role's film_count column
$stmt = $db->prepare("UPDATE actors SET film_count=film_count +1 WHERE id = :actorID");
