001.
<style>
002.
* {
003.
margin: 0;
004.
padding: 0;
005.
box-sizing: 0;
006.
}
007.
008.
body {
009.
font-size: 13px;
010.
font-family: Arial, Helvetica, sans-serif;
011.
background-color: #F2F3F4;
012.
color: #273746;
013.
}
014.
015.
.container {
016.
margin: 5px auto;
017.
padding: 0;
018.
width: 90%;
019.
020.
}
021.
022.
table {
023.
width: 100%;
024.
025.
border-collapse: collapse;
026.
}
027.
028.
table,
029.
td {
030.
border: 1px solid #BEBEBE;
031.
text-align: center;
032.
}
033.
034.
thead {
035.
background-color: #0099CC;
036.
color: #000000;
037.
}
038.
039.
040.
tr:nth-child(even) {
041.
background-color: #D3D3D3;
042.
}
043.
044.
h2 {
045.
font-size: 10px;
046.
height: 27px;
047.
vertical-align: center;
048.
}
049.
050.
051.
td {
052.
font-size: 15px;
053.
height: 27px;
054.
vertical-align: center;
055.
}
056.
057.
.name {
058.
font-size: 14px;
059.
text-align: left;
060.
padding-left: 16px;
061.
}
062.
<?php
063.
include
(
'db_connect.php'
);
064.
065.
$query
=mysqli_query(
$con
,
"SELECT * FROM tb_borrow ORDER BY id DESC"
);
066.
$row
= mysqli_fetch_row(
$query
);
067.
$rows
=
$row
[0];
068.
$page_rows
= 8;
069.
$last
=
ceil
(
$rows
/
$page_rows
);
070.
071.
if
(
$last
< 1){
072.
$last
= 1;
073.
}
074.
075.
$pagenum
= 1;
076.
077.
if
(isset(
$_GET
[
'pn'
])){
078.
$pagenum
= preg_replace(
'#[^0-9]#'
,
''
,
$_GET
[
'pn'
]);
079.
}
080.
081.
if
(
$pagenum
< 1) {
082.
$pagenum
= 1;
083.
}
084.
else
if
(
$pagenum
>
$last
) {
085.
$pagenum
=
$last
;
086.
}
087.
088.
$limit
=
'LIMIT '
.(
$pagenum
- 1) *
$page_rows
.
','
.
$page_rows
;
089.
$nquery
=mysqli_query(
$con
,
"SELECT * from tb_borrow where idcard like '%"
.
$strKeyword
.
"%' ORDER BY id DESC $limit "
);
090.
$paginationCtrls
=
''
;
091.
092.
if
(
$last
!= 1){
093.
094.
if
(
$pagenum
> 1) {
095.
$previous
=
$pagenum
- 1;
096.
$paginationCtrls
.=
'<a href="'
.
$_SERVER
[
'PHP_SELF'
].
'?pn='
.
$previous
.
'" class="btn btn-info">Previous</a> '
;
097.
098.
for
(
$i
=
$pagenum
-4;
$i
<
$pagenum
;
$i
++){
099.
if
(
$i
> 0){
100.
$paginationCtrls
.=
'<a href="'
.
$_SERVER
[
'PHP_SELF'
].
'?pn='
.
$i
.
'" class="btn btn-primary">'
.
$i
.
'</a> '
;
101.
}
102.
}
103.
}
104.
105.
$paginationCtrls
.=
''
.
$pagenum
.
' '
;
106.
107.
for
(
$i
=
$pagenum
+1;
$i
<=
$last
;
$i
++){
108.
$paginationCtrls
.=
'<a href="'
.
$_SERVER
[
'PHP_SELF'
].
'?pn='
.
$i
.
'" class="btn btn-primary">'
.
$i
.
'</a> '
;
109.
if
(
$i
>=
$pagenum
+4){
110.
break
;
111.
}
112.
}
113.
114.
if
(
$pagenum
!=
$last
) {
115.
$next
=
$pagenum
+ 1;
116.
$paginationCtrls
.=
' <a href="'
.
$_SERVER
[
'PHP_SELF'
].
'?pn='
.
$next
.
'" class="btn btn-info">Next</a> '
;
117.
}
118.
}
119.
?>
120.
121.
</style>
122.
<!DOCTYPE html>
123.
<html lang=
"en"
>
124.
<head>
125.
<meta charset=
"UTF-8"
>
126.
<meta name=
"viewport"
content=
"width=device-width, initial-scale=1.0"
>
127.
<title>สรุปข้อมูลอุปกรณ์</title>
128.
<link rel=
"stylesheet"
href=
"style.css"
>
131.
</head>
132.
<body>
133.
<div
class
=
"container"
>
134.
<?php
135.
ini_set
(
'display_errors'
, 1);
136.
error_reporting
(~0);
137.
138.
$strKeyword
= null;
139.
140.
if
(isset(
$_POST
[
"txtKeyword"
]))
141.
{
142.
$strKeyword
=
$_POST
[
"txtKeyword"
];
143.
}
144.
145.
146.
147.
?>
148.
<form name=
"frmSearch"
method=
"post"
action=
"<?php echo $_SERVER['SCRIPT_NAME'];?>"
>
149.
รายงานระบบการยืมคืนอุปกรณ์<input name=
"txtKeyword"
type=
"text"
id=
"txtKeyword"
value=
"<?php echo $strKeyword;?>"
>
150.
<input type=
"submit"
value=
"Search"
></th>
151.
</form>
152.
<table>
153.
<thead>
154.
<tr>
155.
<td width=
"1.5%"
>#</td>
156.
<td width=
"11%"
>วันที่ยืม</td>
157.
<td width=
"11%"
>วันที่คืน</td>
158.
<td width=
"7%"
>IDCARD</td>
159.
<td width=
"11%"
>ชื่อนามสกุล</td>
160.
<td width=
"10%"
>ส่วนงาน</td>
161.
<td width=
"6%"
>เลขอุปกรณ์</td>
162.
<td width=
"4%"
>สถานะ</td>
163.
<td width=
"5%"
>สภาพ</td>
164.
<td width=
"11%"
>หมายเหตุ</td>
165.
<td width=
"4%"
>รูปภาพ</td>
166.
</tr>
167.
</thead>
168.
<tbody>
169.
<?php
170.
while
(
$row
= mysqli_fetch_array(
$nquery
)){
171.
?>
172.
<tr>
173.
<td><?php
echo
$row
[
'id'
]; ?></td>
174.
<td><?php
echo
$row
[
'time'
]; ?></td>
175.
<td><?php
echo
$row
[
'time2'
]; ?></td>
176.
<td><?php
echo
$row
[
'idcard'
]; ?></td>
177.
<td><?php
echo
$row
[
'username'
]; ?></td>
178.
<td><?php
echo
$row
[
'section'
]; ?></td>
179.
<td><?php
echo
$row
[
'serial'
]; ?></td>
180.
<td><?php
echo
$row
[
'updatestatus'
]; ?></td>
181.
<td><?php
echo
$row
[
'status'
]; ?></td>
182.
<td><?php
echo
$row
[
'comment'
]; ?></td>
183.
<td><img src=
"./images/<?=$row['fileupload']?>"
width=
'50'
height=
'42'
></td>
184.
185.
</tr>
186.
<?php
187.
}
188.
?>
189.
</table><br>
190.
<div id=
"pagination_controls"
><?php
echo
$paginationCtrls
; ?></div>
191.
</div>
192.
193.
</body>
194.
</html>