hotel_management_system/staff.php at main · karimshaban01/hotel_management_system · GitHub

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
<?php
$servername = "localhost";
    $userneme = "root";
    $password = "";
    $dbname = "hotel";

    $conn = mysqli_connect($servername, $userneme, $password, $dbname);

    if(!$conn){
        die ("failed to connect");
    }
    else {
        echo "";
    }
$sql = "SELECT * FROM orders";
$stmt = mysqli_stmt_init($conn);
$stmt = mysqli_prepare($conn, $sql);

if($stmt = mysqli_prepare($conn, $sql)){
    mysqli_stmt_execute($stmt);
    $result = mysqli_stmt_get_result($stmt);


echo '
<!DOCTYPE HTML>
<html>
<head>
<title>order</title>
<link href="bootstrap-5.0.2-dist\css\bootstrap.css" rel="stylesheet">
<link href="bootstrap-5.0.2-dist\css\bootstrap-grid.css" rel="stylesheet">
<link href="home.html">


<style>
table {
  border-collapse: collapse;
  width: 70%;

}

th {
  text-align: left;
  padding: 8px;


}
 td {
  text-align: left;
  padding: 8px;
  }


tr: nth-child(even) {
  background-color: #D6EEEE;
}

.btn {
  color: #0d6efd;
  border-color: #0d6efd;
  margin-left: 0%;
	margin-top: 20px;
}
.btn:hover {
  color: #fff;
  background-color: #0d6efd;
  border-color: #0d6efd;
}
.btn:focus + .btn-outline-primary, .btn:focus {
  box-shadow: 0 0 0 0.25rem rgba(13, 110, 253, 0.5)

			}
</style>
</head>
<body>
<div>
<table>
<tr>
<td>
<div class="card" style="margin-left: 20%; width: 100%">
<form style="margin-left: 2%" method="POST">
<div style="margin-left: 25%">
<legend><img style="height: 20%; width: 20%; border-radius: 60%; margin-left: 50px" src="aa.jpg"></legend><br>
<h2>HELLO DEAR STAFF<br>HERE ARE ORDERS FOR YOU. <br><br>SERVE THEM ALL NOW </h2><br>
</div>
<table style="width: 100%"><tr>
<th style="color: red; width: 25%" ><h4>CUSTOMER NAME: <br></h4></th>


<th style="color: red; width: 20%" ><h4>TABLE NAME:	</h4></th>

<th style="color: red; width: 20%"><h4>DELIVERY PLACE:	</h4></th>

<th style="color: red; width: 20%"><h4>SEAT NUMBER:	</h4></th>

<th style="color: red; width: 20%"><h4>ORDER SIZE:	</h4></th></tr>';

while ($row = mysqli_fetch_assoc($result))
                {
                    echo '<table class="table">
                    <tr class="tr"><td class="td" style="width: 10%">'.$row['customer-name']. '</td><td class="td" style="width: 10%">'.strtoupper($row['table-name']). '</td><td class="td" style="width: 10%">'.$row['place']. '</td><td style="width: 5%">'.$row['seat-number']. '</td><td class="td" style="width: 5%">'.$row['order-size']. '</td></tr>
                          </table>';

                    }


echo '<div style="text-align: center"><button type="submit" value="SUBMIT" class="btn">DONE!!!</button><br><br>
<blockquote><h4>"Ensure they are satisfied"</h4></blockquote></div>
<div style="text-align: center; color: red"><h5>&copy;officialkareem, 2022.</h5></div>
</form>
</div>
<form>
</form>
</body>
</html>';
                }
                ?>