Edit file File name : add-tour-type.php Content :<?php include './header.php'; $success = NULL; $error = NULL; if (isset($_POST['save-data'])) { $tourtype = addTourType($_POST); if ($tourtype) { $success = 'Success Add Tour Type'; } else { $reer = 'oops'; } } if (isset($_POST['save-date'])) { foreach ($_POST['sort'] as $key => $type) { $key = $key + 1; $sql = "UPDATE `tour-type` SET `sort` = '" . $key . "' WHERE `id` = '" . $type . "'"; $db = new DB(); $db->readQuery($sql); } } $types = getAllTourType(); ?> <script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script> <script> $(function () { $("#sortable").sortable(); $("#sortable").disableSelection(); }); </script> <!-- 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">Tour Types </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"> Add Tour Types </div> <div class="panel-body"> <form method="post" action="" enctype="multipart/form-data"> <div class="form-group"> <?php if (!empty($success)) { ?> <div class="alert alert-success" style="margin-top: 15px "> <a href="" class="close" data-dismiss="alert" aria-label="close">×</a> <strong>Success! </strong> <?php echo $success; ?> </div> <?php } ?> </div> <div class="form-group"> <label for="tourType">Tour Type</label> <input type="text" name="tourType" class="form-control" id="tourType" placeholder="Enter Tour Type" required="TRUE"/> </div> <button type="submit" name="save-data" value="Save" class="btn btn-default">Save</button> </form> </div> </div> </div> </div> <div class="panel panel-default"> <div class="panel-heading"> <h3 class="panel-title">Tour Types</h3> </div> <div class="panel-body"> <div class="row"> <div class="col-sm-9"> <?php if ($types) { ?> <form method="post"> <div class="container-fluid"> <div class="row album-list fadeIn appear"> <div class="col-sm-12" > <ul id="sortable" class="list-group"> <?php foreach ($types as $key => $type) { ?> <li class="list-group-item" style="float: none"> <span class="number-class">(<?php echo $key + 1; ?>)</span> <input type="hidden" name="sort[]" value="<?php echo $type["id"]; ?>" class="sort-input"/> <b style="padding-left: 30px" id="opTp_<?php echo $type["id"]; ?>"><?php echo $type["type"]; ?></b> <a class="badge delete-tour-type" id="<?php echo $type["id"]; ?>" style="background-color: #DDD"><span class="glyphicon glyphicon-trash text-danger"></span></a> <a class="badge" href="edit-tour-type.php?id=<?php echo $type["id"]; ?>" style="background-color: #DDD"><span class="glyphicon glyphicon-pencil text-info"></span></a> </li> <?php } ?> </ul> </div> <div class="col-sm-12 text-right" style="margin-top: 5px;"> <input type="submit" class="btn btn-info" id="btn-submit" value="Save Types" name="save-date"> </div> </div> </div> </form> <?php } else { echo 'No Tour Types in Database '; } ?> </div> </div> </div> </div> <div id="myModal" class="modal fade"> <div class="modal-dialog"> <form action="" method="POST" > <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title text-danger">Confirmation</h4> </div> <div class="modal-body"> <div class="row"> <div class="col-sm-12"> <p>Really do you want to delete tour type "<span id="nameSpan"></span>" ?...</p> </div> </div> </div> <div class="modal-footer"> <input type="hidden" name="tour-typeId" id="tour-typeId" required="TRUE"> <button type="submit" class="btn btn-danger" name="delete">Delete</button> <button type="submit" class="btn btn-default" data-dismiss="modal">Close</button> </div> </div> </form> </div> </div> <!--end new image add form--> </div> <!--end container--> </div> <!--END MAIN SITE WRAPPER--> <?php include './footer.php'; Save