/** * SQL Transaction * @access private */ function _sql_transaction($status = 'begin') { switch ($status) { case 'begin': return true; break; case 'commit': return @ocicommit($this->db_connect_id); break; case 'rollback': return @ocirollback($this->db_connect_id); break; } return true; }
/** * Commit a transaction * * @param unknown_type $model * @return boolean True on success, false on fail * (i.e. if the database/model does not support transactions, * or a transaction has not started). */ function commit() { $this->__transactionStarted = false; return ocicommit($this->connection); }
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."; ?> Created on September 20<sup>th</sup>, 2008, its source code has been last updated on November 13<sup>th</sup>, 2008. <br> For any suggestion or comment, please write to <?php
function DBcommit() { global $DB; $result = false; if (isset($DB['DB']) && !empty($DB['DB'])) { switch ($DB['TYPE']) { case 'MYSQL': $result = DBexecute('commit'); break; case 'POSTGRESQL': $result = DBexecute('commit'); break; case 'ORACLE': $result = ocicommit($DB['DB']); break; case 'SQLITE3': $result = DBexecute('commit'); unlock_db_access(); break; } } return $result; }
$username = $_POST['username']; $password = $_POST['pwd']; if ($password == null) { echo '<font color="' . red . '">Password cannot be blank. Please enter a valid password</font>'; echo "<br/><br/>"; echo "<a href='http://uisacad.uis.edu/~kmulpu2/PasswordReset.html'>Back To Password Reset Page</a>"; exit; } $connection = ocilogon("tanis2", "oracle", "oracle.uis.edu"); $sqlquery = "UPDATE CREDENTIALS SET password='******' WHERE username='******'"; $sql_id = ociparse($connection, $sqlquery); if (!$sql_id) { $e = oci_error($connection); echo "The following error occured:"; print htmlentities($e['message']); exit; } $returnValue = ociexecute($sql_id, OCI_DEFAULT); if ($returnValue == 1) { echo '<font color="' . blue . '">Password was reset successfully</font>'; ocicommit($connection); echo "<br/><br/>"; echo "<a href='http://uisacad.uis.edu/~kmulpu2/DillardsReporting.html'>Back To Login Page</a>"; } else { echo '<font color="' . red . '">Unable to reset password due to server issues. Please try again later</font>'; } OCIFreeStatement($sql_id); OCILogoff($connection); ?> </body> </html>
function DBcommit() { global $DB; $result = false; switch ($DB['TYPE']) { case ZBX_DB_MYSQL: $result = DBexecute('commit'); break; case ZBX_DB_POSTGRESQL: $result = DBexecute('commit'); break; case ZBX_DB_ORACLE: $result = ocicommit($DB['DB']); break; case ZBX_DB_DB2: $result = db2_commit($DB['DB']); if ($result) { db2_autocommit($DB['DB'], DB2_AUTOCOMMIT_ON); } break; case ZBX_DB_SQLITE3: $result = DBexecute('commit'); unlock_sqlite3_access(); break; } return $result; }
function &commit() { return ocicommit($this->_connection); }
function commit() { return ocicommit($this->connection); }
function commit() { if (!$this->isConnect) { return false; } return ocicommit($this->connection); }
/** * Close the database connections. We don't really need to close them (will close at exit), just disassociate so we can refresh them. */ function db_close_connections() { global $CACHE_DB; foreach ($CACHE_DB as $db) { foreach ($db as $_db) { ocicommit($_db); } } }
/** * db_commit() - Commit a transaction */ function db_commit() { global $sys_db_oci_commit_mode, $gfconn; $sys_db_oci_commit_mode = 'OCI_COMMIT_ON_SUCCESS'; return ocicommit($gfconn); }
function DBcommit() { global $DB; $result = false; if (isset($DB['DB']) && !empty($DB['DB'])) { switch ($DB['TYPE']) { case 'MYSQL': $result = DBexecute('commit'); break; case 'POSTGRESQL': $result = DBexecute('commit'); break; case 'ORACLE': $result = ocicommit($DB['DB']); break; case 'IBM_DB2': $result = db2_commit($DB['DB']); if ($result) { db2_autocommit($DB['DB'], DB2_AUTOCOMMIT_ON); } break; case 'SQLITE3': $result = DBexecute('commit'); unlock_db_access(); break; } } return $result; }
ocicloselob(); ocicollappend(); ocicollassign(); ocicollassignelem(); ocicollgetelem(); ocicollmax(); ocicollsize(); ocicolltrim(); ocicolumnisnull(); ocicolumnname(); ocicolumnprecision(); ocicolumnscale(); ocicolumnsize(); ocicolumntype(); ocicolumntyperaw(); ocicommit(); ocidefinebyname(); ocierror(); ociexecute(); ocifetch(); ocifetchinto(); ocifetchstatement(); ocifreecollection(); ocifreecursor(); ocifreedesc(); ocifreestatement(); ociinternaldebug(); ociloadlob(); ocilogoff(); ocilogon(); ocinewcollection();