01.
<?php
02.
include
"student_db.php"
;
03.
?>
04.
<html>
05.
<head>
06.
<title> หน้าแสดงข้อมูล user</title>
07.
</head>
08.
<body>
09.
<table bordercolor=red border=
"1"
>
10.
<tr>
11.
12.
<th>ชื่อ-นามสกุล</th>
13.
<th>เบอร์โทร</th>
14.
<th>ที่อยู่</th>
15.
</tr>
16.
17.
<?php
18.
$sql
=
"SELECT * FROM user_tb LIMIT 8"
;
19.
$result
=
$conn
->query(
$sql
);
20.
if
(mysqli_num_rows(
$result
)>0){
21.
$i
=1;
22.
while
(
$row
=mysqli_fetch_array(
$result
)){
23.
?>
24.
<tr>
25.
26.
<td> <?=
$row
[
'name_stu'
];?> </td>
27.
<td> <?=
$row
[
'tel_stu'
];?> </td>
28.
<td> <?=
$row
[
'add_stu'
];?> </td>
29.
</tr>
30.
31.
<?php
32.
$i
++;
33.
}
34.
}
35.
36.
?>
37.
38.
39.
40.
<?php
41.
$sql
=
"SELECT * FROM user_tb LIMIT 8,8"
;
42.
$result
=
$conn
->query(
$sql
);
43.
if
(mysqli_num_rows(
$result
)>0){
44.
$i
=1;
45.
while
(
$row
=mysqli_fetch_array(
$result
)){
46.
?>
47.
<tr>
48.
49.
<td> <?=
$row
[
'name_stu'
];?> </td>
50.
<td> <?=
$row
[
'tel_stu'
];?> </td>
51.
<td> <?=
$row
[
'add_stu'
];?> </td>
52.
</tr>
53.
54.
<?php
55.
$i
++;
56.
}
57.
}
58.
59.
?>
60.
61.
62.
63.
64.
<?php
65.
$sql
=
"SELECT * FROM user_tb LIMIT 16,8"
;
66.
$result
=
$conn
->query(
$sql
);
67.
if
(mysqli_num_rows(
$result
)>0){
68.
$i
=1;
69.
while
(
$row
=mysqli_fetch_array(
$result
)){
70.
?>
71.
<tr>
72.
73.
<td> <?=
$row
[
'name_stu'
];?> </td>
74.
<td> <?=
$row
[
'tel_stu'
];?> </td>
75.
<td> <?=
$row
[
'add_stu'
];?> </td>
76.
</tr>
77.
78.
<?php
79.
$i
++;
80.
}
81.
}
82.
83.
?>
84.
85.
</table>
86.
87.
88.
</body>
89.
</html><img src=
"/images/bbcode/erm.gif?v=1001"
align=
"absmiddle"
>