Railway_Reservation_Database_System/pnr_status.php at master · basant-kumar/Railway_Reservation_Database_System · 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
<?php
session_start();
include 'dbconnect.php';

if(isset($_POST['submit'])){
	//include 'dbconnect.php';
	$err  ="";
	$pnr_no = $p_name = $p_age = $p_gen = $p_seat_no = $p_coach = $p_status = $tn = $s_date = "";
	$pnr_no = $_POST['pnr_no'];
	$sql  = "select * from passenger where pnr_no = ? order by p_name";
	$stmt= $conn->prepare($sql);
	$stmt->bind_param('i',$pnr_no);
	$stmt->execute();
	$stmt->bind_result($pnr_no,$p_name,$p_age,$p_gen,$p_seat_no,$p_coach,$tn,$s_date,$p_status);
	$stmt->store_result();
	if(!$stmt->fetch()){
		$err = "PNR not found";
	}
	$stmt->data_seek(0);
}

?>


<!DOCTYPE html>
<html>
<head>
	<title>Ticket Cancellation</title>
	<link rel="stylesheet" type="text/css" href="css/index.css" ></link>
</head>
<body style=" background-color: #f7f7f7;">
<div>
	<ul>
		<?php if(isset($_SESSION['user_name'])){ ?>
		<li><a class="active" href="index.php">Home</a></li>
		<li><a  href="pnr_status.php">PNR Status</a></li>
		<li><a  href="cancel_ticket.php">Cancel Ticket</a></li>
		<li style="float: right;"><a href="logout.php">Log Out</a></li>
		<li style="float: right;"><p>Hi <?php echo " ".$_SESSION['user_name']."   "?></p></li>
		<?php } else {?>
		<li><a class="active" href="index.php">Home</a></li>
		<li><a  href="pnr_status.php">PNR Status</a></li>
		<li style="float: right"><a  href="signup.php">SignUp</a></li>
		<li style="float: right"><a  href="login.php">Login</a></li>
		<?php }?>
	</ul>
</div><br><br><br><br><br><br>

<?php if(!isset($_POST['submit'])) {?>
<h3 align="center">Enter your PNR No</h3>
<div align="center">
<form method="POST" action=pnr_status.php>
	<input type="text" name="pnr_no" placeholder="PNR No">
	<input type="submit" name="submit">
</form>
</div>
<div align="center">
	<?php } else if($err != "") echo $err; else {?>
</div>

<div align="center">
	<h4>Result</h4>
		<table>
			<tr>
				<th>
					Name
				</th>
				<th>
					Age
				</th>
				<th>
					Gender
				</th>
				<th>
					Seat No
				</th>
				<th>
					Coach
				</th>
				<th>
					Status
				</th>
			</tr>
			<?php $counter = 1; while($stmt->fetch()) { ?>
			<tr>
				<td><?php echo $p_name; ?></td>
				<td><?php echo $p_age; ?></td>
				<td><?php echo $p_gen; ?></td>
				<td><?php echo $p_seat_no; ?></td>
				<td><?php echo $p_coach; ?></td>
				<td><?php echo $p_status; ?></td>
			</tr>
			<?php }?>
		</table>
</div>
<?php }?>
</body>
</html>