<?php require 'header.php'; ?>

<?php
$pdo = getReadDb();
$stmt = $pdo->prepare("SELECT * FROM newvideos ORDER BY year DESC");
$stmt->execute();
$solodisc = $stmt->fetchAll();
?>

	<section id="content" class="sbr">
		<div class="menu-shadow"></div>
		<div class="container clearfix">
			<div class="page-header clearfix">
				<h1>Videos</h1>
				<div class="line"></div>
			</div>
			<!--/ .page-header-->

			<section id="main" class="twelve columns alpha">

				<!--/ #portfolio-filter-->


				<section id="portfolio-items" class="portfolio-items clearfix">

	<?php foreach ($solodisc as $row): ?>


					<article class="four columns">
						<?php
						$newphoto = preg_replace('/\.png/', '.jpg', $row['photo']);
						$newphoto = preg_replace('#https://newimages\.bwwstatic\.com/2017/#', '/newvideo/', $row['photo']);
						?>

						<Center><div class="preloader"> <a class="bwWrapper single-image zoom-icon" href="<?php echo htmlspecialchars($row['amazon']); ?>" target="_new"> <img src="<?php echo htmlspecialchars($newphoto); ?>" alt=""> </a> </div></Center>
						<!--/ .preloader-->

						<a class="project-meta" href="<?php echo htmlspecialchars($row['amazon']); ?>"  target="_new">
						<h6 class="title"><?php echo htmlspecialchars($row['title']); ?></h6>
						<span class="categories"><?php echo htmlspecialchars($row['year']); ?></span> </a><!--/ .project-meta-->

					</article>
					<!--/ .column-->
	<?php endforeach; ?>

					<!--/ .column-->

				</section>
				<!--/ #portfolio-items -->

			</section>
			<!--/ #main-->

<?php require 'sidebar.php'; ?>
<?php require 'footer.php'; ?>