<?php require 'header.php'; ?>
<?php
$show = $_GET['show'] ?? '';
$showNames = [
    'phantom' => 'Phantom of the Opera',
    'comeblow' => 'Come Blow Your Horn',
    'blackcomedy' => 'Black Comedy',
    'theknack' => 'The Knack',
    'somemothers' => "Some Mothers Do 'Ave 'Em",
    'flowersofal' => 'Flowers for Algernon',
    'billy' => 'Billy',
    'barnum' => 'Barnum',
    'malw' => 'The Music of Andrew Lloyd Webber',
    'efx' => 'EFX',
    'concert' => 'Michael Crawford In Concert',
    'book' => 'Parcel Arrived Safely Tied With String',
    'oew' => 'CDs',
    'misc' => 'Miscellaneous',
];
$displayName = $showNames[strtolower($show)] ?? h($show);

$pdo = getReadDb();
$stmt = $pdo->prepare("SELECT id, headline, source FROM reviews WHERE reviews.show = ? ORDER BY headline");
$stmt->execute([$show]);
$articles = $stmt->fetchAll();
?>

	<section id="content" class="sbr">
		<div class="menu-shadow"></div>
		<div class="container clearfix">
			<div class="page-header clearfix" style="margin-bottom: 20px;">
				<h1><?= $displayName ?></h1>
				<div class="line"></div>
			</div>
			<!--/ .page-header-->

			<section id="main" class="twelve columns">
				<article class="entry clearfix">

					<div class="entry-body">
<?php foreach ($articles as $row): ?>
<li> <a href="reviews3.php?id=<?= h($row['id']) ?>"><?= h($row['headline']) ?></a><br>From: <?= h($row['source']) ?><p></li>
<?php endforeach; ?>

					</div>
					<!--/ .entry-body-->

				</article>
				<!--/ .entry-->
			</section>				<!--/ #main-->

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



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