<?php require_once '../../_config/DbConfig.php'; $dbconfig = new DbConfig(); $financeConn = $dbconfig->ConnFinance(); session_start(); $username = $_POST['username']; $password = $_POST['password']; $sql = "SELECT * FROM FINANCE_USER WHERE FINANCE_USER_NAME = '{$username}' AND FINANCE_USER_PASS = '******'"; $s = oci_parse($financeConn, $sql); oci_execute($s); $r = oci_fetch_array($s, OCI_ASSOC); if ($r) { echo "SUKSES"; $_SESSION['user_finance'] = $username; $_SESSION['user_finance_role'] = $r['FINANCE_USER_ROLE']; $_SESSION['user_finance_id'] = $r['FINANCE_USER_ID']; } else { echo "GAGAL"; }
//define("ORA_CON_DB", "192.168.100.71/WENFINANCE"); //$conn = oci_connect(ORA_CON_UN, ORA_CON_PW, ORA_CON_DB); /* $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]; */ require_once 'DbConfig.php'; session_start(); $dbconfig = new DbConfig(); $conn_finance = $dbconfig->ConnFinance(); $conn_logistic = $dbconfig->ConnWenloginv(); $conn_weltes = $dbconfig->ConnWeltes(); if (!isset($_SESSION['user_finance'])) { echo <<<EOD <h1>You are UNAUTHORIZED !</h1> <p>INVALID usernames/passwords<p> <p><a href="/weltesfinance/">LOGIN PAGE</a></p> EOD; exit; } $username = $_SESSION['user_finance']; $user_role = $_SESSION['user_finance_role']; $user_id = $_SESSION['user_finance_id'];