<?php
require '../utils/dbPDO.php';
require '../utils/validate.php';
$dalingk = new dalingkDB();
$db = $dalingk->connect();
?>
<!DOCTYPE html>
<html>
<head>
	<title>Movie Listings</title>
	<link href="//yorktown.cbe.wwu.edu/sandvig/mis314/assignments/style.css" rel="stylesheet" type="text/css">
</head>
<body>
	<div class="pageContainer centerText">
		<h3>Movie Listings</h3><hr>
		<p><?php echo $db->query("SELECT * FROM dvdactorstitles")->rowCount() . ' records in the database.'; ?></p>
		<table class="simpleTable shadow">
			<tr><th>ASIN</th><th>Title</th><th>Price</th><th>Actors</th><th>Cover</th></tr>
			<?php
			foreach ($db->query("SELECT m.asin, m.title, m.price, a.fname, a.lname FROM dvdtitles m, dvdactors a, dvdactorstitles at WHERE at.asin = m.asin AND at.actorID = a.actorID;") as $row) {
				echo "<tr>";
				echo "<td>$row[asin]</td><td>$row[title]</td><td>$$row[price]</td><td>$row[fname] $row[lname]</td><td><img src=\"http://images.amazon.com/images/P/$row[asin].01.MZZZZZZZ.jpg\"></td>";
				echo '</tr>';
			}
			?>
		</table>
	</div>
</body>
</html>
