bms/update_route.php at main · spacedust26/bms · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
<?php
  include "connection.php";
  include "connection_details.php";
  $id = $_GET['routeid'];
  $sql = "SELECT * FROM route WHERE route_id = '$id'";
  $result = mysqli_query($data,$sql);
  $info = $result->fetch_assoc();


  if(isset($_POST['update_route'])){
    $routeid = $_POST['rid'];
    $startpoint = $_POST['startpt'];
    $stoppoint = $_POST['stoppt'];
    $distance = $_POST['distance'];
    $no_of_stops = $_POST['no_of_stops'];

    $query = "UPDATE route set start_point = '$startpoint',stop_point='$stoppoint',distance='$distance',no_of_stops='$no_of_stops' WHERE route_id = '$id'";
    $result2 = mysqli_query($data, $query);
    if($result2){
      header("location:view_route.php");
    }
  }
?>
<!DOCTYPE html>
<html lang="en">
  <head>
    <title>Local Bus - Route Update</title>
    <link rel="icon" href="images/favicon.ico" type="image/x-icon">
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <link href="https://fonts.googleapis.com/css?family=Poppins:200,300,400,500,600,700,800&display=swap" rel="stylesheet">
    <link rel="stylesheet" href="css/open-iconic-bootstrap.min.css">
    <link rel="stylesheet" href="css/style.css">
    <link rel="stylesheet" href="css/bms-bus.css">
    <link rel="stylesheet" href="css/bmscss.css">
  </head>
  <body>

	  <nav class="navbar navbar-expand-lg navbar-dark ftco_navbar bg-dark ftco-navbar-light" id="ftco-navbar">
	    <div class="container">
	      <a class="navbar-brand" href="index.html">Local<span>Bus</span></a>
	      <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#ftco-nav" aria-controls="ftco-nav" aria-expanded="false" aria-label="Toggle navigation">
	        <span class="oi oi-menu"></span> Menu
	      </button>

				<div class="collapse navbar-collapse" id="ftco-nav">
	        <ul class="navbar-nav ml-auto">
	          <li class="nav-item"><a href="index.php" class="nav-link">Home</a></li>
	          <li class="nav-item"><a href="bus.php" class="nav-link">Bus</a></li>
	          <li class="nav-item"><a href="employee.php" class="nav-link">Employee</a></li>
	          <li class="nav-item active"><a href="route.php" class="nav-link">Routes & Schedules</a></li>
	          <li class="nav-item"><a href="ticket.php" class="nav-link">Tickets</a></li>
	          <li class="nav-item"><a href="maintenance.php" class="nav-link">Maintenance</a></li>
	        </ul>
	      </div>
        <div>
          <a href="log.php" class="bms-login-btn">Logout</a>
        </div>
	    </div>
	  </nav>
    <!-- END nav -->

    <div class="hero-wrap" style="background-image: url('images/bg_2.jpg');" data-stellar-background-ratio="0.5">
      <div class="container">
        <div class="row no-gutters slider-text justify-content-start align-items-center">
          	<aside>
              <ul class="bus-aside">
                <li><a href="route.php">Add Route</a></li>
                <li><a href="view_route.php">View Route</a></li>
                <li><a href="schedule.php">Add Schedule</a></li>
                <li><a href="view_schedule.php">View Schedules</a></li>
                <li><a href="delete_schedule.php">Delete Schedule</a></li><!--pending-->
              </ul>
            </aside>
          <div class="col-lg-6 col side-text" style="color: black;">
            <h3>Update Route</h3>
            <div>
              <form action="#" method="POST">
                <div>
                  <label>Route ID</label>
                  <input type="number" name="rid" value="<?php
                  echo "{$info['route_id']}";
                  ?>" disabled>
                </div>
                <div>
                  <label>Start Point</label>
                  <input type="text" name="startpt" value="<?php
                  echo "{$info['start_point']}";
                  ?>" required>
                </div>
                <div>
                  <label>Stop Point</label>
                  <input type="text" name="stoppt" value="<?php
                  echo "{$info['stop_point']}";
                  ?>" required>
                </div>
                <div>
                  <label>Distance</label>
                  <input type="number" name="distance" value="<?php
                  echo "{$info['distance']}";
                  ?>"  required>
                </div>
                <div>
                  <label>Number of Stops</label>
                  <input type="number" name="no_of_stops" value="<?php
                  echo "{$info['no_of_stops']}";
                  ?>"  required>
                </div>
                <div>
                  <input type="submit" name="update_route" value="Update" class="submit-btn">
                </div>
              </form>
            </div>
          </div>
        </div>
      </div>
    </div>

  <!-- loader -->
  <div id="ftco-loader" class="show fullscreen"><svg class="circular" width="48px" height="48px"><circle class="path-bg" cx="24" cy="24" r="22" fill="none" stroke-width="4" stroke="#eeeeee"/><circle class="path" cx="24" cy="24" r="22" fill="none" stroke-width="4" stroke-miterlimit="10" stroke="#F96D00"/></svg></div>
  <script src="js/jquery.min.js"></script>
  <script src="js/aos.js"></script>
  <script src="js/jquery-migrate-3.0.1.min.js"></script>
  <script src="js/jquery.waypoints.min.js"></script>
  <script src="js/jquery.stellar.min.js"></script>
  <script src="js/owl.carousel.min.js"></script>
  <script src="js/jquery.animateNumber.min.js"></script>
  <script src="js/scrollax.min.js"></script>
  <script src="js/main.js"></script>
  </body>
</html>