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