-
Notifications
You must be signed in to change notification settings - Fork 0
/
staff.php
145 lines (129 loc) · 4.86 KB
/
staff.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
<?php
include 'header_footer.php';
?>
<!DOCTYPE html>
<html lang="en" dir="ltr">
<head>
<meta charset="utf-8">
<title>STAFF</title>
<link rel="stylesheet" href="farmer.css">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous">
<style media="screen">
.main-content{
margin-top: 140px;
}
.modal-content{
width: 50%;
}
#buttom{
margin: 10px 10px;
}
</style>
</head>
<body>
<div class="main-container">
<button onclick="document.getElementById('id03').style.display='block'" style="width:auto;" id="buttom"><i class="fas fa-user-plus"></i> Add STAFF</button>
<!-- Add staff -->
<div id="id03" class="modal">
<form class="modal-content animate" action="add.php" method="POST">
<h3> <b> <u> Add STAFF</u></b> </h3>
<div class="container">
<label for="id">Id Number <sup>*</sup> </label>
<input type="text" name="id" value="" placeholder="id number" required/>
<br>
<label for="fullname">Full Name <sup>*</sup> </label>
<input type="text" name="fullname" value="" placeholder="full name" required/>
<br>
<label for="phonenumber">Phone number<sup>*</sup> </label>
<input type="text" name="phone" value="" placeholder="Phone Number" maxlength="10" required/>
<br>
<label for="staffaddress">Address<sup>*</sup> </label>
<input type="text" name="address" value="" placeholder="address" required/>
<br>
<label for="salary">Salary<sup>*</sup> </label>
<input type="text" name="salary" value="" placeholder="salary" required/>
<br>
<label for="Designation">Designation<sup>*</sup> </label>
<input type="text" name="designation" value="" placeholder="Designation" required/>
<br>
<input type="submit" name="savestaffdata" class="submit-btn-add" value="Submit">
</div>
<div class="container" style="background-color:#f1f1f1">
<button type="button" onclick="document.getElementById('id03').style.display='none'" class="cancelbtn">Cancel</button>
</div>
</form>
</div>
<!--Fetch Details-->
<div class="card">
<div class="card-body">
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "dairy";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT * FROM staff ";
$query_run = mysqli_query($conn, $sql);
?>
<table class="table table-striped table-hover">
<thead>
<tr>
<th scope="col"><i class="fas fa-id-badge"></i> ID</th>
<th scope="col"><i class="fas fa-user-alt"></i> Name</th>
<th scope="col"><i class="fas fa-phone"></i> Phone</th>
<th scope="col"><i class="fas fa-address-book"></i> Address</th>
<th scope="col"><i class="fas fa-money-bill-wave"></i> Salary</th>
<th scope="col"><i class="fas fa-briefcase"></i> Designation</th>
<th scope="col"><i class="fas fa-caret-square-down"></i> More</th>
</tr>
</thead>
<?php
if ($query_run)
{
foreach ($query_run as $row)
{
?>
<tbody>
<tr>
<td> <?php echo $row['id']; ?> </td>
<td><?php echo $row['fullname'] ; ?></td>
<td> <?php echo $row['phone']; ?> </td>
<td> <?php echo $row['address']; ?> </td>
<td><i class="fas fa-rupee-sign"></i> <?php echo $row['salary']; ?> </td>
<td> <?php echo $row['designation']; ?> </td>
<td>
<div class="btn-group">
<a class="btn btn-secondary" href="edit.php?id=<?php echo $row['id']; ?>"><i class="fas fa-edit"></i> Edit</a>
<a class="btn btn-danger" onClick="javascript:return confirm('Do you really want to delete?');" href="delete.php?id=<?php echo $row['id']; ?>"> <i class="fas fa-trash-alt"></i> Delete</a>
</div>
</td>
</tr>
</tbody>
<?php
}
}
else {
echo "No Record Found";
}
?>
</table>
</div>
</div>
</div>
<script type="text/javascript">
// Get the modal
var modal = document.getElementById('idol3');
// When the user clicks anywhere outside of the modal, close it
window.onclick = function(event) {
if (event.target == modal) {
modal.style.display = "none";
}
}
</script>
</body>
</html>