Why can't display?
405030Sep 27 2003 — edited Sep 28 2003My code is
<?php
print "<HTML><PRE>";
$db = "(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)))(CONNECT_DATA=(SID=orcl)))";
$c1 = ocilogon("RASAMEE ","database",$db);
function select_data($conn) {
$stmt = ociparse($conn,"select * from leader");
ociexecute($stmt,OCI_DEFAULT);
echo $conn." <----selecting\n";
echo "-----------------------\n";
while (ocifetch($stmt)){
echo ociresult($stmt,"name")." ";
echo ociresult($stmt,"surname")." ";
echo "hi";
echo ociresult($stmt,"tel")."\n";
}
echo $conn." <----done\n\n";
}
select_data($c1);
ocilogoff($c1);
print "</PRE></HTML>";
?>
I had created leader table with have 4 records (4 name,4surname,4tel)
but the result has shown
"
Resource id #4 <----selecting
-----------------------
hi
hi
hi
hi
Resource id #4 <----done
"
that's I don't know why...............
why I can't use function ociresult ?
could someone answer me,please?
Thank lots!