コード例 #1
0
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);
// HAK AKSES
$PAINT_ACCS = HakAksesUser($username, 'PAINT_ACCS', $conn);
if ($PAINT_ACCS != 1) {
    # code...
    echo <<<EOD
       <h1>You Can't ACCESS PAINTING PAGE !</h1>
       <p>Contact Your Admin Web to Allow Access<p>
       <p><a href="/weltesinformationcenter/login_fabrication.php">LOGIN PAGE</a><p>
EOD;
    exit;
}
$jobVal = strval($_POST['jobValue']);
?>

<?php 
$projectParse = oci_parse($conn, "SELECT DISTINCT PROJECT_NAME_NEW FROM VW_PROJ_INFO " . "WHERE PROJECT_NO = :PROJNO AND PROJECT_TYP = 'STRUCTURE' ORDER BY PROJECT_NAME_NEW");
oci_bind_by_name($projectParse, ":PROJNO", $jobVal);
コード例 #2
0
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);
// HAK AKSES
$DELIV_ACCS = HakAksesUser($username, 'DELIV_ACCS', $conn);
if ($DELIV_ACCS != 1) {
    # code...
    echo <<<EOD
       <h1>You Can't ACCESS DELIVERY PAGE !</h1>
       <p>Contact Your Admin Web to Allow Access<p>
       <p><a href="/weltesinformationcenter/login_fabrication.php">LOGIN PAGE</a><p>
EOD;
    exit;
}
?>


<!DOCTYPE html>
<html>
    <head>