01.
<?
02.
$page
=
$_GET
[
'page'
];
03.
$num
= 1;
04.
$select_type
=
"select * from member where $_POST[searchtype] LIKE '%$_POST[txtsearch]%' order by id asc"
;
05.
$query_select
=mysql_query(
$select_type
);
06.
$num_rows
=mysql_num_rows(
$query_select
);
07.
08.
if
(
$num_rows
<1){
09.
echo
"<br><br><center><font color=#666666 face=tahoma size=2>ไม่พบข้อมูลทีี่ท่านค้นหาค่ะ</font></center>"
;
10.
}
else
{
11.
$select
=
"select * from member where $_POST[searchtype] LIKE '%$_POST[txtsearch]%' order by id asc"
;
12.
$q_ry
= mysql_query(
$select
);
13.
$num_rows
=mysql_num_rows(
$q_ry
);
14.
$pagesize
=10;
15.
$rt
=
$num_rows
%
$pagesize
;
16.
if
(
$rt
!=0)
17.
{
18.
$totalpage
=
floor
(
$num_rows
/
$pagesize
)+1;
19.
}
20.
else
21.
{
22.
$totalpage
=
floor
(
$num_rows
/
$pagesize
);
23.
$toppic_id
=1;
24.
}
25.
if
(
empty
(
$page
))
26.
{
27.
$page
=1;
28.
}
29.
mysql_free_result(
$q_ry
);
30.
$goto
=(
$page
-1)*
$pagesize
;
31.
$sql_select_mem
=
"Select * from (select *, right(day_ordain,4) y, substring(day_ordain,4,2) m, left(day_ordain,2) d from member ) tb order by y, m, d limit $goto,$pagesize"
;
32.
$fect
=mysql_query(
$sql_select_mem
);
33.
if
(!
$fect
)
34.
{
35.
(
"ติดต่อฐานข้อมูลไม่ได้"
.mysql_error());
36.
exit
;
37.
}
38.
39.
$bgcount
=0;
40.
while
(
$rows
=mysql_fetch_array(
$fect
))
41.
{
42.
$status_name
=
$rows
[
'status_name'
];
43.
$name_th
=
$rows
[
'name_th'
];
44.
$n_name_th
=
$rows
[
'n_name_th'
];
45.
$last_name_th
=
$rows
[
'last_name_th'
];
46.
$rainy
=
$rows
[
'rainy'
];
47.
$wantstudy_name
=
$rows
[
'wantstudy_name'
];
48.
$room
=
$rows
[
'room'
];
49.
$phone
=
$rows
[
'phone'
];
50.
51.
?>
52.
<tbody>
53.
<tr>
54.
55.
<td><?
echo
"$status_name "
; ?></td>
56.
<td><?
echo
"$name_th "
; ?></td>
57.
<td><?
echo
"$n_name_th"
; ?></td>
58.
<td><?
echo
"$last_name_th"
; ?></td>
59.
<td><?
echo
"$rainy"
; ?></td>
60.
<td><?
echo
"$wantstudy_name"
; ?></td>
61.
<td><?
echo
"$room"
; ?></td>
62.
<td><?
echo
"$phone"
; ?></td>
63.
<td><a href=detail.php?id=<?
echo
"$idmember"
; ?>><span
class
=
"glyphicon glyphicon-pencil"
></span></a></td>
64.
65.
<td><a href=edit.php?id=<?
echo
"$idmember"
; ?>><span
class
=
"glyphicon glyphicon-pencil"
></span></a></td>
66.
67.
68.
<?
69.
$num
=
$num
+1;
70.
}
71.
echo
"
72.
</tbody>
73.
</table>
74.
75.
<div align=center>
76.
<ul
class
=\
"pagination pagination-lg\"> "
;
77.
for
(
$i
=1;
$i
<
$page
;
$i
++)
78.
{
79.
echo
"<li><a href='$PHP_SELF?page=$i'>$i</a></li>"
;
80.
}
81.
echo
"<li class=\"active\"><a href=\"javascritp:;\">$page <span class=\"sr-only\">(current)</span></a></li> "
;
82.
for
(
$i
=
$page
+1;
$i
<=
$totalpage
;
$i
++)
83.
{
84.
echo
"<li><a href='$PHP_SELF?page=$i'>$i</a></li>"
;
85.
}
86.
echo
"</ul> </div>"
;
87.
}
88.
?>