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