View file File name : arrange-rooms.php Content :<?php include './header.php'; if (isset($_POST['save-date'])) { foreach ($_POST['sort'] as $key => $img) { $key = $key + 1; $sql = "UPDATE `rooms` SET `sort` = '" . $key . "' WHERE id = '" . $img . "'"; $db = new DB(); $db->readQuery($sql); } } $rooms = getAllRooms(); ?> <!-- MAIN SITE WRAPPER--> <div class="content-wrapper"> <!--container--> <div class="container"> <!--banner--> <div class="row"> <div class="col-md-12"> <h1 class="page-head-line">Arrange Rooms </h1> </div> </div> <!--end banner--> <!--new image add form--> <div class="row"> <div class="col-md-12"> <div class="panel panel-default"> <div class="panel-heading"> Arrange Rooms </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($rooms) > 0) { foreach ($rooms as $key => $room) { ?> <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/rooms/<?php echo $room["image_name"]; ?>" alt=""/> <p style="width: 300px; padding: 3px 10px 0 10px" class="maxlinetitle"><?php echo $room["title"]; ?></p> <input type="hidden" name="sort[]" value="<?php echo $room["id"]; ?>" class="sort-input"/> </li> <?php } } else { ?> <b>No Rooms 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> <!--end new image add form--> </div> <!--end container--> </div> <!--END MAIN SITE WRAPPER--> <?php include './footer.php';