-
Notifications
You must be signed in to change notification settings - Fork 2
/
empSearchFilter.php
107 lines (97 loc) · 4.2 KB
/
empSearchFilter.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
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<!-- <link
href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css"
rel="stylesheet"
integrity="sha384-1BmE4kWBq78iYhFldvKuhfTAU6auU8tT94WrHftjDbrCEXSU1oBoqyl2QvZ6jIW3"
crossorigin="anonymous"
/> -->
<link rel="stylesheet" href="node_modules/bootstrap/dist/css/bootstrap.min.css">
<title>Employee Search and Filter</title>
</head>
<body>
<nav class="navbar navbar-expand-lg navbar-dark bg-dark mb-5">
<div class="container-fluid">
<a class="navbar-brand" href="dashboard.php" style="margin-left:20px;">Admin panel</a>
<ul class="navbar-nav mb-2 mb-lg-0" style="margin-right: 20px;">
<li class="nav-item">
<a class="nav-link" href="index.php">Home</a>
</li>
<li class="nav-item">
<a class="nav-link" href="employee.php">Back to employee page</a>
</li>
</div>
</nav>
<div class="container">
<h2 style="text-align:center;margin-bottom:30px;">SEARCH AND FILTER</h2>
<div class="row">
<form class="form-horizontal" action="" method="post">
<h5 style="text-align:center;margin-bottom:30px;">You can search employee's data by entering his/her NAME</h5>
<div class="row mb-3">
<div style="width:15%;">
<!-- <label for="inputEmail3" class="col-sm-2 col-form-label">Name</label> -->
</div>
<div class="col-sm-10">
<input type="text" name="name" class="form-control" id="inputEmail3" placeholder="Search or Filter through Name or Service"/>
</div>
</div>
<div class="row mb-5">
<center><input name="submit" type="submit" value="SEARCH" class="form-control btn btn-primary" id="inputPassword3" style="width:30%;"/></center>
</div>
</form>
</div>
</div>
<?php
$link=new mysqli('localhost','root','','laundry');
if(isset($_POST['submit'])){
$name=$_POST['name'];
$query="SELECT * FROM employee WHERE `name` LIKE '%$name%' ";
$data=mysqli_query($link,$query);
$num=mysqli_num_rows($data);
if($num>0){
echo "<table class='table table-dark'>
<tr>
<th scope='col'>Name</th>
<th scope='col'>Phone No.</th>
<th scope='col'>Address</th>
<th scope='col'>Salary</th>
<th scope='col'>Gender </th>
<th scope='col'>Age</th>
<th scope='col'></th>
<th scope='col'></th>
</tr>";
while($row=mysqli_fetch_assoc($data)){
$eid=$row['eid'];
$name=$row['name'];
$phone=$row['phone'];
$address=$row['address'];
$salary=$row['salary'];
$gender=$row['gender'];
$age=$row['age'];
?>
<tr>
<td> <?php echo "$name";?></td>
<td> <?php echo "$phone";?></td>
<td> <?php echo "$address";?></td>
<td> <?php echo "$salary";?></td>
<td> <?php echo "$gender";?></td>
<td> <?php echo "$age";?></td>
<td><a href="emp_edit.php?id=<?php echo "$eid"; ?>> <button type="text/javascript" class='btn btn-primary'>Edit</button> </td>
<td><a href="emp_delete.php?id=<?php echo "$eid"; ?>> <button type="text/javascript" class='btn btn-danger'>Delete</button></td>
<?php
}
}
else{
?>
<h1 style="text-align:center;margin-top:50px;color: red;">Record not found...</h1>
<center><h1 style="font-size:100px;">😑</h1></center>
<?php
}
}
?>
</body>
</html>