-
Notifications
You must be signed in to change notification settings - Fork 50
/
new_png.php
112 lines (88 loc) · 2.72 KB
/
new_png.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
<html>
<body style=" background-image: url(pnglogin.jpg);
height: 100%;
background-position: center;
background-repeat: no-repeat;
background-size: cover;" >
<?php
session_start();
require "db.php";
$pname=$_POST["pname"];
$page=$_POST["page"];
$pgender=$_POST["pgender"];
$tno=$_SESSION["tno"];
$doj=$_SESSION["doj"];
$sp=$_SESSION["sp"];
$dp=$_SESSION["dp"];
$class=$_SESSION["class"];
//echo "$tno $doj $class";
$query=" SELECT fare FROM classseats WHERE trainno='".$tno."' AND class='".$class."' AND doj='".$doj."' AND sp='".$sp."' AND dp='".$dp."' ";
$result=mysqli_query($conn,$query) or die(mysql_error());
$row=mysqli_fetch_array($result);
$fare=$row[0];
//echo "$fare";
$tempfare=0;
$temp=0;
for($i=0;$i<$_SESSION["nos"];$i++)
{
if($page[$i]>=18)
{
$temp++;
$tempfare+=$fare;
}
else if($page[$i]<18)
$tempfare+=0.5*$fare;
else if($page[$i]>=60)
$tempfare+=0.5*$fare;
}
//echo " $tempfare";
if($temp==0)
{
echo "<br><br>Atleast one adult must accompany!!!";
echo "<br><br><a href=\"http://localhost/railway/enquiry.php\">Back to Enquiry</a> <br>";
die();
}
echo "Total fare is Rs.".$tempfare."/-";
$sql = "INSERT INTO resv(id,trainno,sp,dp,doj,tfare,class,nos) VALUES ('".$_SESSION["id"]."','".$_SESSION["tno"]."','".$_SESSION["sp"]."','".$_SESSION["dp"]."','".$_SESSION["doj"]."','".$tempfare."','".$_SESSION["class"]."','".$_SESSION["nos"]."' )";
if ($conn->query($sql) === TRUE)
{
echo "<br><br>Reservation Successful";
}
else
{
echo "<br><br>Error: " . $conn->error;
}
$tid=$_SESSION["id"];
$ttno=$_SESSION["tno"];
$tdoj=$_SESSION["doj"];
$query=" Select pnr from resv where id='".$tid."' AND trainno='".$ttno."' AND doj='".$tdoj."' ";
$result=mysqli_query($conn,$query) or die(mysql_error());
//echo "HI,here's your ticket details";
//print_r($result);
$row=mysqli_fetch_array($result);
$rpnr=$row['pnr'];
//echo " $rpnr ";
$tpname=$_POST['pname'];
//$ntpname = count($_REQUEST['pname']);
$tpage=$_POST["page"];
$tpgender=$_POST["pgender"];
for($i=0;$i<$_SESSION["nos"];$i++)
{
$sql = "INSERT INTO pd(pnr,pname,page,pgender) VALUES ('".$rpnr."','".$tpname[$i]."','".$tpage[$i]."','".$tpgender[$i]."')";
if ($conn->query($sql) === TRUE)
{
echo "<br><br>Passenger details added!!!";
}
else
{
echo "<br><br>Error: " . $conn->error;
}
//echo "Enter Passanger Name: <input type='text' name='pname[]' required> ";
//echo "Enter Passanger Age: <input type='text' name='page[]' required>";
//echo "Enter Passanger Gender: <input type='text' name='pgender[]' required> <br> ";
}
echo "<br><br><a href=\"http://localhost/railway/index.htm\">Go Back!!!</a> <br>";
$conn->close();
?>
</body>
</html>