Movie Titles

connect(); if (isset($_POST['asin']) && isset($_POST['title']) && isset($_POST['price'])) { $price = validFloat($_POST['price']); $title = validString($_POST['title'], 100); $asin = validString($_POST['asin'], 15); if ($asin && $title && $price) { $db->beginTransaction(); $query = $db->prepare("INSERT INTO `MIS314`.`dvdtitles` (asin, title, price) VALUES (?,?,?)"); $query->execute(array($asin, $title, $price)); $db->commit(); header('location: dvdTitles.php'); exit(); } } if (isset($_POST['deleteASIN'])) { $db->beginTransaction(); $query = $db->prepare("DELETE FROM `MIS314`.`dvdtitles` WHERE `asin` = ?"); $query->execute(array($_POST['deleteASIN'])); $db->commit(); header('location: dvdTitles.php'); exit(); } ?> Movie Titles - Add, Delete

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

query("SELECT * FROM dvdtitles ORDER BY price;") as $row) { echo ""; echo ""; echo ""; echo ''; } ?>

ASIN	Title	Price	Image	Delete
$row[asin]	$row[title]	$$row[price]