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");