function connect() { if (!$this->Connected) { $this->Query_ID = 0; if ($this->Debug) { printf("<br>Connecting to {$this->DBDatabase}...<br>\n"); } $old_error_reporting = error_reporting(); error_reporting($old_error_reporting & ~E_WARNING); if ($this->Persistent) { $this->Link_ID = OCIplogon("{$this->DBUser}", "{$this->DBPassword}", "{$this->DBDatabase}", $this->Encoding); } else { $this->Link_ID = OCIlogon("{$this->DBUser}", "{$this->DBPassword}", "{$this->DBDatabase}", $this->Encoding); } error_reporting($old_error_reporting); if (!$this->Link_ID) { $this->Error = OCIError(); $this->Halt($this->Error); #$this->Halt("Cannot connect to Database: " . $this->Error["message"]. " ". $this->Error); return 0; } if ($this->Debug) { printf("<br>Obtained the Link_ID: {$this->Link_ID}<br>\n"); } $this->Connected = true; } return $this->Connected; }
<?php // $db = "(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)))(CONNECT_DATA=(SID=dblocal)))" ; // $conn = OCIlogon("GRATIFIKASI","1qaz2wsx",$db) ; $db = "(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522)))(CONNECT_DATA=(SID=orcl)))"; $conn = OCIlogon("localuser", "qwerty", $db); date_default_timezone_set('Asia/Jakarta'); $tanggal = date('d-m-Y'); $jam = date("H:i:s");
function _connect($argHostname, $argUsername, $argPassword, $argDatabasename) { if ($argHostname) { // added by Jorma Tuomainen <*****@*****.**> if (strpos($argHostname, ":")) { $argHostinfo = explode(":", $argHostname); $argHostname = $argHostinfo[0]; $argHostport = $argHostinfo[1]; } else { $argHostport = "1521"; } $argDatabasename = "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=" . $argHostname . ")(PORT={$argHostport}))(CONNECT_DATA=(SERVICE_NAME={$argDatabasename})))"; } //if ($argHostname) print "<p>Connect: 1st argument should be left blank for $this->databaseType</p>"; $this->_connectionID = OCIlogon($argUsername, $argPassword, $argDatabasename); if ($this->_connectionID === false) { return false; } if ($this->_initdate) { $this->Execute("ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD'"); } return true; }