-
Notifications
You must be signed in to change notification settings - Fork 11
/
Copy pathviewreservation.php
97 lines (83 loc) · 2.58 KB
/
viewreservation.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
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Detaied Billing Report of Tamera Plaza Inn</title>
<style type="text/css">
@import url(css1.css);
.style2 {
font-size: 24px;
font-weight: bold;
}
</style>
</head>
<body>
<div align="center"><span class="style2">Tamera Plaza Inn</span><br />
#79 Lacson St., Bacolod City 6100<br />
Telephone: +63(034) 432-1708<br />
Telefax: +63(034) 709-0886<br />
Mobile: 09226355035<br />
Email: [email protected]</div>
<p> </p>
<div class="paperl">
<?php
if (isset($_GET['id'])){
$con = mysql_connect("127.0.0.1", "root", "");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("argie_tamera", $con);
$member_id = $_GET['id'];
$result = mysql_query("SELECT * FROM reservation WHERE reservation_id = '$member_id'");
while($row = mysql_fetch_array($result))
{
echo '<br />';
echo '<b>'.'Booker Personnal Information'.'</b>';
echo '<br />';
echo "FirstName: ".$row['firstname']. "<br />";
echo "LastName: ".$row['lastname']. "<br />";
echo "Address: ".$row['province']. "<br />";
echo "City: ".$row['city']. "<br />";
echo "Zip: ".$row['zip']. "<br />";
echo "Country: ".$row['country']. "<br />";
echo "Email: ".$row['email']. "<br />";
echo "Telephone/Cellphone Number: ".$row['contact']. "<br />";
echo '<br />';
echo '<b>'.'Payment Information'.'</b>'.'<br />';
/* echo 'Card Type: '.$row['cardtype'];
echo '<br>';
echo 'Card No.: '.$row['cardno'];
echo '<br>';
echo 'Expiry Date: '.$row['expiry'];
echo '<br>';
echo 'Name of Card Holder: '.$row['cardname'];
echo '<br>';
echo 'Security Code: '.$row['security'];*/
echo '<br>';
echo '<br />';
echo '<b>'.'Reservation Details'.'</b>'.'<br />';
echo "Arrival Date: ".$row['arrival']. "<br />";
echo "Departure Date: ".$row['departure']. "<br />";
echo "Confirmation Code: ".$row['confirmation']. "<br />";
echo "Number of night stay: ".$row['result'];
echo '<br />';
echo '<br />';
echo '<b>'.'Rate Information'.'</b>'.'<br />';
$q=$row['room_id'];
$result1 = mysql_query("SELECT * FROM room WHERE room_id = '$q'");
while($row1 = mysql_fetch_array($result1))
{
echo "Room Type: ".$row1['type']. "<br />";
echo "Room Rate: ".$row1['rate']. "<br />";
}
echo 'Total Payable amount: ';
echo $row['payable'];
}
mysql_close($con);
}
?>
</div>
<p> </p>
</body>
</html>