01.
<html>
02.
<head>
03.
<title>ThaiCreate.Com Tutorial</title>
04.
</head>
05.
<body>
06.
<?php
07.
$objConnect
= mysql_connect(
"localhost"
,
"root"
,
"root"
)
or
die
(
"Error Connect to Database"
);
08.
$objDB
= mysql_select_db(
"mydatabase"
);
09.
$strSQL
=
"SELECT * FROM files"
;
10.
$objQuery
= mysql_query(
$strSQL
)
or
die
(
"Error Query ["
.
$strSQL
.
"]"
);
11.
?>
12.
<table width=
"200"
border=
"1"
>
13.
<tr>
14.
<th width=
"50"
> <div align=
"center"
>Files ID </div></th>
15.
<th width=
"150"
> <div align=
"center"
>Files Name </div></th>
16.
</tr>
17.
<?php
18.
while
(
$objResult
= mysql_fetch_array(
$objQuery
))
19.
{
20.
?>
21.
<tr>
22.
<td><div align=
"center"
><?php
echo
$objResult
[
"FilesID"
];?></div></td>
23.
<td><center><a href=
"myfile/<?php echo $objResult["
FilesName
"];?>"
><?php
echo
$objResult
[
"FilesName"
];?></a></center></td>
24.
</tr>
25.
<?php
26.
}
27.
?>
28.
</table>
29.
<?php
30.
mysql_close(
$objConnect
);
31.
?>
32.
</body>
33.
</html>