?php
print
"
HTML
PRE
\n"
;
$conn
=
ociLogon("scott"
,
"tiger")
;
$stmt
=
ociparse($conn
,"select
*
from
emp")
;
ociexecute($stmt)
;
while
(
ociFetch($stmt
)
)
{
print
"\n"
;
$ncols
=
ociNumCols($stmt)
;
for
(
$i
=
1
;
$i
=
$ncols
;
$i+
+
)
{
$column_name
=
ociColumnName($stmt,$i)
;
$column_value
=
ociResult($stmt,$i)
;
print
$column_name
.
'
:
'
.
$column_value
.
"\n"
;
}
print
"\n"
;
}
ociFreeStatement($stmt)
;
ociLogoff($conn)
;
print
"
/
PRE
"
;
print
"
/
HTML
\n"
;
?
|