AC4Ednaz

1<?php
2$conn=mysqli_connect('localhost','root','');
3if($conn)
4    echo "<p>Connection set up successfully.</p>";
5mysqli_query($conn, "DROP DATABASE IF EXISTS hotelDB");
6if (mysqli_query($conn, "CREATE DATABASE hotelDB"))
7    echo "<p>Database created successfully.</p>";
8mysqli_select_db($conn, "hotelDB");
9//room_type table
10$myStatement= "CREATE TABLE room_type
11(
12room_type_id INT NOT NULL AUTO_INCREMENT,
13room_type_name VARCHAR(100),
14total_room INT DEFAULT 5,
15CONSTRAINT pk_room_type PRIMARY KEY (room_type_id)
16);";
17//reservation table
18$myStatement .="CREATE TABLE reservation
19(
20reservation_id INT NOT NULL AUTO_INCREMENT,
21room_type_id INT NOT NULL
22begin_date DATE NOT NULL
23end_date DATE NOT NULL
24confirm_number CHAR(13),
25CONSTRAINT pk_reservation PRIMARY KEY (reservation_id),
26CONSTRAINT fk_reservation_room_type FOREIGN KEY (room_type_id) REFERENCES
27room_type (room_type_id)
28);";
29if (mysqli_multi_query($conn, $myStatement))
30    echo "<p>Table created successfully.</p>";
31mysqli_close($conn);
32?>