-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathlistOfTrains.php
159 lines (131 loc) · 5.49 KB
/
listOfTrains.php
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
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
<?php
session_start();
?>
<!DOCTYPE html>
<html>
<head>
<title> Railway Reservation System</title>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css" integrity="sha384-JcKb8q3iqJ61gNV9KGb8thSsNjpSL0n8PARn9HuZOnIxN0hoP+VmmDGMN5t9UJ0Z" crossorigin="anonymous">
<link rel="stylesheet" type="text/css" href="styles.css">
</head>
<body class="bgimg">
<nav class="navbar navbar-expand-lg navbar-dark bg-dark">
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarSupportedContent">
<?php
if(isset($_SESSION['fname'])){
echo '<ul class="navbar-nav mr-auto">
<li class="nav-item">
<a href="#" class="nav-link adv">Welcome '.$_SESSION["fname"].'!</a>
</li>
</ul>';
}
?>
<ul class="navbar-nav ml-auto">
<li class="nav-item">
<a class="nav-link adv" href="index.php">Home</a>
</li>
<li class="nav-item">
<a class="nav-link adv" href="aboutus.php">About Us</a>
</li>
<li class="nav-item">
<a class="nav-link adv" href="contactus.php">Contact Us</a>
</li>
<?php
if(isset($_SESSION['fname'])){
echo '<li class="nav-item">
<a href="ticket.php" class="nav-link adv">My Ticket</a>
</li>';
echo '<li class="nav-item">
<a class="nav-link adv" href="logout.php" >Logout</a>
</li>';
}
else{
echo '<li class="nav-item">
<a class="nav-link adv" href="login1.php">Login</a>
</li>';
}
?>
</ul>
</div>
</nav>
<marquee direction="left" scrollamount='10' class="text-light">Welcome to RAILWAY RESERVATION PORTAL</marquee>
<h1 class="text-center" style="color: #bff5cd;">ONLINE RAIL RESERVATION</h1>
<?php
echo '<table class=" listtable table-light text-center table table-bordered table-hover mt-5" style="opacity: 0.9; width: 80%; margin: auto;">
<tr>
<th>Train No.</th>
<th>From</th>
<th>To</th>
<th>Departure Time</th>
</tr>';
$server = "localhost";
$username = "root";
$password = "root";
$database = "railwayreservation";
// Create a database connection
$con = mysqli_connect($server, $username, $password, $database);
// Check for connection success
if(!$con){
die("connection to this database failed due to" . mysqli_connect_error());
}
if($_SERVER['REQUEST_METHOD']=='POST'){
$source = $_POST['source'];
$dest = $_POST['dest'];
$date = $_POST['date'];
$book="login1.php";
if(isset($_SESSION['fname'])){
$book="reservation.php";
}
$sql = "SELECT TRAIN_NUMBER,SOURCE,DESTINATION,ARRIVAL_TIME FROM train WHERE SOURCE= '".$source."' and DESTINATION = '".$dest."' and DATE_FORMAT(ARRIVAL_TIME,'%Y-%m-%d')='".$date."';";
// Execute the query
$result=mysqli_query($con,$sql);
$sql1 = "SELECT TRAIN_NUMBER FROM train WHERE SOURCE= '".$source."' and DESTINATION = '".$dest."' and DATE_FORMAT(ARRIVAL_TIME,'%Y-%m-%d')='".$date."';";
$result1=mysqli_query($con,$sql1);
if (mysqli_num_rows($result)== 0){
echo ' <tr><td colspan="4"><span style="color:red;";>NO TRAINS AVAILABLE FOR CURRENT ROUTE </span></td></tr> ';
}else{
while($row=mysqli_fetch_array($result)){
// var_dump($row);
echo '<tr>
<td>'.$row["TRAIN_NUMBER"].'</td>
<td>'.$row["SOURCE"].'</td>
<td>'.$row["DESTINATION"].'</td>
<td>'.$row["ARRIVAL_TIME"].'</td>
</tr>';
$_SESSION['source']=$row["SOURCE"];
$_SESSION['dest']=$row["DESTINATION"];
}
}
}
// } //Close the database connection
$con->close();
echo'</table>';
?>
<br>
<br>
<form method="POST" action="details.php" style="text-align:center">
<label style="color:white">Choose the train number you want to book:</label>
<select id="tno" name="tno" style="width:10%" required>
<?php while($row1=mysqli_fetch_array($result1)):; ?>
<option value="<?php echo $row1[0]; ?>"> <?php echo $row1[0]; ?></option>
<?php endwhile ?>
</select><br>
<button class="btn btn-success">Details</button>
</form>
<script>
function Book() {
<?php if(!(isset($_SESSION['fname']))){
echo 'alert("Please login first");
document.getElementById("Book").setAttribute("href","login1.php");';
}
?>
}
</script>
<script src="index.js"></script>
<script src="https://code.jquery.com/jquery-3.5.1.slim.min.js" integrity="sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/js/bootstrap.bundle.min.js" integrity="sha384-ho+j7jyWK8fNQe+A12Hb8AhRq26LrZ/JpcUGGOn+Y7RsweNrtN/tE3MoK7ZeZDyx" crossorigin="anonymous"></script>
</body>
</html>