Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html lang="en">
- <head>
- <title>Bootstrap Example</title>
- <meta charset="utf-8">
- <meta name="viewport" content="width=device-width, initial-scale=1">
- <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
- <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
- <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
- <style>
- /* Set height of the grid so .sidenav can be 100% (adjust as needed) */
- .row.content {height: 550px}
- /* Set gray background color and 100% height */
- .sidenav {
- background-color: #f1f1f1;
- height: 100%;
- }
- /* On small screens, set height to 'auto' for the grid */
- @media screen and (max-width: 767px) {
- .row.content {height: auto;}
- }
- </style>
- </head>
- <body>
- <nav class="navbar navbar-inverse visible-xs">
- <div class="container-fluid">
- <div class="navbar-header">
- <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#myNavbar">
- <span class="icon-bar"></span>
- <span class="icon-bar"></span>
- <span class="icon-bar"></span>
- </button>
- <a class="navbar-brand" href="#"><img src=logo.png></a>
- </div>
- <div class="collapse navbar-collapse" id="myNavbar">
- <ul class="nav navbar-nav">
- <li><a href="index.html">Dashboard</a></li>
- <li class="active"><a href="citatt.php">Cities and Attractions</a></li>
- <li><a href="addTour.php">Add New Tour</a></li>
- <li><a href="updtAttraction.php">Update Attraction Details</a></li>
- </ul>
- </div>
- </div>
- </nav>
- <div class="container-fluid">
- <div class="row content">
- <div class="col-sm-3 sidenav hidden-xs">
- <h2><img src=logo.png width> </h2>
- <ul class="nav nav-pills nav-stacked">
- <li><a href="index.html">Dashboard</a></li>
- <li class="active"><a href="citatt.php">Cities and Attractions</a></li>
- <li><a href="addTour.php">Add New Tour</a></li>
- <li><a href="updtAttraction.php">Update Attraction Details</a></li>
- </ul><br>
- </div>
- <br>
- <div class="col-sm-9">
- <div class="well">
- <h4>Edit Attraction - <?php echo $_REQUEST['Attraction'];?></h4>
- <p>This report shows the cities and their related attractions.</p>
- </div>
- <div class="row">
- <div class="col-sm-9">
- <div class="well">
- <table class="table">
- <tr>
- <th>Attraction No.</th>
- <th>AttractionName </th>
- <th>Category </th>
- <th>Allocated Time </th>
- </tr>
- <?php
- $name = $_REQUEST['Attraction'];
- include 'getAttractionDataForUpdate.php';?>
- </tr>
- <tr>
- <td>Change Name:</td>
- <form action="changeName.php" method="POST">
- <input type="hidden" name="oldname" value="<?php $_REQUEST['Attraction']?>"/>
- <td><input type="text" name="attname"></td>
- <td><input type="submit"></td>
- </form>
- </tr>
- <td>Change Category</td>
- <td>
- <form action="changeCategory.php" method="POST">
- <select name="enum">
- <option value="SHOPPING">Shopping</option>
- <option value="RELIGION">Religion</option>
- <option value="SPORT">Sport</option>
- <option value="ART">Art</option>
- </select>
- </td>
- <td><input type="submit"></td>
- <tr>
- </form>
- <td>Change Allocated Time</td>
- <form action="changeTime.php" method="POST">
- <td><input type="text" name="alltime"></td>
- <td><input type="submit"></td>
- </form>
- </tr>
- </table>
- </div>
- <p><a href="citatt.php">Back</p>
- </div>
- </div>
- </div>
- </div>
- </div>
- </div>
- </div>
- </div>
- </body>
- </html>
- ############################################
- ## changeName.php below
- ############################################
- <?php
- $servername = "localhost";
- $username = "root";
- $password = "";
- $dbname = "bustours_lp";
- // Create connection
- $conn = new mysqli($servername, $username, $password, $dbname);
- // Check connection
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- $oldname = $_REQUEST['oldname'];
- $newname = $_POST['attname'];
- $sql = "UPDATE attraction_lp SET AttractionName='$newname' WHERE AttractionName='$oldname'";
- $result = $conn->query($sql);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement