<?php require 'header.php'; ?>
<?php if (isLoggedIn()): ?>


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

		<section id="main" class="twelve columns">
			<article class="entry clearfix">
				<!--/ .entry-title-->

				<!--/ .preloader-->

				<!--/ .entry-meta-->

				<div class="entry-body">


<?php
$db = getReadDb();

$stmt = $db->prepare("SELECT * FROM photos ORDER BY id DESC LIMIT 0, 10");
$stmt->execute();
$latestPhotos = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>

<p>

<div align="center"><Font face=verdana>
<p>

		<a href="photos-gobetweenclosing.php"><img width="100%" src="http://mcifa.com/photos/Leigh_Allan.JPG"><br><font color="green">Oct 2016 - The Go Between Closing + V&A Interview
</a><br><br>


		<a href="photos-gobetweenjuly.php"><img width="100%" src="http://mcifa.com/photos/2016_07MCGroup.jpg"><br><font color="green">July 2016 - The Go Between M.C.I.F.A. Group

</a><br><br>

	<a href="photos-gobetween.php"><img width="100%" src="http://mcifa.com/photos/GoBetween%20Poster.jpg"><br><font color="green">May 2016 The Go-Between Previews - COCO's Photos</a><br><br>




<a href="photos-sct2012.php"><img width="100%" src="http://mcifa.com/photos/Grouppic.jpg"><br><font color="green">M.C.I.F.A. AWARD at SCT 30th ANNIVERSARY EVENT Photos</a><br><br>
<a href="photosuk2012.php"><img width="100%" src="http://images.broadwayworld.com/upload8/377323/tn-500_dsc_0041.jpg"><br><font color="green"> COCO Photos from London, Feb 2012</a><br><br>
<a href="photosuk20.php"><img src="http://newimages.broadwayworld.com/lilgroup.jpg" border="1"><br><font color="green"> July 2011 London 20th Anniv. Photos</font>
<br><Br>
<table><tr>
<td><font face="verdana" size=-2><a href="photosuk1.php"><img src="http://mcifa.com/photos/ndSAM_1062.JPG" width="100" height="100"><br>London Luncheon Photos</a></td>
<td><font face="verdana" size=-2><a href="photosuk2.php"><img src="http://mcifa.com/photos/ndIMG_0179-1.JPG" width="100" height="100"><br>Coco's Oz Preview Photos</a></td>
<td><font face="verdana" size=-2><a href="photosuk3.php"><img src="http://images.broadwayworld.com/upload5/208091/tn-500_sam_1078.jpg" width="100" height="100"><br>Oz Stagedoor 1st Preview</a></td>
<td><font face="verdana" size=-2><a href="photosuk4.php"><img src="http://images.broadwayworld.com/upload5/208650/tn-500_img_0024.jpg" width="100" height="100"><br>Oz Stagedoor 3rd Preview</a></td>
</tr></table></a></a></a>
<hr>
<h2>Newest Photos</h2>
<p>

<?php
$columns = 2;
?>
<table border="0" width="100%">
  <tr>
<?php foreach ($latestPhotos as $index => $photo): ?>
<?php if ($index > 0 && $index % $columns === 0): ?>
    </tr><tr>
<?php endif; ?>
      <td width=50% valign=top>
<div align="center">
<a href="viewphoto.php?id=<?php echo urlencode($photo['id']); ?>"><img src="/photos/<?php echo h($photo['photo']); ?>" border=1 width=100% style="max-height: 200px;width: auto;"><br>
<font face=arial size=-2>
<?php echo h($photo['description']); ?>
</a>
</div>
</td>
<?php endforeach; ?>
    </tr>
</table>
</div>
<p>



<?php
$stmtMembers = $db->prepare("SELECT DISTINCT member, fname, lname FROM photos ORDER BY fname");
$stmtMembers->execute();
$memberPhotos = $stmtMembers->fetchAll(PDO::FETCH_ASSOC);
?>
<div align="center"><font face=arial size=+1 color=600060><strong>Members Only Photos</strong></font><br>
<strong><font face=arial size=-1>
Upload your own photos of Michael, and share them with other members, or view what everyone else has posted!
<p>


<a href="uploadphoto.php" style="text-decoration: underline">Upload Pictures</a>
</div>
</font></strong>
<p>
<Table width=375>
<tr><td valign=top>
<font face=arial size=-1>
<?php foreach ($memberPhotos as $mp): ?>
<li><a href="photos2.php?id=<?php echo urlencode($mp['member']); ?>"><?php echo h($mp['fname']); ?> <?php echo h($mp['lname']); ?>'s Photos</a></li>
<?php endforeach; ?>
</ul>

</font>
</td></tr>
</TABLE>


						<!--/ .about-author-->

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

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

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



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