<?php
require '../utils/dbPDO.php';
require '../utils/validate.php';
$dalingk = new dalingkDB();
$db = $dalingk->connect();
$movies = $db->query("SELECT m.asin, m.title, m.price, GROUP_CONCAT(Concat(a.fname, \" \", a.lname) SEPARATOR \", \") AS name FROM dvdtitles m, dvdactors a, dvdactorstitles at WHERE at.asin = m.asin AND at.actorID = a.actorID GROUP BY m.asin");
?>
<!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 $movies->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 ($movies as $row) {
				echo "<tr>";
				echo "<td>$row[asin]</td><td>$row[title]</td><td>$$row[price]</td><td>$row[name]</td><td><img src=\"http://images.amazon.com/images/P/$row[asin].01.MZZZZZZZ.jpg\"></td>";
				echo '</tr>';
			}
			?>
		</table>
	</div>
</body>
</html>
