View file File name : arrange-album-photos.php Content :<?php include './header.php'; $albumId = $_GET['id']; if (isset($_POST['save-date'])) { foreach ($_POST['sort'] as $key => $img) { $key = $key + 1; $sql = "UPDATE `album-photo` SET `sort` = '" . $key . "' WHERE `albumId` = '" . $albumId . "'"; $db = new DB(); $db->readQuery($sql); } } $albumphotos = getAlbumPhotosByAlbumId($albumId); ?> <div class="content-wrapper"> <div class="container"> <div class="row"> <div class="col-md-12"> <h1 class="page-head-line">Arrange Album Photos</h1> </div> </div> <div class="row"> <div class="col-md-12"> <div class="panel panel-default"> <div class="panel-heading"> Arrange Album Photos </div> <div class="panel-body"> <form method="post"> <div class="panel-body"> <div class="row"> <div class="col-sm-12"> <ul id="sortable"> <?php if (count($albumphotos) > 0) { foreach ($albumphotos as $key => $albumphoto) { ?> <li class="ui-state-default"> <span class="number-class">(<?php echo $key + 1; ?>)</span> <img width="300px" height="130" class="example-image img-responsive" src="../images/album/photo/thumb/<?php echo $albumphoto["image_name"]; ?>" alt=""/> <input type="hidden" name="sort[]" value="<?php echo $albumphoto["id"]; ?>" class="sort-input"/> </li> <?php } } else { ?> <b>No images in the database.</b> <?php } ?> </ul> <div class="row"> <div class="col-sm-12 text-center" style="margin-top: 19px;"> <input type="submit" class="btn btn-info" id="btn-submit" value="Save Images" name="save-date"> </div> </div> </div> </div> </div> </form> </div> </div> </div> </div> <div class="row" style="height: 20px;"> </div> </div> </div> <?php include './footer.php';