-
Notifications
You must be signed in to change notification settings - Fork 0
/
xuatExcelNV.php
55 lines (55 loc) · 1.42 KB
/
xuatExcelNV.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
<?php
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=data.xls");
header("Pragma: no-cache");
header("Expires: 0");
?>
<meta charset="utf-8" />
<table>
<thead>
<tr>
<td>Tên</td>
<td>Giới tính</td>
<td>Ngày sinh</td>
<td>Chức vụ</td>
<td>Lương</td>
<td>CMND</td>
<td>SDT</td>
<td>Email</td>
<td>Địa chỉ</td>
<td>Hình ảnh</td>
<td>Phòng ban</td>
</tr>
</thead>
<tbody>
<?php
$conn=new mysqli('localhost','root','','qlnhanvien1');
$sql="SELECT nhanvien.manv, nhanvien.ten,
nhanvien.gioitinh, nhanvien.ngaysinh,
nhanvien.chucvu, nhanvien.luong,
nhanvien.cmnd, nhanvien.sdt,
nhanvien.email, nhanvien.diachi,
nhanvien.hinhanh, phongban.tenphongban
FROM nhanvien, phongban
WHERE nhanvien.maphongban=phongban.maphongban";
$result=$conn->query($sql);
if($result->num_rows>0){
while($row=$result->fetch_assoc()){
?>
<tr>
<td><?php echo $row['ten']?></td>
<td><?php echo $row['gioitinh']?></td>
<td><?php echo $row['ngaysinh']?></td>
<td><?php echo $row['chucvu']?></td>
<td><?php echo $row['luong']?></td>
<td><?php echo $row['cmnd']?></td>
<td><?php echo $row['sdt']?></td>
<td><?php echo $row['email']?></td>
<td><?php echo $row['diachi']?></td>
<td><?php echo $row['hinhanh']?></td>
<td><?php echo $row['tenphongban']?></td>
</tr>
<?php }
} ?>
</tbody>
</table>