· 8 years ago · Oct 09, 2017, 09:52 PM
1<html>
2 <head>
3 <title></title>
4 </head>
5 <link rel="stylesheet" href="River.css">
6 <body>
7
8 <ul>
9 <li><a href="River.html">Home</a></li>
10 <li><a href="gallery.html">Gallery</a></li>
11 <li><a href="rates.html">Rates</a></li>
12 <li><a href="rooms.html">Rooms</a></li>
13 <li><a class="active" href="reservation.php">Reservation</a></li>
14 <li style ="float: right"><a href="login.php">Log In</a></li>
15 <li style ="float: right"><a href="about.html">About</a></li>
16 </ul>
17
18
19 <form action="checkres.php?status=0" method="POST">
20 <fieldset id="reserveform" >
21 <legend>Search for a room</legend>
22 <table>
23 <tr>
24 <td>
25 Room Capacity:
26 </td>
27 <td>
28 <select name="froomcapacity">
29 <option value="sroomcapacity" selected="selected">Room Capacity </option>>
30 <option value=2>2</option>
31 <option value=4>4</option>
32 <option value=6>6</option>
33 <option value=7>7</option>
34 <option value=15>15</option>
35 <option value=25>25</option>
36 </select>
37 </td>
38 </tr>
39 <tr>
40 <td>
41 Date From:
42 </td>
43 <td>
44 <input type="date" name="datein" id="datein" value="date"/>
45 </td>
46 </tr>
47 <tr>
48 <td>
49 Date To:
50 </td>
51 <td>
52 <input type="date" name="dateto" id="dateto" value="date"/>
53 </td>
54 </tr>
55 <tr>
56 <td>
57 </td>
58 <td>
59 <input type=submit value="See Availability">
60 </td>
61 </tr>
62
63 </table>
64 </fieldset>
65 </form>
66
67
68
69
70
71 <?php
72 $servername="localhost";
73 $username="root";
74 $password="";
75 $database="reservation_db";
76
77 $conn = mysqli_connect($servername,$username,$password);
78 if ($conn->connect_error) {
79 die("Connection failed: " . $conn->connect_error );
80 }
81
82 $sql="CREATE DATABASE IF NOT EXISTS reservation_db";
83 if ($conn->query($sql) === TRUE) {
84 //echo "Database created successfully";
85 } else {
86 echo "Error creating database: " . $conn->error;
87 }
88
89
90 //room type
91 $sql = "CREATE TABLE if not exists reservation_db.room_type_tbl (
92 room_type_id INT(11) PRIMARY KEY,
93 room_name VARCHAR(80) NOT NULL,
94 room_capacity int,
95 room_price int
96 )";
97 if ($conn->query($sql) === TRUE) {
98 //echo "Table MyGuests created successfully";
99 } else {
100 echo "Error creating table: " . $conn->error;
101 }
102
103
104
105 // roomlist
106 $sql = "CREATE TABLE if not exists reservation_db.room_tbl (
107 room_id INT PRIMARY KEY,
108 room_number VARCHAR(30) NOT NULL,
109 room_type_id int(11),
110 room_desc varchar(100),
111 foreign key (room_type_id) references room_type_tbl(room_type_id)
112 )";
113 if ($conn->query($sql) === TRUE) {
114 //echo "Table MyGuests created successfully";
115 } else {
116 echo "Error creating table: " . $conn->error;
117 }
118
119 //customer detail
120 $sql = "CREATE TABLE if not exists reservation_db.customer_tbl (
121 customer_id int primary key,
122 first_name varchar(20),
123 last_name varchar(20),
124 customer_address varchar(50),
125 phone_number int,
126 email_address varchar(20),
127 customer_password varchar(30)
128
129 )";
130 if ($conn->query($sql) === TRUE) {
131 //echo "Table MyGuests created successfully";
132 } else {
133 echo "Error creating table: " . $conn->error;
134 }
135
136
137
138 //booking
139 $sql = "CREATE TABLE if not exists reservation_db.booking_tbl (
140 booking_id int primary key,
141 customer_id int,
142 room_id int,
143 booking_date date,
144 checkin_date date,
145 checkoutdate date,
146 foreign key (room_id) references room_tbl(room_id),
147 foreign key (customer_id) references customer_tbl(customer_id)
148
149 )";
150 if ($conn->query($sql) === TRUE) {
151 //echo "Table MyGuests created successfully";
152 } else {
153 echo "Error creating table: " . $conn->error;
154 }
155
156 //payment
157 $sql = "CREATE TABLE if not exists reservation_db.payment_tbl (
158 payment_id int primary key,
159 booking_id int,
160 credit_card_no int,
161 credit_expire_date date,
162 foreign key (booking_id) references booking_tbl(booking_id)
163
164 )";
165 if ($conn->query($sql) === TRUE) {
166 //echo "Table MyGuests created successfully";
167 } else {
168 echo "Error creating table: " . $conn->error;
169 }
170
171 //member table
172 $sql= " CREATE TABLE if not exists reservation_db.admin_tbl(
173 admin_id int UNSIGNED AUTO_INCREMENT primary key,
174 admin_email varchar(30),
175 admin_pass varchar(30)
176 )";
177 if ($conn->query($sql) === TRUE) {
178 //echo "Table MyGuests created successfully";
179 } else {
180 echo "Error creating table: " . $conn->error;
181 }
182?>
183 </body>
184</html>