01.
<html>
02.
<head>
03.
<title>ThaiCreate.Com Tutorial</title>
04.
</head>
05.
<body>
06.
<?php
07.
$objConnect
= oci_connect(
"myuser"
,
"mypassword"
,
"TCDB"
);
08.
$strSQL
=
"SELECT * FROM GALLERY"
;
09.
$objParse
= oci_parse(
$objConnect
,
$strSQL
);
10.
oci_execute (
$objParse
,OCI_DEFAULT);
11.
echo
"<table border=\"1\" cellspacing=\"1\" cellpadding=\"1\"><tr>"
;
12.
$intRows
= 0;
13.
while
(
$objResult
= oci_fetch_array(
$objParse
,OCI_BOTH))
14.
{
15.
echo
"<td>"
;
16.
$intRows
++;
17.
?>
18.
<center>
19.
<img src=
"thaicreate/<?php echo $objResult["
PICTURE
"];?>"
><br>
20.
<?php
echo
$objResult
[
"GALLERYNAME"
];?>
21.
<br>
22.
</center>
23.
<?php
24.
echo
"</td>"
;
25.
if
((
$intRows
)%2==0)
26.
{
27.
echo
"</tr>"
;
28.
}
29.
}
30.
echo
"</tr></table>"
;
31.
?>
32.
</body>
33.
</html>
34.
<?php
35.
oci_close(
$objConnect
);
36.
?>