PHP oci_set_client_identifier函数代码示例

 /**
  * Constructor opens a connection to the database
  * @param string $module Module text for End-to-End Application Tracing
  * @param string $cid Client Identifier for End-to-End Application Tracing
  */
 function __construct($module, $cid)
 {
     $this->conn = @oci_pconnect(SCHEMA, PASSWORD, DATABASE, CHARSET);
     if (!$this->conn) {
         $m = oci_error();
         throw new \Exception('No se puede conectar a la base de datos: ' . $m['message']);
     }
     // Record the "name" of the web user, the client info and the module.
     // These are used for end-to-end tracing in the DB.
     oci_set_client_info($this->conn, CLIENT_INFO);
     oci_set_module_name($this->conn, $module);
     oci_set_client_identifier($this->conn, $cid);
 }

 /**
  * Constructor opens a connection to the database
  * @param string $module Module text for End-to-End Application Tracing
  * @param string $cid Client Identifier for End-to-End Application Tracing
  * @throws \Exception
  */
 public function __construct($module, $cid)
 {
     $this->conn = @oci_new_connect(O_USERNAME, O_PASSWORD, O_DATABASE, O_CHARSET);
     if (!$this->conn) {
         $m = oci_error();
         throw new \Exception("Cannot open connection to Oracle db " . $m["message"]);
     }
     // Record the "name" of the web user, the client info and the module.
     // These are used for end-to-end tracing in the DB.
     oci_set_client_info($this->conn, CLIENT_INFO);
     oci_set_module_name($this->conn, $module);
     oci_set_client_identifier($this->conn, $cid);
 }

<?php

require_once '../../_config/dbinfo.inc.php';
require_once '../../_config/misc.func.php';
require_once '../../_config/hash.pwd.php';
session_start();
$conn = oci_connect(ORA_CON_UN, ORA_CON_PW, ORA_CON_DB) or die;
$pass = $_POST['password'];
$username = $_POST['username'];
oci_set_client_identifier($conn, 'admin');
$sql = oci_parse($conn, "SELECT WMU.MART_PASS HASHPASS,\r\n                            WMU.MART_FULL_NAME FULLNAME,\r\n                            WMR.MART_ROLE_DESC COMP_ROLE_COMPLETE\r\n                       FROM MART_USER WMU\r\n                            INNER JOIN MART_ROLE WMR\r\n                               ON WMR.MART_ROLE_ID = WMU.MART_ROLE_ID\r\n                      WHERE WMU.MART_FULL_NAME = :finemail");
oci_bind_by_name($sql, ":finemail", $username);
oci_define_by_name($sql, "COMP_ROLE_COMPLETE", $role);
oci_define_by_name($sql, "HASHPASS", $hashpass);
oci_execute($sql);
$r = oci_fetch_array($sql, OCI_ASSOC);
$passMatchInt = validate_password($pass, $hashpass);
if ($passMatchInt == 1) {
    $_SESSION['userlogin'] = $username;
    $_SESSION['rolelogin'] = $role;
    echo '<script>location.href="../main.php"</script>';
} else {
    echo '<script>alert("LOGIN FAILED !!! \\nPLEASE ENTER APPROPRIATE USER NAME AND PASSWORD")</script>';
    echo '<script>location.href="../../index.php"</script>';
}
$globalName = SingleQryFld("SELECT WMS.SETTING_VALUE_STRING FROM MART_SETTINGS WMS WHERE WMS.SETTING_DESC = 'GLOBAL_NAME'", $conn);
$_SESSION['globalname'] = $globalName;

