-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy paths_fetch.php
51 lines (47 loc) · 1.18 KB
/
s_fetch.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
<!DOCTYPE html>
<html>
<head>
<title>
</title>
<?php include 'style.css';?>
</head>
<body>
<div class="center-div">
<div class="table-responsive">
<table>
<thead>
<tr>
<th>emp_id</th>
<th>f_name</th>
<th>l_name</th>
<th>email_id</th>
<th>dob</th>
<th>phone_no</th>
<th>address</th>
<th>designation</th>
</tr>
</thead>
<tbody>
<?php
include 'connection.php';
$selectquery = "select emp_id,f_name,l_name,email_id,dob,phone_no,address,designation from employee where designation='Staff' order by emp_id asc";
$query = mysqli_query ($con,$selectquery);
while($res = mysqli_fetch_array($query)){
?>
<tr>
<td><?php echo $res['emp_id'];?></td>
<td><?php echo $res['f_name'];?></td>
<td><?php echo $res['l_name'];?></td>
<td><?php echo $res['email_id'];?></td>
<td><?php echo $res['dob'];?></td>
<td><?php echo $res['phone_no'];?></td>
<td><?php echo $res['address'];?></td>
<td><?php echo $res['designation'];?></td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>