$c1 = ocilogon("XXXX","YYYY","CS4604");
$stmt = ociparse($c1,"select * from test");
$result = ociexecute($stmt,OCI_DEFAULT);
while(ocifetch($stmt))
    echo ociresult($stmt,1);

----------------------------------------------

<?php

// OCI (using Native Oracle API)
putenv("ORACLE_HOME=e:\oracle\ora81");
// (i) replace XXXX with your login (database)
// (ii) replace YYYY with your password (database)
$conn1 = OCILogon("XXXX","YYYY","CS4604");
{
	echo "Connected<br>";
	
	$stmt = OCIParse($conn1, "select * from test");
	$res = OCIExecute($stmt);
		
	while (OCIFetch($stmt))	
	{
		echo OCIResult($stmt, 1);
		echo "<br>";
	}
	echo "<br>";
}
	

?>