|
<?php
print
"<HTML><PRE>";
$db
= "(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST
= fuju.exzilla.net)(PORT = 1521)))(CONNECT_DATA=(SID=fuju)))";
$c1
= ocilogon("scott","tiger",$db);
function
select_data($conn) {
$stmt
= ociparse($conn,"select * from scott.emp");
ociexecute($stmt,OCI_DEFAULT);
echo
$conn." <----selecting\n";
echo "-----------------------\n";
while
(ocifetch($stmt)){
echo
ociresult($stmt,"EMPNO")." ";
echo ociresult($stmt,"HIREDATE")."
";
echo ociresult($stmt,"ENAME")."\n";
}
echo
$conn." <----done\n\n";
}
select_data($c1);
ocilogoff($c1);
print
"</PRE></HTML>";
?>
|