AND images.images_active = "1" AND images.images_deleted = "0" ) AS "images" FROM galleries WHERE galleries_active = "1" AND galleries_deleted = "0" ' . $order_by . ' '; $result = mysqli_query($db, $query); $gallery_count = 1; while ($gallery = mysqli_fetch_array($result)) { $first_image = getFirstImage($gallery['galleries_id']); echo ' <div class="panel panel-default"> <div class="panel-heading"><span style="font-weight: bold;">Gallery #' . $gallery_count . ':</span> ' . $gallery['galleries_title'] . '</div> <div class="panel-body"> <img src="' . $first_image['images_prefix'] . '/' . $first_image['images_filename'] . '" style="width: 80px; float: left; margin-right: 15px;"/> Gallery imported at ' . $gallery['galleries_created'] . ', contains ' . countImagesInGallery($gallery['galleries_id']) . ' pictures.<br/> <a href="index.php?show=gallery&id=' . $gallery['galleries_id'] . '" class="btn btn-sm btn-default">Show Gallery</a> <a href="' . $gallery['galleries_link'] . '" target="_blank" class="btn btn-sm btn-default">Open Source Page</a> </div> </div> '; $gallery_count++; } ?> </div> </div> </div> </div> </div>
<div class="container"> <div class="row"> <div class="col-xs-12"> <?php if (isset($_GET['id'])) { $query = 'SELECT * FROM galleries WHERE galleries_id = "' . $_GET['id'] . '" AND galleries_active = "1" AND galleries_deleted = "0" '; $result = mysqli_query($db, $query); $gallery = mysqli_fetch_array($result); $pictures = countImagesInGallery($gallery['galleries_id']); $pages = ceil($pictures / 12); if (!isset($_GET['page'])) { $_GET['page'] = 1; } echo ' <h2>' . $gallery['galleries_title'] . '</h2> <p>Gallery imported at ' . $gallery['galleries_created'] . ', contains ' . $pictures . ' pictures.</p> <a href="index.php" class="btn btn-default">Galleries List</a> '; if ($pages == 1) { echo ' <nav> <ul class="pagination"> <li class="disabled"><a href="#" aria-label="Previous"><span aria-hidden="true">«</span></a></li> <li class="active"><a href="#">1</a></li> <li class="disabled"><a href="#" aria-label="Next"><span aria-hidden="true">»</span></a></li> </ul> </nav> '; } else { $page_next = $_GET['page'] + 1; $page_prev = $_GET['page'] - 1;