connect(); if (isset($_POST['asin']) && isset($_POST['actorid'])) { $asin = validString($_POST['asin'], 20); $actorid = validString($_POST['actorid'], 20); if ($asin && $actorid) { $db->beginTransaction(); $query = $db->prepare("INSERT INTO `MIS314`.`dvdactorstitles` (asin, actorID) VALUES (?,?)"); $query->execute(array($asin, $actorid)); $db->commit(); header('location: dvdActorsTitles.php'); exit(); } } if (isset($_POST['deleteID']) && isset($_POST['deleteASIN'])) { $db->beginTransaction(); $query = $db->prepare("DELETE FROM `MIS314`.`dvdactorstitles` WHERE `actorID` = ?"); $query->execute(array($_POST['deleteID'])); $db->commit(); header('location: dvdActorsTitles.php'); exit(); } ?> Movie Titles and Actors

Movie Titles and Actors

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

query("SELECT * FROM dvdactorstitles ORDER BY actorID;") as $row) { echo ""; echo ""; echo ""; echo ''; } ?>
ASINActorIDDelete
$row[asin]$row[actorID]