connect(); if (isset($_POST['fname']) && isset($_POST['lname'])) { $fname = validString($_POST['fname'], 20); $lname = validString($_POST['lname'], 20); if ($fname && $lname) { $db->beginTransaction(); $query = $db->prepare("INSERT INTO `MIS314`.`dvdactors` (fname, lname) VALUES (?,?)"); $query->execute(array($fname, $lname)); $db->commit(); header('location: dvdActors.php'); exit(); } } if (isset($_POST['deleteID'])) { $db->beginTransaction(); $query = $db->prepare("DELETE FROM `MIS314`.`dvdactors` WHERE `actorID` = ?"); $query->execute(array($_POST['deleteID'])); $db->commit(); header('location: dvdActors.php'); exit(); } ?> Movie Actors - Add, Delete

Movie Actors

query("SELECT * FROM dvdactors")->rowCount() . ' records in the database.'; ?>

query("SELECT * FROM dvdactors ORDER BY actorID;") as $row) { echo ""; echo ""; echo ""; echo ''; } ?>
Actor IDFirst NameLast NameDelete
$row[actorID]$row[fname]$row[lname]