/**
* Non-persistent database connection
*
* @access private called by the base class
* @return resource
*/
function db_connect()
{
// ====== Modificación por CRIE - UTP =======
// Se agrega el parámetro utf8 a la función ocilogon para
// forzar el uso de la codificación UTF-8 en Oracle
return @ocilogon($this->username, $this->password, $this->hostname, 'utf8');
// ========= Fin Modificación =========
}
function connect($h, $u, $p)
{
$this->DBHost = $h;
$this->DBUser = $u;
$this->DBPassword = $p;
$this->connection = ocilogon($this->DBUser, $this->DBPassword, $this->DBHost);
return $this->connection;
}
/**
* Constructor.
*
* @access public
*/
function phpOpenTracker_DB_oci8()
{
$this->phpOpenTracker_DB();
$database = $this->config['db_database'] == 'default' ? '' : $this->config['db_database'];
$this->connection = @ocilogon($this->config['db_user'], $this->config['db_password'], $database);
if (!$this->connection) {
return phpOpenTracker::handleError('Could not connect to database.', E_USER_ERROR);
}
}
/**
* Non-persistent database connection
*
* @access private called by the base class
* @return resource
*/
function db_connect()
{
// print_r("hostname ".$this->hostname);
// print_r("pooled ".$this->pooled);
// return @ocilogon($this->username, $this->password, $this->hostname);
$connection = ocilogon($this->username, $this->password, $this->pooled);
if (!$connection) {
$e = oci_error();
print_r("<b>Error In Connection:</b>" . $e['message']);
}
return @ocilogon($this->username, $this->password, $this->pooled);
}
function oracle_login($info, $serv_type)
{
$conn_str = '( DESCRIPTION =
( ADDRESS =
( PROTOCOL = TCP )
( HOST = ' . $info["HOST"] . ')
( PORT = ' . $info["PORT"] . ') )
( CONNECT_DATA =
( SERVICE_NAME = ' . $info["BASE"] . ')
( SERVER = ' . $serv_type . ') ) )';
$c = @ocilogon($info["USER"], $info["PASS"], $conn_str);
return $c;
}
function da_sql_connect($config)
{
if ($config[sql_use_http_credentials] == 'yes') {
global $HTTP_SERVER_VARS;
$SQL_user = $HTTP_SERVER_VARS["PHP_AUTH_USER"];
$SQL_passwd = $HTTP_SERVER_VARS["PHP_AUTH_PW"];
} else {
$SQL_user = $config[sql_username];
$SQL_passwd = $config[sql_password];
}
$link = @ocilogon($SQL_user, $SQL_passwd, $config[sql_database]);
$res = @da_sql_query($link, $config, "ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT='YYYY-MM-DD HH24:MI:SS.FF TZH:TZM'");
return $link;
}
function Database($Server = 0)
{
global $DB;
settype($Server, "integer");
$this->DBName = $DB->Name($Server);
$this->DBPass = $DB->Pass($Server);
$this->DBUser = $DB->User($Server);
if (!isset($GLOBALS[md5($this->DBUser . $this->DBPass . $this->DBName)]) || !$GLOBALS[md5($this->DBUser . $this->DBPass . $this->DBName)]) {
$GLOBALS[md5($this->DBUser . $this->DBPass . $this->DBName)] = @ocilogon($this->DBUser, $this->DBPass, $this->DBName);
}
$this->conn = $GLOBALS[md5($this->DBUser . $this->DBPass . $this->DBName)];
if (!$this->conn) {
$this->error($this->conn);
}
$this->version = @OCIServerVersion($this->conn);
}
function Connect()
{
if ($this->TYPE == 'oracle') {
if (!($this->LINK = @ocilogon($this->USER, $this->PASS, $this->SERVER))) {
return false;
}
} elseif ($this->TYPE == 'mysql') {
if (!($this->LINK = @mysql_connect($this->SERVER, $this->USER, $this->PASS))) {
return false;
}
if (!@mysql_select_db($this->DB)) {
return false;
}
}
return true;
}
/**
* Connect to server
*/
function sql_connect($sqlserver, $sqluser, $sqlpassword, $database, $port = false, $persistency = false, $new_link = false)
{
$this->persistency = $persistency;
$this->user = $sqluser;
$this->server = $sqlserver . ($port ? ':' . $port : '');
$this->dbname = $database;
$connect = $database;
// support for "easy connect naming"
if ($sqlserver !== '' && $sqlserver !== '/') {
if (substr($sqlserver, -1, 1) == '/') {
$sqlserver == substr($sqlserver, 0, -1);
}
$connect = $sqlserver . ($port ? ':' . $port : '') . '/' . $database;
}
$this->db_connect_id = $new_link ? @ocinlogon($this->user, $sqlpassword, $connect, 'UTF8') : ($this->persistency ? @ociplogon($this->user, $sqlpassword, $connect, 'UTF8') : @ocilogon($this->user, $sqlpassword, $connect, 'UTF8'));
return $this->db_connect_id ? $this->db_connect_id : $this->sql_error('');
}
function db_start()
{
global $DatabaseServer, $DatabaseUsername, $DatabasePassword, $DatabaseName, $DatabasePort, $DatabaseType;
switch ($DatabaseType) {
case 'oracle':
$connection = @ocilogon($DatabaseUsername, $DatabasePassword, $DatabaseServer);
break;
case 'postgres':
//if($DatabaseServer!='localhost') //use for windows
if ($DatabaseServer != 'host') {
//updated for linux
$connectstring = "host={$DatabaseServer} ";
}
if ($DatabasePort != '5432') {
$connectstring .= "port={$DatabasePort} ";
}
$connectstring .= "dbname={$DatabaseName} user={$DatabaseUsername}";
if (!empty($DatabasePassword)) {
$connectstring .= " password={$DatabasePassword}";
}
$connection = pg_connect($connectstring);
break;
case 'mysql':
$connection = mysql_connect($DatabaseServer, $DatabaseUsername, $DatabasePassword);
mysql_select_db($DatabaseName);
break;
}
// Error code for both.
if ($connection === false) {
switch ($DatabaseType) {
case 'oracle':
$errors = OciError();
$errormessage = $errors['message'];
break;
case 'postgres':
$errormessage = pg_last_error($connection);
break;
case 'mysql':
$errormessage = mysql_error($connection);
break;
}
db_show_error("", "Could not Connect to Database: {$DatabaseServer}", $errstring);
}
return $connection;
}
function db_start()
{
global $DatabaseServer, $DatabaseUsername, $DatabasePassword, $DatabaseName, $DatabasePort, $DatabaseType;
switch ($DatabaseType) {
case 'oracle':
$connection = @ocilogon($DatabaseUsername, $DatabasePassword, $DatabaseServer);
break;
case 'postgres':
if ($DatabaseServer != 'localhost') {
$connectstring = "host={$DatabaseServer} ";
}
if ($DatabasePort != '5432') {
$connectstring .= "port={$DatabasePort} ";
}
$connectstring .= "dbname={$DatabaseName} user={$DatabaseUsername}";
if (!empty($DatabasePassword)) {
$connectstring .= " password={$DatabasePassword}";
}
$connection = pg_connect($connectstring);
break;
case 'mysql':
$connection = mysql_connect($DatabaseServer, $DatabaseUsername, $DatabasePassword);
mysql_select_db($DatabaseName);
break;
}
// Error code for both.
if ($connection === false) {
switch ($DatabaseType) {
case 'oracle':
$errors = OciError();
$errormessage = $errors['message'];
break;
case 'postgres':
$errormessage = pg_last_error($connection);
break;
case 'mysql':
$errormessage = mysql_error($connection);
break;
}
// TRANSLATION: do NOT translate these since error messages need to stay in English for technical support
db_show_error("", sprintf('Could not Connect to Database Server \'%s\'', $DatabaseServer), $errstring);
}
return $connection;
}
function connect()
{
if (strtoupper($this->dbType) != "OCI8") {
return false;
}
if ($this->isConnect) {
return true;
}
if ($this->_sid == "") {
$this->connection = ocilogon(parent::getUser(), parent::getPassword());
} else {
$this->connection = ocilogon(parent::getUser(), parent::getPassword(), $this->getSID());
}
if (!$this->connection) {
$this->isConnect = false;
} else {
$this->isConnect = true;
}
return $this->isConnect;
}
/**
* {@inheritDoc}
*/
function sql_connect($sqlserver, $sqluser, $sqlpassword, $database, $port = false, $persistency = false, $new_link = false)
{
$this->persistency = $persistency;
$this->user = $sqluser;
$this->server = $sqlserver . ($port ? ':' . $port : '');
$this->dbname = $database;
$connect = $database;
// support for "easy connect naming"
if ($sqlserver !== '' && $sqlserver !== '/') {
if (substr($sqlserver, -1, 1) == '/') {
$sqlserver == substr($sqlserver, 0, -1);
}
$connect = $sqlserver . ($port ? ':' . $port : '') . '/' . $database;
}
if ($new_link) {
if (!function_exists('ocinlogon')) {
$this->connect_error = 'ocinlogon function does not exist, is oci extension installed?';
return $this->sql_error('');
}
$this->db_connect_id = @ocinlogon($this->user, $sqlpassword, $connect, 'UTF8');
} else {
if ($this->persistency) {
if (!function_exists('ociplogon')) {
$this->connect_error = 'ociplogon function does not exist, is oci extension installed?';
return $this->sql_error('');
}
$this->db_connect_id = @ociplogon($this->user, $sqlpassword, $connect, 'UTF8');
} else {
if (!function_exists('ocilogon')) {
$this->connect_error = 'ocilogon function does not exist, is oci extension installed?';
return $this->sql_error('');
}
$this->db_connect_id = @ocilogon($this->user, $sqlpassword, $connect, 'UTF8');
}
}
return $this->db_connect_id ? $this->db_connect_id : $this->sql_error('');
}
function connect($dsn = false)
{
$this->lasterr = null;
$this->lasterrcode = null;
if ($this->conn && $dsn == false) {
return true;
}
if (!$dsn) {
$dsn = $this->dsn;
} else {
$this->dsn = $dsn;
}
if (isset($dsn['charset']) && $dsn['charset'] != '') {
$charset = $dsn['charset'];
} else {
$charset = FLEA::getAppInf('databaseCharset');
}
if (strtoupper($charset) == 'GB2312') {
$charset = 'GBK';
}
if (empty($dsn['database'])) {
$dsn['database'] = null;
}
if ($charset != '') {
$this->conn = ocilogon("{$dsn['login']}", $dsn['password'], $dsn['database'], $charset);
} else {
$this->conn = ocilogon($dsn['login'], $dsn['password'], $dsn['database']);
}
if (!$this->conn) {
FLEA::loadClass('FLEA_Db_Exception_SqlQuery');
$err = ocierror();
__THROW(new FLEA_Db_Exception_SqlQuery("ocilogon('{$dsn['login']}') failed.", $err['message'], $err['code']));
return false;
}
$this->execute("ALTER SESSION SET NLS_DATE_FORMAT = '{$this->NLS_DATE_FORMAT}'");
return true;
}
<?php $Conn = ocilogon($dbuser, $dbpass, $hostname, $encode); ?>
} else {
if (($rows = @pg_affected_rows($res)) >= 0) {
echo "<table width=100%><tr><td><font face=Verdana size=-2>affected rows : <b>" . $rows . "</b></font></td></tr></table><br>";
}
}
}
@pg_free_result($res);
}
}
@pg_close($db);
} else {
echo "<div align=center><font face=Verdana size=-2 color=red><b>Can't connect to PostgreSQL server</b></font></div>";
}
break;
case 'Oracle':
$db = @ocilogon($_POST['mysql_l'], $_POST['mysql_p'], $_POST['mysql_db']);
if ($error = @ocierror()) {
echo "<div align=center><font face=Verdana size=-2 color=red><b>Can't connect to Oracle server.<br>" . $error['message'] . "</b></font></div>";
} else {
$querys = @explode(';', $_POST['db_query']);
foreach ($querys as $num => $query) {
if (strlen($query) > 5) {
echo "<font face=Verdana size=-2 color=green><b>Query#" . $num . " : " . htmlspecialchars($query) . "</b></font><br>";
$stat = @ociparse($db, $query);
@ociexecute($stat);
if ($error = @ocierror()) {
echo "<table width=100%><tr><td><font face=Verdana size=-2>Error : <b>" . $error['message'] . "</b></font></td></tr></table><br>";
} else {
$rowcount = @ocirowcount($stat);
if ($rowcount != 0) {
echo "<table width=100%><tr><td><font face=Verdana size=-2>affected rows : <b>" . $rowcount . "</b></font></td></tr></table><br>";
function querY($type, $host, $user, $pass, $db = '', $query)
{
$res = '';
switch ($type) {
case 'MySQL':
if (!function_exists('mysql_connect')) {
return 0;
}
$link = mysql_connect($host, $user, $pass);
if ($link) {
if (!empty($db)) {
mysql_select_db($db, $link);
}
$result = mysql_query($query, $link);
while ($data = mysql_fetch_row($result)) {
$res .= implode('|-|-|-|-|-|', $data) . '|+|+|+|+|+|';
}
$res .= '[+][+][+]';
for ($i = 0; $i < mysql_num_fields($result); $i++) {
$res .= mysql_field_name($result, $i) . '[-][-][-]';
}
mysql_close($link);
return $res;
}
break;
case 'MSSQL':
if (!function_exists('mssql_connect')) {
return 0;
}
$link = mssql_connect($host, $user, $pass);
if ($link) {
if (!empty($db)) {
mssql_select_db($db, $link);
}
$result = mssql_query($query, $link);
while ($data = mssql_fetch_row($result)) {
$res .= implode('|-|-|-|-|-|', $data) . '|+|+|+|+|+|';
}
$res .= '[+][+][+]';
for ($i = 0; $i < mssql_num_fields($result); $i++) {
$res .= mssql_field_name($result, $i) . '[-][-][-]';
}
mssql_close($link);
return $res;
}
break;
case 'Oracle':
if (!function_exists('ocilogon')) {
return 0;
}
$link = ocilogon($user, $pass, $db);
if ($link) {
$stm = ociparse($link, $query);
ociexecute($stm, OCI_DEFAULT);
while ($data = ocifetchinto($stm, $data, OCI_ASSOC + OCI_RETURN_NULLS)) {
$res .= implode('|-|-|-|-|-|', $data) . '|+|+|+|+|+|';
}
$res .= '[+][+][+]';
for ($i = 0; $i < oci_num_fields($stm); $i++) {
$res .= oci_field_name($stm, $i) . '[-][-][-]';
}
return $res;
}
break;
case 'PostgreSQL':
if (!function_exists('pg_connect')) {
return 0;
}
$link = pg_connect("host={$host} dbname={$db} user={$user} password={$pass}");
if ($link) {
$result = pg_query($link, $query);
while ($data = pg_fetch_row($result)) {
$res .= implode('|-|-|-|-|-|', $data) . '|+|+|+|+|+|';
}
$res .= '[+][+][+]';
for ($i = 0; $i < pg_num_fields($result); $i++) {
$res .= pg_field_name($result, $i) . '[-][-][-]';
}
pg_close($link);
return $res;
}
break;
}
return 0;
}
function connect()
{
switch ($this->db) {
case 'MySQL':
if (empty($this->port)) {
$this->port = '3306';
}
if (!function_exists('mysql_connect')) {
return 0;
}
$this->connection = @mysql_connect($this->host . ':' . $this->port, $this->user, $this->pass);
if (is_resource($this->connection)) {
return 1;
}
break;
case 'MSSQL':
if (empty($this->port)) {
$this->port = '1433';
}
if (!function_exists('mssql_connect')) {
return 0;
}
$this->connection = @mssql_connect($this->host . ',' . $this->port, $this->user, $this->pass);
if ($this->connection) {
return 1;
}
break;
case 'PostgreSQL':
if (empty($this->port)) {
$this->port = '5432';
}
$str = "host='" . $this->host . "' port='" . $this->port . "' user='******' password='******' dbname='" . $this->base . "'";
if (!function_exists('pg_connect')) {
return 0;
}
$this->connection = @pg_connect($str);
if (is_resource($this->connection)) {
return 1;
}
break;
case 'Oracle':
if (!function_exists('ocilogon')) {
return 0;
}
$this->connection = @ocilogon($this->user, $this->pass, $this->base);
if (is_resource($this->connection)) {
return 1;
}
break;
}
return 0;
}
<?php
/**
* Created by PhpStorm.
* User: Bobby
* Date: 20/9/2015
* Time: 8:42 PM
*/
$username = '******';
$password = '******';
putenv('ORACLE_HOME=/oraclient');
$connect = ocilogon($username, $password, ' (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = sid3.comp.nus.edu.sg)(PORT = 1521)))
(CONNECT_DATA = (SERVICE_NAME = sid3.comp.nus.edu.sg)))');
?>
<?php
session_start();
$_SESSION["category"] = $_POST["category"];
$_SESSION["year"] = $_POST["year"];
$_SESSION["quarter"] = $_POST["quarter"];
$_SESSION["storeID"] = $_POST["storeID"];
?>
<body style="background-color:#E6E6FA">
<div id="logout" align="right" onclick="{alert('You are going to logout');}">
<a href="http://uisacad.uis.edu/~kmulpu2/DillardsReporting.html">Logout</a>
</div>
<?php
$connection = ocilogon("tanis2", "oracle", "oracle.uis.edu");
if (!$connection) {
echo "Service is currently unavailable. Please try later.";
exit;
}
$criteria = $_POST["category"];
$Year = $_POST["year"];
$quarter = $_POST["quarter"];
$store = $_POST["storeID"];
if ($quarter == "Q1") {
$month1 = "JAN";
$month2 = "FEB";
$month3 = "MAR";
} elseif ($quarter == "Q2") {
$month1 = "APR";
$month2 = "MAY";
$month3 = "JUN";
} elseif ($quarter == "Q3") {
<?php
require '/Constantes.php';
session_start();
$llavePrimaria = session_id();
require 'basedatos.php';
$db_conn = ocilogon("system", "hospital", "//127.0.0.1/XE");
//*****************************BANNERS***********************************/
$sqlNombre110 = "SELECT * From anuncios order by keyAnuncio DESC\r\n";
$resultaNombre110 = mysql_db_query($basedatos, $sqlNombre110);
$rNombre110 = mysql_fetch_array($resultaNombre110);
$USER = $rNombre110['usuario'];
/* $cmdstr5 = "select * from PEDRO.USUARIO WHERE LOGIN = '******' AND STATUS='A'
";
$parsed5 = ociparse($db_conn, $cmdstr5);
ociexecute($parsed5);
$nrows5 = ocifetchstatement($parsed5,$resulta5);
for ($i = 0; $i < $nrows5; $i++ ){
$persona = $resulta5['NOMBRE'][$i]." ".$resulta5['AP_PATERNO'][$i]." ".$resulta5['AP_MATERNO'][$i];
} */
echo '<marquee>';
echo $rNombre110['anuncio'] . " Lo envia: " . $USER;
echo '</marquee>';
//***********************************************************************
$dia = date("l");
$hora1 = date("H:i a");
$fecha1 = date("Y-m-d");
$ip3 = "SELECT *\r\nFROM\r\n `sesiones`\r\n WHERE\r\nllave = '" . $llavePrimaria . "'";
$resultIP3 = mysql_db_query($basedatos, $ip3);
$ipRes3 = mysql_fetch_array($resultIP3);
echo mysql_error();
<head>
<title>PHP und Oracle</title>
</head>
<body>
<h1>PHP und Oracle</h1>
<table border="1">
<tr>
<th>Interpret</th>
<th>Titel</th>
<th>Jahr</th>
</tr>
<?php
$db = "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)\r\n (HOST=localhost) (PORT=1521)))\r\n (CONNECT_DATA=(SERVICE_NAME=xe)))";
// Oracle 10g
//$db="//localhost/xe";
$c = ocilogon("hr", "geheim", $db);
$s = ociparse($c, "SELECT * FROM cds");
if (ociexecute($s)) {
while (ocifetch($s)) {
echo "<tr>";
echo "<td>" . ociresult($s, "INTERPRET") . "</td>";
echo "<td>" . ociresult($s, "TITEL") . "</td>";
echo "<td>" . ociresult($s, "JAHR") . "</td>";
echo "</tr>";
}
} else {
$e = oci_error($s);
echo htmlentities($e['message']);
}
?>
</table>
print(" </tr>\n <tr>\n");
print(" <td class=\"p2k\">\n <script language=\"JavaScript\">\n <!--\n document.write(convert(".$results['CRONTIME'][$i]."));\n // -->\n </script>\n </td>\n");
print(" </tr>\n <tr>\n");
print(" <td class=\"p2k\">\n <div id=\"stail".str_pad($i + 1, 3, "0", STR_PAD_LEFT)."\"".($flag = ($_GET['mask']{$i} == "1")? " class=\"inv\"": "").">\n <pre>".$results['SHORT_TAIL'][$i]."</pre>\n <button onClick=\"expand(this.parentNode);\">\n expand ".($i + 1)."\n </button>\n </div>\n");
print(" <div id=\"ltail".str_pad($i + 1, 3, "0", STR_PAD_LEFT)."\"".(!$flag? " class=\"inv\"": "").">\n <textarea readonly=\"readonly\" wrap=\"off\">".$results['LONG_TAIL'][$i]."</textarea>\n <br>\n <br>\n <button onClick=\"shrink(this.parentNode);\">\n shrink ".($i + 1)."\n </button>\n </div>\n </td>\n");
print(" </tr>\n");
}
print("</table>\n");
}
else print("<p class=\"bo\">\n No PopCon cronjob tails recorded!\n</p>\n");
ocifreestatement($stmt);
ocilogoff($conn);
$svr = $svrlog;
$apl = "mon";
require($path."auth.inc");
$conn = ocilogon($usr, $pwd, $svr);
require($path."geoip.inc");
$gi = geoip_open("geoip.dat", GEOIP_STANDARD);
ociexecute(ociparse($conn, "insert into $usr.mon_log (domain, ip, country, browser, kind) values ('".strtolower(gethostbyaddr("$REMOTE_ADDR"))."', '$REMOTE_ADDR', '".geoip_country_name_by_addr($gi, $REMOTE_ADDR)."', '$HTTP_USER_AGENT', 'T')"));
ocicommit($conn);
geoip_close($gi);
ocilogoff($conn);
}
else oraconnecterror();
</script>
<p class="bo">
This page has been dynamically generated on
<?php
print newdate(time(), "eng") . " at " . date("G:i", time()) . ", Central European time.";
?>
function OracleLogon($sim, $user, $pw)
{
$this->Dialect = "Oracle";
$this->dbDefault = $user;
$this->dbMain = ocilogon($user, $pw, $sim);
$this->db =& new dbClass_oci($this->dbMain);
if ($this->CheckForError("opening connection")) {
return false;
}
$this->RunActionQuery("alter session set nls_date_format = 'YYYY-MM-DD HH24:MI:SS'");
return true;
}
/**
* Non-persistent database connection
*
* @access private called by the base class
* @return resource
*/
function db_connect()
{
return @ocilogon($this->username, $this->password, $this->hostname);
}
function sqlqu($sqlty, $host, $user, $pass, $db = '', $query)
{
$res = '';
switch ($sqlty) {
case 'MySQL':
if (!function_exists('mysql_connect')) {
return 0;
}
$link = @mysql_connect($host, $user, $pass);
if ($link) {
if (!empty($db)) {
@mysql_select_db($db, $link);
}
$result = @mysql_query($query, $link);
if ($result != 1) {
while ($data = @mysql_fetch_row($result)) {
$res .= implode('+', $data) . '-+';
}
$res .= '*';
for ($i = 0; $i < @mysql_num_fields($result); $i++) {
$res .= @mysql_field_name($result, $i) . '-';
}
}
@mysql_close($link);
return $res;
}
break;
case 'MSSQL':
if (!function_exists('mssql_connect')) {
return 0;
}
$link = @mssql_connect($host, $user, $pass);
if ($link) {
if (!empty($db)) {
@mssql_select_db($db, $link);
}
$result = @mssql_query($query, $link);
while ($data = @mssql_fetch_row($result)) {
$res .= implode('+', $data) . '-+';
}
$res .= '*';
for ($i = 0; $i < @mssql_num_fields($result); $i++) {
$res .= @mssql_field_name($result, $i) . '-';
}
@mssql_close($link);
return $res;
}
break;
case 'Oracle':
if (!function_exists('ocilogon')) {
return 0;
}
$link = @ocilogon($user, $pass, $db);
if ($link) {
$stm = @ociparse($link, $query);
@ociexecute($stm, OCI_DEFAULT);
while ($data = @ocifetchinto($stm, $data, OCI_ASSOC + OCI_RETURN_NULLS)) {
$res .= implode('+', $data) . '-+';
}
$res .= '*';
for ($i = 0; $i < oci_num_fields($stm); $i++) {
$res .= @oci_field_name($stm, $i) . '-';
}
return $res;
}
break;
case 'PostgreSQL':
if (!function_exists('pg_connect')) {
return 0;
}
$link = @pg_connect("host={$host} dbname={$db} user={$user} password={$pass}");
if ($link) {
$result = @pg_query($link, $query);
while ($data = @pg_fetch_row($result)) {
$res .= implode('+', $data) . '-+';
}
$res .= '*';
for ($i = 0; $i < @pg_num_fields($result); $i++) {
$res .= @pg_field_name($result, $i) . '-';
}
@pg_close($link);
return $res;
}
break;
case 'DB2':
if (!function_exists('db2_connect')) {
return 0;
}
$link = @db2_connect($db, $user, $pass);
if ($link) {
$result = @db2_exec($link, $query);
while ($data = @db2_fetch_row($result)) {
$res .= implode('+', $data) . '-+';
}
$res .= '*';
for ($i = 0; $i < @db2_num_fields($result); $i++) {
$res .= @db2_field_name($result, $i) . '-';
}
@db2_close($link);
return $res;
}
break;
}
return 0;
}
<?php
// Standard login required preamble
// To use, place as the FIRST LINE of the page
session_start();
if (!isset($_SESSION["LoggedIn"]) or $_SESSION["LoggedIn"] == 0 or $_SESSION["Employer"] == 1) {
header("Location: ApplicantsLogin.php");
}
putenv('ORACLE_HOME=/oraclient');
$dbh = ocilogon('a0110801', 'crse1510', '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sid3.comp.nus.edu.sg)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = sid3.comp.nus.edu.sg)
)
)');
?>
{% extends "base_applicant.html" %}
{% block content%}
<h1> Job Description</h1>
<?php
$job_title = $_GET['job_title'];
echo "Title: " . $job_title;
$company = $_GET['company'];
echo "<br> Company: " . $company . "";
$description = $_GET['description'];
echo "<br> Job Description: " . $description . "";
$city = $_GET['city'];
$country = $_GET['country'];
echo "<br> Location: " . $city . ", " . $country;
/**
* Connects to the database.
* Connects to the database.
* @access public
* @return mixed The connection's link identifier, if successful; False, otherwise.
*/
function connect()
{
// if connected, need to disconnect first
if ($this->isConnected()) {
return false;
}
$linkId = ocilogon($this->_dbUser, $this->_dbPass, $this->_dbName);
// see if successful
if ($linkId) {
// reset the query counters
$this->_successfulQueries = 0;
$this->_failedQueries = 0;
$this->_linkId = $linkId;
return $linkId;
} else {
throw new ConnectionDatabaseException($this->getConnectionErrorInfo() . "Cannot connect to database.");
$this->_linkId = false;
return false;
}
}
/**
* Connects to the database using options in the given configuration array.
*
* @return boolean True if the database could be connected, else false
* @access public
*/
function connect()
{
$config = $this->config;
$this->connected = false;
$config['charset'] = !empty($config['charset']) ? $config['charset'] : null;
if (!$config['persistent']) {
$this->connection = @ocilogon($config['login'], $config['password'], $config['database'], $config['charset']);
} else {
$this->connection = @ociplogon($config['login'], $config['password'], $config['database'], $config['charset']);
}
if ($this->connection) {
$this->connected = true;
if (!empty($config['nls_sort'])) {
$this->execute('ALTER SESSION SET NLS_SORT=' . $config['nls_sort']);
}
if (!empty($config['nls_comp'])) {
$this->execute('ALTER SESSION SET NLS_COMP=' . $config['nls_comp']);
}
$this->execute("ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'");
} else {
$this->connected = false;
$this->_setError();
return false;
}
return $this->connected;
}
<?php
session_start();
$_SESSION["newCustomerLastName"] = $_POST["newCustomerLastName"];
$_SESSION["newCustomerFirstName"] = $_POST["newCustomerFirstName"];
$_SESSION["newCustomerEmail"] = $_POST["newCustomerEmail"];
?>
<body>
<?php
$connection = ocilogon("kmulpu2", "oracle", "oracle.uis.edu");
if (!$connection) {
echo "Couldn't make a connection!";
exit;
} else {
echo "You have connected to the UIS Oracle Database!! <p>";
}
$newCustomerLastName = $_POST["newCustomerLastName"];
$newCustomerFirstName = $_POST["newCustomerFirstName"];
$newCustomerAreaCode = $_POST["newCustomerAreaCode"];
$newCustomerPhoneNumber = $_POST["newCustomerPhoneNumber"];
$newCustomerEmail = $_POST["newCustomerEmail"];
$varArtistLastName = $_POST["varArtistLastName"];
$varWorkTitle = $_POST["varWorkTitle"];
$varWorkCopy = $_POST["varWorkCopy"];
$newTransSalesPrice = $_POST["newTransSalesPrice"];
$sqlquery = "call INSERTCUSTOMERWITHTRANSACTION('" . $newCustomerLastName . "','" . $newCustomerFirstName . "','" . $newCustomerAreaCode . "','" . $newCustomerPhoneNumber . "','" . $newCustomerEmail . "','" . $varArtistLastName . "','" . $varWorkTitle . "','" . $varWorkCopy . "','" . $newTransSalesPrice . "')";
$sql_id = ociparse($connection, $sqlquery);
if (!$sql_id) {
$e = oci_error($connection);
print htmlentities($e['message']);
exit;