session_start();
// CHECK IF THE USER IS LOGGED ON ACCORDING
// TO THE APPLICATION AUTHENTICATION
if (!isset($_SESSION['username'])) {
    echo <<<EOD
       <h1>You are UNAUTHORIZED !</h1>
       <p>INVALID usernames/passwords<p>
       <p><a href="/WeltesinformationCenter/index.html">LOGIN PAGE</a><p>
EOD;
    exit;
}
// GENERATE THE APPLICATION PAGE
$conn = oci_pconnect(ORA_CON_UN, ORA_CON_PW, ORA_CON_DB);
// 1. SET THE CLIENT IDENTIFIER AFTER EVERY CALL
// 2. USING UNIQUE VALUE FOR BACK END USER
oci_set_client_identifier($conn, $_SESSION['username']);
$username = htmlentities($_SESSION['username'], ENT_QUOTES);
function hitungProsentase($onsite, $preparation, $erection, $qc)
{
    $presentaseOnsite = $onsite / 100 * 5;
    $prsentasePreparation = $preparation / 100 * 5;
    $prsentaseErection = $erection / 100 * 85;
    $presentaseQc = $qc / 100 * 5;
    $result = $presentaseOnsite + $prsentasePreparation + $prsentaseErection + $presentaseQc;
    return $result;
}
function totalWeightErection($onsite, $prep, $erec, $qc)
{
    $w_onsite = $onsite * 5 / 100;
    $w_prep = $prep * 5 / 100;
    $w_erect = $erec * 85 / 100;

 public function SetClientID(string $client_id)
 {
     return @oci_set_client_identifier($this->conn_handle, $client_id);
 }

 /**
  * Utiliza o recurso do Oracle que permite vincular informações do usuário da aplicação à sua sessão no banco de dados.
  * @param type $userId
  * @param type $userIP
  * @param type $module
  * @param type $action
  */
 public function setUserInformation($userId, $userIP = null, $module = null, $action = null)
 {
     oci_set_client_identifier($this->dbh, $userId);
     if ($userIP) {
         oci_set_client_info($this->dbh, $userIP);
     }
     if ($module) {
         oci_set_module_name($this->dbh, $module);
     }
     if ($action) {
         oci_set_action($this->dbh, $action);
     }
 }

define("ORA_CON_DB2", "192.168.100.68/WENLOGINV");
$conn_wenloginv = oci_connect(ORA_CON_UN, ORA_CON_PW, ORA_CON_DB2) or die;
// koneksi ke wenmart
define("ORA_CON_DB", "192.168.100.71/WENMART");
$conn = oci_connect(ORA_CON_UN, ORA_CON_PW, ORA_CON_DB) or die;
/* $con = oci_connect(ORA_CON_UN, ORA_CON_PW, ORA_CON_DB);
  if($con)
  echo 'success';
  else
  echo 'fail';

  $sql = "select count(inv_desc) from MASTER_INV where inv_desc = 'MIKO H'";
  $r = oci_parse($con, $sql);
  oci_execute($r);
  $row = oci_fetch_array($r);
  echo $row[0]; */
session_start();
if (!isset($_SESSION['userlogin'])) {
    echo <<<EOD
   <h1>You are UNAUTHORIZED !</h1>
   <p>INVALID usernames/passwords<p>
   <p><a href="/WeltesMart/_includes/login/login_view.php">LOGIN PAGE</a></p>

EOD;
    exit;
}
// 1. SET THE CLIENT IDENTIFIER AFTER EVERY CALL
// 2. USING UNIQUE VALUE FOR BACK END USER
oci_set_client_identifier($conn, $_SESSION['userlogin']);
$username = htmlentities($_SESSION['userlogin'], ENT_QUOTES);
$user_role = $_SESSION['rolelogin'];

 public function actionLogon()
 {
     if ($_GET != '') {
         Yii::app()->oracle->sessStart();
         $_SESSION['session'] = session_id();
         $conn = Yii::app()->oracle_auth->getOracleAuthConnection();
         $dataset = $_GET['dataset_id'];
         $complex = $_GET['complex_id'];
         $user_id = $_GET['user_id'];
         $s = oci_parse($conn, "begin :p1:=ini.BSFT_LOGON(:p_ds, :p_cmp, :p_user, :p_sid); end;");
         oci_bind_by_name($s, ":p1", $client_sess_id, 16, SQLT_CHR);
         oci_bind_by_name($s, ":p_ds", $dataset, -1, SQLT_CHR);
         oci_bind_by_name($s, ":p_cmp", $complex, -1, SQLT_CHR);
         oci_bind_by_name($s, ":p_user", $user_id, -1, SQLT_CHR);
         oci_bind_by_name($s, ":p_sid", $_SESSION['session'], -1, SQLT_CHR);
         oci_execute($s);
         //ini_set('session.cookie_lifetime', 60*60*24);
         //setcookie('PHPSESSID', session_id(), time()+86400);
         //session_start();
         //Yii::app()->oracle->sessStart();
         //$conn = Yii::app()->oracle_auth->getOracleAuthConnection();
         if ($client_sess_id != '') {
             $_SESSION['session'] = session_id();
             $_SESSION['username'] = $_GET['username'];
             $_SESSION['user_id'] = $user_id;
             $_SESSION['dataset'] = $dataset;
             $_SESSION['complex'] = $complex;
             $_SESSION['client_session_id'] = $client_sess_id;
             $offset = 4;
             $time = time();
             $time += $offset * 3600;
             $_SESSION['activity'] = $time;
             oci_set_client_identifier($conn, $_SESSION['user_id']);
             //$GLOBALS['session_id'];
         }
     }
 }

<?php 
require_once '../../../_config/dbinfo.inc.php';
require_once '../../../_config/hash.pwd.php';
session_start();
$email = $_POST['email'];
$pass = $_POST['password'];
oci_set_client_identifier($conn_finance, 'admin');
$sql = oci_parse($conn_finance, 'SELECT WFU.FINANCE_PASS HASHPASS, WFU.FINANCE_ROLE_ID COMP_ROLE, WFU.FINANCE_FULL_NAME FULLNAME FROM WEN_FINANCE_USER WFU WHERE WFU.FINANCE_EMAIL = :finemail');
oci_bind_by_name($sql, ":finemail", $email);
oci_define_by_name($sql, "COMP_ROLE", $role);
oci_define_by_name($sql, "HASHPASS", $hashpass);
oci_define_by_name($sql, "FULLNAME", $username);
oci_execute($sql);
$r = oci_fetch_array($sql, OCI_ASSOC);
$passMatchInt = validate_password($pass, $hashpass);
if ($passMatchInt == 1) {
    $_SESSION['username'] = $username;
    $_SESSION['role'] = $role;
    echo '<script>location.href="../../main.php"</script>';
} else {
    echo '<script>alert("LOGIN FAILED !!! \\nPLEASE ENTER APPROPRIATE USER NAME AND PASSWORD")</script>';
    echo '<script>location.href="../../login.php"</script>';
}

 public function setClientIdentifier($clientIdentifier)
 {
     set_error_handler(static::getErrorHandler());
     $isSuccess = oci_set_client_identifier($this->resource, $clientIdentifier);
     restore_error_handler();
     return $isSuccess;
 }