01.
<meta http-equiv=Content-Type content=
"text/html; charset=utf-8"
>
02.
<?
03.
require
(
"config.php"
);
04.
$conn
= mysql_connect(
$dbhost
,
$dbuser
,
$dbpass
);
05.
06.
if
( !
$conn
)
07.
die
(
"ไม่สามารถติดต่อกับ MySQL ได้"
);
08.
mysql_query(
"SET NAMES UTF8"
);
09.
mysql_select_db (
$dbname
,
$conn
)
10.
or
die
(
"ไม่สามารถเลือกฐานข้อมูลได้"
);
11.
12.
$sqltopic
=
"SELECT * FROM ckforms_1"
;
13.
$sqlforms
=
"SELECT * FROM ckforms_1"
;
14.
$sqlfields
=
"SELECT * FROM ckfields"
;
15.
16.
$retopic
= mysql_query (
$sqltopic
,
$conn
);
17.
$reforms
= mysql_query (
$sqlforms
,
$conn
);
18.
$refields
= mysql_query (
$sqlfields
,
$conn
);
19.
20.
21.
22.
23.
$count
=mysql_num_rows(
$reforms
);
24.
?>
25.
26.
<table border=
"1"
>
27.
ชื่อเอกสาร
28.
<?
29.
while
(
$rf
= mysql_fetch_array (
$retopic
) )
30.
{
31.
echo
"<tr><td><a herf=''>$rf[F2]</a></td></tr>"
;
32.
}
33.
?>
34.
</table>
35.
<hr>
36.
<table border=
"1"
>
37.
<?
38.
while
(
$rfd
= mysql_fetch_array (
$refields
) )
39.
{
40.
echo
"<tr>
41.
<td>
$rfd
[label]</td>
42.
</tr>";
43.
}
44.
?>
45.
</table>
46.
<br>
47.
<table border=
"1"
>
48.
<?
49.
50.
$a
=1;
51.
while
(
$a
<=
$count
)
52.
{
53.
$rec
= mysql_fetch_array(
$reforms
);
54.
55.
$code
=
$rec
[
"F$a"
];
56.
echo
"<tr><td>
$code
</td>
57.
</tr>";
58.
$a
++;
59.
}
60.
?>
61.
</table>
62.
<?
63.
mysql_close (
$conn
);
64.
?>