header("Expires: Mon, 25 Jan 1999 05:00:00 GMT"); // Date in the past header("Last-Modified: ".gmdate("D, d M Y H:i:s")."GMT"); // modified header("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1 header("Pragma: no-cache"); // HTTP/1.0 if ($TWO_TASK) $SID = $TWO_TASK; // Oracle is running on a remote machine else $SID = $ORACLE_SID; // Oracle is running on this machine // Authenticate user, default Oracle username/password : system/manager ?> Who is using Oracle Who is using Oracle?
Server: ".$SID; echo date("H:i:s, Y-m-d", time() )."
"; echo "User name: ".$PHP_AUTH_USER; echo "\n"; exit(0); // connect, default Oracle username/password: system/manager // To use another SID, enter user name as: "system@ORCL" $conn = @OCILogon("system", "manager", $ORACLE_SID); if (!$conn) { echo "

Error: Unable to connect to Oracle

\n"; } else { // prepare $sql = "SELECT osuser,machine,program FROM v\$session ORDER BY osuser, machine"; $stmt = @OCIParse($conn, $sql); // execute sql statement if (@OCIExecute($stmt)) { $numcols = @OCINumCols($stmt); // fetch echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; # while (@OCIFetchInto($stmt, &$result, OCI_ASSOC)) { # echo "\n"; # } echo "

".@OCIServerVersion($conn)."
".@OCIColumnname($stmt,1)." ".OCIColumnType($stmt,1)."	".@OCIColumnname($stmt,2)." ".OCIColumnType($stmt,2)."	".@OCIColumnname($stmt,3)." ".OCIColumnType($stmt,3)."
"; # echo $result['OSUSER']; # echo "	"; # echo $result['MACHINE']; # echo "	"; # echo $result['PROGRAM']; # echo "

\n"; echo "

\n"; } @OCIFreeStatement($stmt); @OCILogoff($conn); } // Display source file if exists if (file_exists($fn = basename($PHP_SELF."s") )) echo "Source file: $fn\n"; else echo "Source is not available\n"; ?>