-
Notifications
You must be signed in to change notification settings - Fork 0
/
suaHD.php
57 lines (56 loc) · 2.33 KB
/
suaHD.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
<?php
$connect = new mysqli("localhost", "root", "", "qlnhanvien1");
$output = '';
if(isset($_POST["query"]))
{
$search = mysqli_real_escape_string($connect, $_POST["query"]);
$query = "
SELECT hopdongld.mahd, nhanvien.ten,
hopdongld.loaihd, hopdongld.thoigianki,
hopdongld.thoigiankt FROM hopdongld,
nhanvien WHERE nhanvien.manv=hopdongld.manv
AND nhanvien.ten LIKE '%".$search."%'
OR loaihd LIKE '%".$search."%'
OR thoigianki LIKE'%".$search."%'
OR thoigiankt LIKE '%".$search."%';
";
$result = $connect->query($query);
if($result->num_rows > 0)
{
while($row = $result->fetch_assoc())
{
$output .= '
<div>
<h4>Thông tin hợp đồng</h4>
<form method="POST">
<div class="form-row form-group col-xl-12">
<input readonly type="text" readonly class="form-control" placeholder="mã hợp đồng" name="mahd" required value="'.$row['mahd'].'">
</div>
<div class="form-row form-group col-xl-12">
<input type="text" class="form-control" readonly placeholder="Tên nhân viên" name="tennvhd" required value="'.$row['ten'].'">
</div>
<div class="form-group form-row col-xl-12">
<input type="text" class="form-control" placeholder="Loại hợp đồng" name="lhdong" required value="'.$row['loaihd'].'">
</div>
<div class="form-row form-group col-xl-12">
<input type="date" class="form-control" placeholder="Thời gian kí" name="tgianki" required value="'.$row['thoigianki'].'">
</div>
<div class="form-row col-xl-12">
<input type="date" class="form-control" placeholder="Thời giann kết thúc" name="tgiankt" required value="'.$row['thoigiankt'].'">
</div>
<br>
<div class="form-row form-group col-xl-12 text-center">
<input type="submit" value="Sửa hợp đồng" name="btnsuahd">
</div>
</form>
</div>
';
}
echo $output;
}
else
{
echo 'Nhập sai nhập lại';
}
}
?>