case 3:
// FOTOGALLERIJ
?>
<div id="content">
<h1>Fotogallerij</h1>
<?php
if ($number_of_pages == 0) {
print '<p>Momenteel zijn er nog geen foto’s beschikbaar.</p>';
}
$db = new DB($DB_GEGEVENS);
$query_return = $db->query("SELECT id, folder FROM folder ORDER BY id DESC LIMIT " . $start . "," . $albums_per_page);
while ($row = $db->fetch_array($query_return)) {
print "<h2>" . $row['folder'] . "</h2>";
$query_fotos = $db->query("SELECT id, photo, link FROM photo WHERE folderId = " . $row['id'] . " ORDER BY orderId ASC, id DESC");
while ($row2 = $db->fetch_array($query_fotos)) {
print '<a href="' . $UPLOAD_FOLDER . '/' . $row2['link'] . '" rel="' . getCorrectRel($row['folder']) . '" title="' . $row['folder'] . '"><img src="' . $UPLOAD_FOLDER . '/th/' . $row2['link'] . '" /></a>';
}
print '<p> </p>';
}
unset($db);
?>
<div class="page_numbering">
<?php
if ($number_of_pages > 1) {
print '<table border="0" style="width: 100%"><tr><td style="width: 100px">';
// previous page
if ($_GET['n'] > 0) {
print '<a href="?p=' . $_GET['p'] . '&n=' . ($_GET['n'] - 1) . '">Vorige</a>';
}
print '</td><td style="text-align: center">';
// modal pages
</form>
</div>
</div>
<div id="fotos">
<?php
$db = new DB($DB_GEGEVENS);
$query_return = $db->query("SELECT id, folder FROM folder ORDER BY id DESC LIMIT " . $start . "," . $albums_per_page);
//TODO change mysql_fetch_array!!!
while ($row = mysql_fetch_array($query_return)) {
print '<h2>' . $row['folder'] . ' - <a href="#editFolderInline" id="editFolderInlineLink" onclick="javascript:setFields(' . $row['id'] . ', \'' . addslashes($row['folder']) . '\');">Wijzig mapnaam</a> - <a href="?p=delete_folder&id=' . $row['id'] . '" onclick="javascript:return confirm(\'Weet u zeker dat u deze map wilt verwijderen?\');">Verwijder</a></h2>';
$query_fotos = $db->query("SELECT id, photo, link FROM photo WHERE folderId = " . $row['id']);
//TODO change mysql_fetch_array!!!
while ($row2 = mysql_fetch_array($query_fotos)) {
print '<div class="foto">';
print '<a href="../' . $UPLOAD_FOLDER . '/' . $row2['link'] . '" rel="' . getCorrectRel($row['folder']) . '" title="' . $row['folder'] . '">';
print '<img src="../' . $UPLOAD_FOLDER . '/th/' . $row2['link'] . '" />';
print '</a>';
print '<br>';
print '<a href="?p=delete_photo&id=' . $row2['id'] . '&n=' . $_GET['n'] . '" onclick="javascript:return confirm(\'Weet u zeker dat u deze foto wilt verwijderen?\');">X</a>';
print '</div>';
}
print '<div class="clear"></div>';
print '<p> </p>';
}
unset($db);
?>
</div>
<div class="page_numbering">
<?php
