Advertisement
Guest User

html

a guest
Apr 4th, 2018
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.49 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4. <title>Bootstrap Example</title>
  5. <meta charset="utf-8">
  6. <meta name="viewport" content="width=device-width, initial-scale=1">
  7. <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
  8. <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
  9. <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
  10. <style>
  11. /* Set height of the grid so .sidenav can be 100% (adjust as needed) */
  12. .row.content {height: 550px}
  13.  
  14. /* Set gray background color and 100% height */
  15. .sidenav {
  16. background-color: #f1f1f1;
  17. height: 100%;
  18. }
  19.  
  20. /* On small screens, set height to 'auto' for the grid */
  21. @media screen and (max-width: 767px) {
  22. .row.content {height: auto;}
  23. }
  24. </style>
  25. </head>
  26. <body>
  27.  
  28. <nav class="navbar navbar-inverse visible-xs">
  29. <div class="container-fluid">
  30. <div class="navbar-header">
  31. <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#myNavbar">
  32. <span class="icon-bar"></span>
  33. <span class="icon-bar"></span>
  34. <span class="icon-bar"></span>
  35. </button>
  36. <a class="navbar-brand" href="#"><img src=logo.png></a>
  37. </div>
  38. <div class="collapse navbar-collapse" id="myNavbar">
  39. <ul class="nav navbar-nav">
  40. <li><a href="index.html">Dashboard</a></li>
  41. <li class="active"><a href="citatt.php">Cities and Attractions</a></li>
  42. <li><a href="addTour.php">Add New Tour</a></li>
  43. <li><a href="updtAttraction.php">Update Attraction Details</a></li>
  44. </ul>
  45. </div>
  46. </div>
  47. </nav>
  48.  
  49. <div class="container-fluid">
  50. <div class="row content">
  51. <div class="col-sm-3 sidenav hidden-xs">
  52. <h2><img src=logo.png width> </h2>
  53. <ul class="nav nav-pills nav-stacked">
  54. <li><a href="index.html">Dashboard</a></li>
  55. <li class="active"><a href="citatt.php">Cities and Attractions</a></li>
  56. <li><a href="addTour.php">Add New Tour</a></li>
  57. <li><a href="updtAttraction.php">Update Attraction Details</a></li>
  58. </ul><br>
  59. </div>
  60. <br>
  61.  
  62. <div class="col-sm-9">
  63. <div class="well">
  64. <h4>Edit Attraction - <?php echo $_REQUEST['Attraction'];?></h4>
  65. <p>This report shows the cities and their related attractions.</p>
  66. </div>
  67. <div class="row">
  68. <div class="col-sm-9">
  69. <div class="well">
  70. <table class="table">
  71. <tr>
  72. <th>Attraction No.</th>
  73. <th>AttractionName </th>
  74. <th>Category </th>
  75. <th>Allocated Time </th>
  76. </tr>
  77. <?php
  78. $name = $_REQUEST['Attraction'];
  79. include 'getAttractionDataForUpdate.php';?>
  80. </tr>
  81. <tr>
  82. <td>Change Name:</td>
  83. <form action="changeName.php" method="POST">
  84. <input type="hidden" name="oldname" value="<?php $_REQUEST['Attraction']?>"/>
  85. <td><input type="text" name="attname"></td>
  86. <td><input type="submit"></td>
  87. </form>
  88. </tr>
  89. <td>Change Category</td>
  90. <td>
  91. <form action="changeCategory.php" method="POST">
  92. <select name="enum">
  93. <option value="SHOPPING">Shopping</option>
  94. <option value="RELIGION">Religion</option>
  95. <option value="SPORT">Sport</option>
  96. <option value="ART">Art</option>
  97. </select>
  98. </td>
  99. <td><input type="submit"></td>
  100. <tr>
  101. </form>
  102. <td>Change Allocated Time</td>
  103. <form action="changeTime.php" method="POST">
  104. <td><input type="text" name="alltime"></td>
  105. <td><input type="submit"></td>
  106. </form>
  107. </tr>
  108. </table>
  109. </div>
  110. <p><a href="citatt.php">Back</p>
  111. </div>
  112.  
  113.  
  114. </div>
  115.  
  116. </div>
  117. </div>
  118. </div>
  119. </div>
  120. </div>
  121. </div>
  122.  
  123. </body>
  124. </html>
  125.  
  126.  
  127. ############################################
  128. ## changeName.php below
  129. ############################################
  130.  
  131. <?php
  132. $servername = "localhost";
  133. $username = "root";
  134. $password = "";
  135. $dbname = "bustours_lp";
  136.  
  137. // Create connection
  138. $conn = new mysqli($servername, $username, $password, $dbname);
  139.  
  140. // Check connection
  141. if ($conn->connect_error) {
  142. die("Connection failed: " . $conn->connect_error);
  143. }
  144.  
  145.  
  146. $oldname = $_REQUEST['oldname'];
  147. $newname = $_POST['attname'];
  148. $sql = "UPDATE attraction_lp SET AttractionName='$newname' WHERE AttractionName='$oldname'";
  149. $result = $conn->query($sql);
  150.  
  151.  
  152.  
  153.  
  154.  
  155.  
  156. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement