here it is;;;;
<HTML>
<BODY>
<?php
$username=$POST[user];
$password=$POST[pass];
$db="(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = RICHARD-2J7P3XV)(PORT = 1521)))(CONNECT_DATA=(SID=test)))";
$c1=ocilogon("ADAMS","password",$db);
$query="select * from sys.richie";
if("USERNAME"=='$username'&&"PASSWORD"=='$password'){
$stmt=ociparse($c1,$query);
ociexecute($stmt);
while (ocifetch($stmt)){
echo ociresult($stmt,"NAME")."<BR>\n";
}
}else{echo "<a href="loginfail.htm">";
}
ocilogoff($c1);
?>
</HTML>