-
Notifications
You must be signed in to change notification settings - Fork 0
/
index.php
72 lines (68 loc) · 3.92 KB
/
index.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
<!DOCTYPE html>
<html lang="en">
<head>
<title>العمال</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="css/bootstrap.min.css">
<link rel="stylesheet" href="css/bootstrap-rtl.min.css">
</head>
<body>
<a href="<?php echo $_SERVER["REQUEST_URI"];?>">Refresh</a>
<?php
include('connectdb.php');
$query = "SELECT * FROM employees";
$result = $db->query($query);
?>
<div class="container">
<div class="media-index">
<h1>العمال</h1>
<p>
<a class="btn btn-success" href="create.php">اضافة عامل جديد</a>
</p>
<p></p>
<table class="table table-striped table-bordered">
<thead>
<tr>
<th>#</th>
<th><a href="/sample/basic/web/employees/index?sort=id" data-sort="id">ID</a></th>
<th><a href="/sample/basic/web/employees/index?sort=residency_number" data-sort="residency_number">رقم الاقامة</a></th>
<th><a href="/sample/basic/web/employees/index?sort=name" data-sort="name">الاسم</a></th>
<th><a href="/sample/basic/web/employees/index?sort=residence_release_date" data-sort="residence_release_date">تاريخ اصدار الاقامة</a></th>
<th><a href="/sample/basic/web/employees/index?sort=residence_expiration_date" data-sort="residence_expiration_date">تاريخ انتهاء الاقامة</a></th>
<?php /*?><th class="action-column"> </th><?php */?>
</tr>
<tr id="w0-filters" class="filters">
<td> </td>
<td><input type="text" class="form-control" name="EmployeesSearch[id]"></td>
<td><input type="text" class="form-control" name="EmployeesSearch[name]"></td>
<td><input type="text" class="form-control" name="EmployeesSearch[residency_number]"></td>
<td><input type="text" class="form-control" name="EmployeesSearch[residence_release_date]"></td>
<td><input type="text" class="form-control" name="EmployeesSearch[residence_expiration_date]"></td>
<?php /*?><td> </td><?php */?>
</tr>
</thead>
<tbody>
<?php $i = 1; while($row = $result->fetchArray()){?>
<tr data-key="<?=$row['id']?>">
<td><?=$i;?></td>
<td><?=$row['id']?></td>
<td><?=$row['residency_number']?></td>
<td><?=$row['name']?></td>
<td><?=$row['residence_release_date']?></td>
<td><?=$row['residence_expiration_date']?></td>
<?php /*?><td>
<a href="/sample/basic/web/employees/view?id=3" title="View" aria-label="View" data-pjax="0"><span class="glyphicon glyphicon-eye-open"></span></a>
<a href="/sample/basic/web/employees/update?id=3" title="Update" aria-label="Update" data-pjax="0"><span class="glyphicon glyphicon-pencil"></span></a>
<a href="/sample/basic/web/employees/delete?id=3" title="Delete" aria-label="Delete" data-pjax="0" data-confirm="Are you sure you want to delete this item?" data-method="post"><span class="glyphicon glyphicon-trash"></span></a>
</td><?php */?>
</tr>
<?php $i++;} ?>
</tbody>
</table>
</div>
</div>
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.min.js"></script>
</body>
</html>