?php
print
"
HTML
PRE
\n"
;
$conn
=
ociLogon("scott"
,
"tiger")
;
$stmt
=
ociparse($conn
,"select
*
from
emp")
;
ociexecute($stmt)
;
print
"
TABLE
BORDER=\"1\
"
"
;
print
"
TR
"
;
print
"
TH
Name
/
TH
"
;
print
"
TH
Type
/
TH
"
;
print
"
TH
Length
/
TH
"
;
print
"
/
TR
"
;
$ncols
=
ociNumCols($stmt)
;
for
(
$i
=
1
;
$i
=
$ncols
;
$i+
+
)
{
$column_name
=
ociColumnName($stmt,$i)
;
$column_type
=
ociColumnType($stmt,$i)
;
$column_size
=
ociColumnSize($stmt,$i)
;
print
"
TR
"
;
print
"
TD
$column_name
/
TD
"
;
print
"
TD
$column_type
/
TD
"
;
print
"
TD
$column_size
/
TD
"
;
print
"
/
TR
"
;
}
ociFreeStatement($stmt)
;
ociLogoff($conn)
;
print
"
/
PRE
"
;
print
"
/
HTML
\n"
;
?
|