<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<META NAME="TITLE" CONTENT="Katie's Kakes and Sugarcraft">
<META NAME="DESCRIPTION" CONTENT="Katie's Kakes, specialist cakes made to order, equipment sold and tins for hire. See the galleries for some examples of cakes we have made, contact us for a free appointment to discuss your needs. ">
<META NAME="KEYWORDS" CONTENT="cakes sugarcraft cake shop surbiton kingston upon thames specialist made to order katies kakes surbiton art">
<META NAME="AUTHOR" CONTENT="Ben Jarvis">
<META HTTP-EQUIV="CHARSET" CONTENT="ISO-8859-1">
<META HTTP-EQUIV="CONTENT-LANGUAGE" CONTENT="English">
<title>Katie's Kakes | Photo Gallery</title>
<link href="/css/style.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" href="/css/thickbox.css" type="text/css" media="screen" />
<script type="text/javascript" src="/js/jquery.js"></script>
<script type="text/javascript" src="/js/jquery.cycle.all.min.js"></script>
<script type="text/javascript" src="/js/scripts.js"></script>
<script type="text/javascript" src="/js/thickbox.js"></script>
</head>
<body>
<div>
<div id="container">
<div id="header"><div id="logo"><img src="images/logo.png" alt="Katies Kakes" /></div></div>
<div id="navarea">
<div id="push"></div>
<div id="navigation">
<ul id="topnav">
<li class="home"><a href="index.php"></a></li>
<li class="about"><a href="aboutus.php"></a></li>
<li class="equipment"><a href="equipment.php"></a></li>
<li class="gallery"><a href="gallery.php"></a></li>
<li class="tins"><a href="tins.php"></a></li>
<li class="contact"><a href="contact.php"></a></li>
</ul>
</div>
</div>
<div id="contentarea">
<div id="slideshow">
<ul id="nav">
<li id="prev"><a href="#">Previous</a></li>
<li id="next"><a href="#">Next</a></li>
</ul>
<ul id="slides">
<li><img src="images/slider/slide1.jpg" alt="Harley Davidson Sportster" /></li>
<li><img src="images/slider/slide2.jpg" alt="Harley Davidson Sportster" /></li>
</ul>
</div>
<div id="content">
<br />
<h2>Photo Gallery</h2><br />
Enjoy browsing through the photo galleries, cakes that you see can be adapted to suit your particular ideas and needs. To browse each category, click on the links. <br />
<?php
include("config.inc.php");
// initialization
$result_array = array();
$counter = 0;
$cid = (int)($_GET['cid']);
$pid = (int)($_GET['pid']);
// Category Listing
if( empty($cid) && empty($pid) )
{
$number_of_categories_in_row = 3;
$result = mysql_query( "SELECT c.category_id,c.category_name,COUNT(photo_id)
FROM gallery_category as c
LEFT JOIN gallery_photos as p ON p.photo_category = c.category_id
GROUP BY c.category_id" );
while( $row = mysql_fetch_array( $result ) )
{
$result_array[] = "<img src=".$images_dir.'/tb_'.$row[0].'.jpg'." /><br /><a href='gallery.php?cid=".$row[0]."'>".$row[1]."</a> ";
}
mysql_free_result( $result );
$result_final = "<tr>\n";
foreach($result_array as $category_link)
{
if($counter == $number_of_categories_in_row)
{
$counter = 1;
$result_final .= "\n</tr>\n<tr>\n";
}
else
$counter++;
$result_final .= "\t<td>".$category_link."</td>\n";
}
if($counter)
{
if($number_of_categories_in_row-$counter)
$result_final .= "\t<td colspan='".($number_of_categories_in_row-$counter)."'> </td>\n";
$result_final .= "</tr>";
}
}
// Thumbnail Listing
else if( $cid && empty( $pid ) )
{
$number_of_thumbs_in_row = 3;
$result = mysql_query( "SELECT photo_id,photo_caption,photo_filename FROM gallery_photos WHERE photo_category='".addslashes($cid)."'" );
$nr = mysql_num_rows( $result );
if( empty( $nr ) )
{
$result_final = "\t<tr><td>No Category found</td></tr>\n";
}
else
{
while( $row = mysql_fetch_array( $result ) )
{
$result_array[] = "<a href=".$images_dir.'/'.$row[0].'.jpg'." class=\"thickbox\"><img src=".$images_dir.'/tb_'.$row[0].'.jpg'." border=\"0\" /></a><br />".$row[1]."<p> </p>";
}
mysql_free_result( $result );
$result_final = "<tr>\n";
foreach($result_array as $thumbnail_link)
{
if($counter == $number_of_thumbs_in_row)
{
$counter = 1;
$result_final .= "\n</tr>\n<tr>\n";
}
else
$counter++;
$result_final .= "\t<td>".$thumbnail_link."</td>\n";
}
if($counter)
{
if($number_of_photos_in_row-$counter)
$result_final .= "\t<td colspan='".($number_of_photos_in_row-$counter)."'> </td>\n";
$result_final .= "</tr>";
}
}
}
// Final Output
echo <<<__HTML_END
<p> </p>
<center>
<table id='phototable'>
$result_final
</table>
<p> </p>
<a href="#" onclick="window.scrollTo(0,0); return false">Back to Top</a>
<p> </p>
</center>
__HTML_END;
?>
</div>
</div>
<div id="footer">
<div id="footercontent">
<br />©2010 Katies Kakes. All Rights Reserved
<br />Website Designed by Ben Jarvis Web Design
</div>
</div>
</div>
</div>
<!-- GoStats JavaScript Based Code -->
<script type="text/javascript" src="http://gostats.com/js/counter.js"></script>
<script type="text/javascript">_gos='c5.gostats.com';_goa=1008492;
_got=5;_goi=1;_gol='web site traffic analysis';_GoStatsRun();</script>
<noscript><a target="_blank" title="web site traffic analysis"
href="http://gostats.com"><img alt="web site traffic analysis"
src="http://c5.gostats.com/bin/count/a_1008492/t_5/i_1/counter.png"
style="border-width:0" /></a></noscript>
<!-- End GoStats JavaScript Based Code -->
</body>
</html>
Makes a little sense to me but still dont understand how this links with the other pages. I appreciate your help.
4
