This repository has been archived by the owner on Oct 17, 2023. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
/
login.php
147 lines (117 loc) · 6.21 KB
/
login.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
<!DOCTYPE html>
<?php
session_start();
$msg = "";
if (isset($_POST['submit'])) {
include('connection.php');
$customerid=$_SESSION['Customerid'];
$confirmation=$_GET['confirmation'];
$sql = "select tblpaypal.balance,tblreservation.Payable,tblreservation.Reservation_ID
FROM tblreservation INNER JOIN tblusers ON tblreservation.Customer_ID=tblusers.Customer_ID
INNER JOIN tblpaypal ON tblreservation.Customer_ID=tblpaypal.customer_id
WHERE tblreservation.Customer_ID= '".$customerid."' AND tblreservation.Confirmation='".$confirmation."'";
$result = mysqli_query($conn,$sql) or die(mysqli_error($conn));
$row= mysqli_fetch_assoc($result);
$amount=$row['Payable'];
$paypalbalance=$row['balance'];
$total=$paypalbalance -abs($amount);
$reservationid=$row['Reservation_ID'];
$email = $_POST['email'];
$emaillower = strtolower($email);
$resultsql = "SELECT * FROM tblusers WHERE Email='$emaillower' AND Customer_ID='$customerid'";
$query = $conn->query($resultsql);
if (empty($email)) {
$msg = "Invalid Username or Password!";
}
else if ($paypalbalance <= $amount ){
echo "<script>alert('your balance is not enought to pay to amount, Please Contact the Owner of this Hotel For process your reservation right now ')</script>";
echo "<script>window.location='room/login.php';</script>";}
else if ($query->num_rows==1) {
$sql2="update tblpaypal set balance='".$total."' where Customer_ID='".$customerid."'"; //update reservation to confirmation
$sql3="update tblreservation set Status='Confirmed', transaction='Complete' where Customer_ID='".$customerid."' AND Confirmation='".$confirmation."'";
$sql4="update tblreservationnotify set Unread=1 where Confirmation='".$confirmation."'";
$sql5="update tbltransaction set Status='Confirmed' where Reservation_ID='".$reservationid."' ";
$result=mysqli_query($conn,$sql2);
$result=mysqli_query($conn,$sql3);
$result=mysqli_query($conn,$sql4);
$result=mysqli_query($conn,$sql5);
$to = $emaillower;
$subject = "Thank's for login your paypal account";
$message = 'Hi, you just received an email using sendmail!';
$headers = 'From: progwebtwister@gmail.com' . "\r\n" .
'MIME-Version: 1.0' . "\r\n" .
'Content-type: text/html; charset=utf-8';
mail($to, $subject, $message, $headers);
echo "<script>alert('Successfully Reserve with PayPal')</script>";
echo "<script>window.location='../room/completepaypal.php';</script>";
} else {
$msg = "Invalid Username or Password!";
}
}
?>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>Pay with a debit or credit card</title>
<!-- Bootstrap Core CSS -->
<link href="adminpage/bower_components/bootstrap/dist/css/bootstrap.min.css" rel="stylesheet">
<!-- MetisMenu CSS -->
<link href="adminpage/bower_components/metisMenu/dist/metisMenu.min.css" rel="stylesheet">
<!-- Custom CSS -->
<link href="adminpage/dist/css/sb-admin-2.css" rel="stylesheet">
<!-- Custom Fonts -->
<link href="adminpage/bower_components/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">
<!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
<script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
<![endif]-->
</head>
<body style="background-color:#fff;">
<div class="container">
<div class="row">
<div class="col-md-4 col-md-offset-4">
<div class="login-panel panel panel-default"><center><h5 style="color:rgb(255, 54, 0);">Choose a way to pay</h5></center>
<div class="panel-heading">
<h3 class="panel-title" style="color:rgb(19, 81, 152);">Pay with PayPal account </h3>
<p><small><small>Log in to your PayPal account to complete the purchase</small></small></p>
</div>
<div class="panel-body">
<form role="form" action="" method="POST">
<fieldset>
<div class="form-group">
<input class="form-control" placeholder="E-mail" name="email" type="email" autofocus>
</div>
<div class="checkbox">
<label>
<input name="remember" type="checkbox" value="Remember Me">Remember Me
</label>
</div>
<label>
<p style="color:red"><?php echo $msg; ?></p>
</label>
<!-- Change this to a button or input when using this as a form -->
<input name="submit" class="btn btn-lg btn-paypal btn-block" type="submit" value="Continue" />
<a href="paypalregister.php?cid=<?php echo $customerid;?>" class="btn btn-lg btn-default btn-block">Cancel</a>
</fieldset>
</form>
</div>
</div>
</div>
</div>
</div>
<!-- jQuery -->
<script src="../bower_components/jquery/dist/jquery.min.js"></script>
<!-- Bootstrap Core JavaScript -->
<script src="../bower_components/bootstrap/dist/js/bootstrap.min.js"></script>
<!-- Metis Menu Plugin JavaScript -->
<script src="../bower_components/metisMenu/dist/metisMenu.min.js"></script>
<!-- Custom Theme JavaScript -->
<script src="../dist/js/sb-admin-2.js"></script>
</body>
</html>