function actualizarPassword($newpassword, $token) { $conex = DataBase::getInstance(); $stid = oci_parse($conex, "UPDATE FISC_USERS SET \n\t\t\t\t\t\tpassword=:newpassword\n\t\t\t\t WHERE token=:token"); if (!$stid) { oci_free_statement($stid); oci_close($conex); return false; } // Realizar la lógica de la consulta oci_bind_by_name($stid, ':token', $token); oci_bind_by_name($stid, ':newpassword', $newpassword); $r = oci_execute($stid, OCI_NO_AUTO_COMMIT); if (!$r) { oci_free_statement($stid); oci_close($conex); return false; } $r = oci_commit($conex); if (!$r) { oci_free_statement($stid); oci_close($conex); return false; } oci_free_statement($stid); // Cierra la conexión Oracle oci_close($conex); return true; }
function insertImage($conn, $photo_id, $owner_name, $descriptive_info, $thumbnail, $photo) { $photo_blob = oci_new_descriptor($conn, OCI_D_LOB); $thumbnail_blob = oci_new_descriptor($conn, OCI_D_LOB); $subject = $descriptive_info[0]; $place = $descriptive_info[1]; $date_time = $descriptive_info[2]; $description = $descriptive_info[3]; $permitted = $descriptive_info[4]; $sql = 'INSERT INTO images (photo_id, owner_name, permitted, subject, place, timing, description, thumbnail, photo) VALUES (:photoid, :ownername, :permitted, :subject, :place, TO_DATE(:datetime, \'MM/DD/YYYY\'), :description, empty_blob(), empty_blob()) returning thumbnail, photo into :thumbnail, :photo'; $stid = oci_parse($conn, $sql); oci_bind_by_name($stid, ':photoid', $photo_id); oci_bind_by_name($stid, ':ownername', $owner_name); oci_bind_by_name($stid, ':permitted', $permitted); oci_bind_by_name($stid, ':subject', $subject); oci_bind_by_name($stid, ':place', $place); oci_bind_by_name($stid, ':datetime', $date_time); oci_bind_by_name($stid, ':description', $description); oci_bind_by_name($stid, ':thumbnail', $thumbnail_blob, -1, OCI_B_BLOB); oci_bind_by_name($stid, ':photo', $photo_blob, -1, OCI_B_BLOB); $res = oci_execute($stid, OCI_DEFAULT); if ($thumbnail_blob->save($thumbnail) && $photo_blob->save($photo)) { oci_commit($conn); } else { oci_rollback($conn); } oci_free_statement($stid); $photo_blob->free(); $thumbnail_blob->free(); }
function obtenerDenuncias($denuncias) { //$ids = transformarArray($denuncias,","); $conex = DataBase::getInstance(); foreach ($denuncias as $key => $value) { $conex = DataBase::getInstance(); $stid = oci_parse($conex, "UPDATE FISC_DENUNCIAS SET \n\t\t\t\t\tASIGNACION=1 , ASIGNADOPOR=:sesion_cod\n\t\t\t\t\tWHERE ID_DENUNCIA=:ID"); if (!$stid) { oci_free_statement($stid); oci_close($conex); return false; } // Realizar la lógica de la consulta oci_bind_by_name($stid, ':ID', $value); oci_bind_by_name($stid, ':sesion_cod', $_SESSION['USUARIO']['codigo_usuario']); $r = oci_execute($stid, OCI_NO_AUTO_COMMIT); if (!$r) { oci_free_statement($stid); oci_close($conex); return false; } $r = oci_commit($conex); if (!$r) { oci_free_statement($stid); oci_close($conex); return false; } oci_free_statement($stid); // Cierra la conexión Oracle oci_close($conex); } return true; }
function createPicturesTableIfNeeded($db) { $table = 'pictures'; $index = 'description_indx'; $table = strtoupper($table); if (!$this->tableExists($db, $table)) { $sql = "CREATE TABLE {$table} (\n picture_id int PRIMARY KEY,\n name VARCHAR2(50) NOT NULL,\n creation_date DATE,\n upload_date DATE,\n description VARCHAR2(1000),\n image ORDSYS.ORDImage,\n image_sig ORDSYS.ORDImageSignature,\n artist_fk int REFERENCES artists(artist_id),\n artist_safety_level int,\n museum_ownes_fk int REFERENCES museums(museum_id),\n museum_exhibits_fk int REFERENCES museums(museum_id),\n museum_exhibits_startdate date,\n museum_exhibits_enddate date,\n owner_fk int REFERENCES owners(owner_id)\n )"; $this->executeSql($db, $sql); $this->createSequence($db, $table . "_seq"); } $index = strtoupper($index); if (!$this->indexExists($db, $index)) { //create index for description $sql = "begin\n ctx_ddl.create_preference('mylexer', 'BASIC_LEXER' );\n ctx_ddl.set_attribute ( 'mylexer', 'mixed_case', 'NO' );\n end;"; echo "{$this->log} - {$sql} <br />"; $stmt = oci_parse($db, $sql); oci_execute($stmt, OCI_NO_AUTO_COMMIT); $sql = "begin\n ctx_ddl.create_preference('mystore', 'BASIC_STORAGE');\n ctx_ddl.set_attribute('mystore', 'I_TABLE_CLAUSE', 'tablespace INDX');\n ctx_ddl.set_attribute('mystore', 'K_TABLE_CLAUSE', 'tablespace INDX');\n ctx_ddl.set_attribute('mystore', 'R_TABLE_CLAUSE', 'tablespace INDX');\n ctx_ddl.set_attribute('mystore', 'N_TABLE_CLAUSE', 'tablespace INDX');\n ctx_ddl.set_attribute('mystore', 'I_INDEX_CLAUSE', 'tablespace INDX');\n ctx_ddl.set_attribute('mystore', 'P_TABLE_CLAUSE', 'tablespace INDX');\n end;"; echo "{$this->log} - {$sql} <br />"; $stmt = oci_parse($db, $sql); oci_execute($stmt, OCI_NO_AUTO_COMMIT); $sql = "CREATE INDEX myIndex ON PICTURES ( DESCRIPTION )\n INDEXTYPE IS CTXSYS.CONTEXT\n PARAMETERS ( 'LEXER mylexer STORAGE mystore SYNC (ON COMMIT)' )"; echo "{$this->log} - {$sql} <br />"; $stmt = oci_parse($db, $sql); oci_execute($stmt, OCI_NO_AUTO_COMMIT); oci_commit($db); } }
public function commit() { set_error_handler(static::getErrorHandler()); $isSuccess = oci_commit($this->resource); restore_error_handler(); return $isSuccess; }
/** *Execução de comandos padrões de consulta a banco (SELECT, INSERT, UPDATE, DELETE, CREATE...) *@name execute() *@return ObjectQuery **/ public function Execute($argSql, $argName = NAME_QUERY) { global $result; # call the connect database method $sqli = $this->conn->__conecta(); # instancia as variáveis $this->sql = $argSql; $this->name = $argName; //echo $this->dbtype; //exit; if ($this->conn->typedb == "mysql") { try { # execute sql command $result = $sqli->query($this->sql); # fecha a conexão com o banco de dados $sqli->close(); # retorno do método return $result; } catch (Exception $e) { echo "<b>Erro de query: </b>" . $e->getMessage() . "\n <b>Linha: </b>" . $e->getLine() . "\n"; } } if ($this->conn->typedb == "oracle") { try { $result = oci_parse($sqli, $this->sql); oci_execute($result); oci_commit($sqli); OCILogoff($sqli); return $result; } catch (Exception $e) { OCILogoff($sqli); echo "<b>Erro de query: </b>" . $e->getMessage() . "\n <b>Linha: </b>" . $e->getLine() . "\n"; } } }
/** * Insert image data to database (recoreded_data and thumbnail). * First generate an unique image id, then insert image to recoreded_data and resized image to thubnail along with * other given data */ function uploadImage($conn, $sensor_id, $date_created, $description) { $image_id = generateId($conn, "images"); if ($image_id == 0) { return; } $image2 = file_get_contents($_FILES['file_image']['tmp_name']); $image2tmp = resizeImage($_FILES['file_image']); $image2Thumbnail = file_get_contents($image2tmp['tmp_name']); // encode the stream $image = base64_encode($image2); $imageThumbnail = base64_encode($image2Thumbnail); $sql = "INSERT INTO images (image_id, sensor_id, date_created, description, thumbnail, recoreded_data)\n VALUES(" . $image_id . ", " . $sensor_id . ", TO_DATE('" . $date_created . "', 'DD/MM/YYYY hh24:mi:ss'), '" . $description . "', empty_blob(), empty_blob())\n RETURNING thumbnail, recoreded_data INTO :thumbnail, :recoreded_data"; $result = oci_parse($conn, $sql); $recoreded_dataBlob = oci_new_descriptor($conn, OCI_D_LOB); $thumbnailBlob = oci_new_descriptor($conn, OCI_D_LOB); oci_bind_by_name($result, ":recoreded_data", $recoreded_dataBlob, -1, OCI_B_BLOB); oci_bind_by_name($result, ":thumbnail", $thumbnailBlob, -1, OCI_B_BLOB); $res = oci_execute($result, OCI_DEFAULT) or die("Unable to execute query"); if ($recoreded_dataBlob->save($image) && $thumbnailBlob->save($imageThumbnail)) { oci_commit($conn); } else { oci_rollback($conn); } oci_free_statement($result); $recoreded_dataBlob->free(); $thumbnailBlob->free(); echo "New image is added with image_id ->" . $image_id . "<br>"; }
public function commit() { if (!oci_commit($this->_dbh)) { throw OCI8Exception::fromErrorInfo($this->errorInfo()); } return true; }
public function commit() { parent::commit(); if (!oci_commit($this->link)) { $this->set_driver_error(null, PDO::ERRMODE_EXCEPTION, 'commit'); } $this->setAttribute(PDO::ATTR_AUTOCOMMIT, 1); return true; }
public function commit() { if (!oci_commit($this->dbh)) { $error = oci_error($this->dbh); throw new \Exception($error['message'], $error['code']); } $this->executeMode = OCI_COMMIT_ON_SUCCESS; return true; }
public function commit() { if (oci_commit($this->connection)) { $this->autoCommit = true; } else { $e = oci_error($this->connection); throw new Sabel_Db_Exception_Driver($e["message"]); } }
function gagal__($param, $conn) { $sql = "DELETE FROM MART_MST_CHKOUT WHERE MART_WR_ID = '{$param}'"; $parse = oci_parse($conn, $sql); $exe = oci_execute($parse); if ($exe) { oci_commit($conn); } }
public function insertRow($t, $reqBody) { foreach ($reqBody as $req) { $i = "INSERT INTO {$t} VALUES ('{$req->id}', null, null, '{$req->l_name}', sysdate)"; $resource = oci_parse($this->conn, $i); oci_execute($resource, OCI_NO_AUTO_COMMIT); } oci_commit($this->conn); //echo $req->id . "\n"; }
public function UpdateRecord($sql, $conn) { $status_update = false; $parse = oci_parse($sql, $conn); $execute = oci_execute($parse); if ($execute) { oci_commit($conn); $status_update = true; } else { oci_rollback($conn); $status_update = false . oci_error(); } return $status_update; }
public function insert($sql) { $this->last_query = $sql; $this->stid = oci_parse($this->connection, $sql); oci_bind_by_name($this->stid, ":ID", $id, 32); $result = oci_execute($this->stid); $this->affected_rows_value = oci_num_rows($this->stid); $committed = oci_commit($this->connection); //$commited, result from commit currently not analyzed, space for improvement if ($result) { return $id; } else { return -1; } }
public function ajouterContenu($id_fichier, $contenu) { $sql = "INSERT INTO CONTENU(ID_FICHIER,CONTENU) VALUES ({$id_fichier}, EMPTY_CLOB())\n RETURNING CONTENU INTO :CONTENU_loc"; $conn = oci_connect("DBA_PARAPHEUR", "12345678", "XE"); $stmt = oci_parse($conn, $sql); // Creates an "empty" OCI-Lob object to bind to the locator $clob = oci_new_descriptor($conn, OCI_D_LOB); // Bind the returned Oracle LOB locator to the PHP LOB object oci_bind_by_name($stmt, ":CONTENU_loc", $clob, -1, OCI_B_CLOB); // Execute the statement using , OCI_DEFAULT - as a transaction oci_execute($stmt, OCI_DEFAULT) or die("Unable to execute query\n"); // Now save a value to the clob if (!$clob->save($contenu)) { // On error, rollback the transaction oci_rollback($conn); } else { // On success, commit the transaction oci_commit($conn); } }
public function conectarse() { $Cn = oci_pconnect($this->udb, $this->pdb, $this->server, 'AL32UTF8'); if (!$Cn) { $e = oci_error(); trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR); return "noconex"; } else { $qry = oci_parse($Cn, "alter session set NLS_TERRITORY='SPAIN'"); $qry = oci_execute($qry); @oci_commit($Cn); $qry = oci_parse($Cn, "alter session set NLS_DATE_FORMAT='DD-MM-YYYY HH24:MI:SS'"); $qry = oci_execute($qry, OCI_DEFAULT); @oci_commit($Cn); $qry = oci_parse($Cn, "alter session set NLS_TIMESTAMP_FORMAT='DD-MM-YYYY HH24:MI:SS'"); $qry = oci_execute($qry, OCI_DEFAULT); @oci_commit($Cn); /* $qry = oci_parse($Cn, "alter session set NLS_NUMERIC_CHARACTERS='.,'"); $qry = oci_execute($qry, OCI_DEFAULT); @oci_commit($Cn);*/ return $Cn; } //by Robyir }
function oracle_query($query, $connection) { $resultMessage = ""; $resultSet = null; $result = 0; $sth = oci_parse($connection, $query); if (!$sth) { //error de parseo. $e = oci_error($connection); $resultSet = null; error_log($query . ": " . htmlentities($e['message']), 0); return -1; } //echo $query; $results = oci_execute($sth, OCI_DEFAULT); if (!$results) { //error de ejecuci�n. $e = oci_error($sth); error_log($query . ":- " . htmlentities($e['message']), 0); return -1; } oci_commit($connection); return $sth; }
/** * Executes a query against connected database. * Rises SqlQueryException on any database error. * <p> * When object $trackerQuery passed then calls its startQuery and finishQuery * methods before and after query execution. * * @param string $sql Sql query. * @param array $binds Array of binds. * @param \Bitrix\Main\Diag\SqlTrackerQuery $trackerQuery Debug collector object. * * @return resource * @throws \Bitrix\Main\Db\SqlQueryException */ protected function queryInternal($sql, array $binds = null, \Bitrix\Main\Diag\SqlTrackerQuery $trackerQuery = null) { $this->connectInternal(); if ($trackerQuery != null) { $trackerQuery->startQuery($sql, $binds); } $result = oci_parse($this->resource, $sql); if (!$result) { if ($trackerQuery != null) { $trackerQuery->finishQuery(); } throw new SqlQueryException("", $this->getErrorMessage($this->resource), $sql); } $executionMode = $this->transaction; /** @var \OCI_Lob[] $clob */ $clob = array(); if (!empty($binds)) { $executionMode = OCI_DEFAULT; foreach ($binds as $key => $val) { $clob[$key] = oci_new_descriptor($this->resource, OCI_DTYPE_LOB); oci_bind_by_name($result, ":" . $key, $clob[$key], -1, OCI_B_CLOB); } } if (!oci_execute($result, $executionMode)) { if ($trackerQuery != null) { $trackerQuery->finishQuery(); } throw new SqlQueryException("", $this->getErrorMessage($result), $sql); } if (!empty($binds)) { if (oci_num_rows($result) > 0) { foreach ($binds as $key => $val) { if ($clob[$key]) { $clob[$key]->save($binds[$key]); } } } if ($this->transaction == OCI_COMMIT_ON_SUCCESS) { oci_commit($this->resource); } foreach ($binds as $key => $val) { if ($clob[$key]) { $clob[$key]->free(); } } } if ($trackerQuery != null) { $trackerQuery->finishQuery(); } $this->lastQueryResult = $result; return $result; }
public function commit_transaction() { oci_commit($this->connection); }
/** * Commit Transaction * * @return bool */ public function trans_commit() { if (!$this->trans_enabled) { return TRUE; } // When transactions are nested we only begin/commit/rollback the outermost ones if ($this->_trans_depth > 0) { return TRUE; } $this->commit_mode = OCI_COMMIT_ON_SUCCESS; return oci_commit($this->conn_id); }
function update($table, $values, $conds, $fname = 'DatabaseOracle::update', $options = array()) { global $wgContLang; $table = $this->tableName($table); $opts = $this->makeUpdateOptions($options); $sql = "UPDATE {$opts} {$table} SET "; $first = true; foreach ($values as $col => &$val) { $sqlSet = $this->fieldBindStatement($table, $col, $val, true); if (!$first) { $sqlSet = ', ' . $sqlSet; } else { $first = false; } $sql .= $sqlSet; } if ($conds !== array() && $conds !== '*') { $conds = $this->wrapConditionsForWhere($table, $conds); $sql .= ' WHERE ' . $this->makeList($conds, LIST_AND); } if (($this->mLastResult = $stmt = oci_parse($this->mConn, $sql)) === false) { $e = oci_error($this->mConn); $this->reportQueryError($e['message'], $e['code'], $sql, __METHOD__); return false; } foreach ($values as $col => &$val) { $col_info = $this->fieldInfoMulti($table, $col); $col_type = $col_info != false ? $col_info->type() : 'CONSTANT'; if ($val === null) { // do nothing ... null was inserted in statement creation } elseif ($col_type != 'BLOB' && $col_type != 'CLOB') { if (is_object($val)) { $val = $val->getData(); } if (preg_match('/^timestamp.*/i', $col_type) == 1 && strtolower($val) == 'infinity') { $val = '31-12-2030 12:00:00.000000'; } $val = $wgContLang != null ? $wgContLang->checkTitleEncoding($val) : $val; if (oci_bind_by_name($stmt, ":{$col}", $val) === false) { $e = oci_error($stmt); $this->reportQueryError($e['message'], $e['code'], $sql, __METHOD__); return false; } } else { if (($lob[$col] = oci_new_descriptor($this->mConn, OCI_D_LOB)) === false) { $e = oci_error($stmt); throw new DBUnexpectedError($this, "Cannot create LOB descriptor: " . $e['message']); } if ($col_type == 'BLOB') { $lob[$col]->writeTemporary($val); oci_bind_by_name($stmt, ":{$col}", $lob[$col], -1, SQLT_BLOB); } else { $lob[$col]->writeTemporary($val); oci_bind_by_name($stmt, ":{$col}", $lob[$col], -1, OCI_B_CLOB); } } } wfSuppressWarnings(); if (oci_execute($stmt, $this->execFlags()) === false) { $e = oci_error($stmt); if (!$this->ignore_DUP_VAL_ON_INDEX || $e['code'] != '1') { $this->reportQueryError($e['message'], $e['code'], $sql, __METHOD__); return false; } else { $this->mAffectedRows = oci_num_rows($stmt); } } else { $this->mAffectedRows = oci_num_rows($stmt); } wfRestoreWarnings(); if (isset($lob)) { foreach ($lob as $lob_v) { $lob_v->free(); } } if (!$this->mTrxLevel) { oci_commit($this->mConn); } oci_free_statement($stmt); }
/** * Makes sure each database and extension handles BEGIN, COMMIT and ROLLBACK * * @param string &$sql The SQL to check for a transaction query * @param string $result_class The type of result object to create * @return mixed `FALSE` if normal processing should continue, otherwise an object of the type $result_class */ private function handleTransactionQueries(&$sql, $result_class) { // SQL Server supports transactions, but starts then with BEGIN TRANSACTION if ($this->type == 'mssql' && preg_match('#^\\s*(begin|start(\\s+transaction)?)\\s*#i', $sql)) { $sql = 'BEGIN TRANSACTION'; } $begin = FALSE; $commit = FALSE; $rollback = FALSE; // Track transactions since most databases don't support nesting if (preg_match('#^\\s*(begin|start)(\\s+(transaction|work))?\\s*$#iD', $sql)) { if ($this->inside_transaction) { throw new fProgrammerException('A transaction is already in progress'); } $this->inside_transaction = TRUE; $begin = TRUE; } elseif (preg_match('#^\\s*(commit)(\\s+(transaction|work))?\\s*$#iD', $sql)) { if (!$this->inside_transaction) { throw new fProgrammerException('There is no transaction in progress'); } $this->inside_transaction = FALSE; $commit = TRUE; } elseif (preg_match('#^\\s*(rollback)(\\s+(transaction|work))?\\s*$#iD', $sql)) { if (!$this->inside_transaction) { throw new fProgrammerException('There is no transaction in progress'); } $this->inside_transaction = FALSE; $rollback = TRUE; } if (!$begin && !$commit && !$rollback) { return FALSE; } // The PDO, OCI8 and SQLSRV extensions require special handling through methods and functions $is_pdo = $this->extension == 'pdo'; $is_oci = $this->extension == 'oci8'; $is_sqlsrv = $this->extension == 'sqlsrv'; $is_ibm_db2 = $this->extension == 'ibm_db2'; if (!$is_pdo && !$is_oci && !$is_sqlsrv && !$is_ibm_db2) { return FALSE; } $this->statement = $sql; // PDO seems to act weird if you try to start transactions through a normal query call if ($is_pdo) { try { $is_mssql = $this->type == 'mssql' && substr($this->database, 0, 4) != 'dsn:'; $is_oracle = $this->type == 'oracle' && substr($this->database, 0, 4) != 'dsn:'; if ($begin) { // The SQL Server PDO object hasn't implemented transactions if ($is_mssql) { $this->connection->exec('BEGIN TRANSACTION'); } elseif ($is_oracle) { $this->connection->setAttribute(PDO::ATTR_AUTOCOMMIT, FALSE); } else { $this->connection->beginTransaction(); } } elseif ($commit) { if ($is_mssql) { $this->connection->exec('COMMIT'); } elseif ($is_oracle) { $this->connection->exec('COMMIT'); $this->connection->setAttribute(PDO::ATTR_AUTOCOMMIT, TRUE); } else { $this->connection->commit(); } } elseif ($rollback) { if ($is_mssql) { $this->connection->exec('ROLLBACK'); } elseif ($is_oracle) { $this->connection->exec('ROLLBACK'); $this->connection->setAttribute(PDO::ATTR_AUTOCOMMIT, TRUE); } else { $this->connection->rollBack(); } } } catch (Exception $e) { $db_type_map = array('db2' => 'DB2', 'mssql' => 'MSSQL', 'mysql' => 'MySQL', 'oracle' => 'Oracle', 'postgresql' => 'PostgreSQL', 'sqlite' => 'SQLite'); throw new fSQLException('%1$s error (%2$s) in %3$s', $db_type_map[$this->type], $e->getMessage(), $sql); } } elseif ($is_oci) { if ($commit) { oci_commit($this->connection); } elseif ($rollback) { oci_rollback($this->connection); } } elseif ($is_sqlsrv) { if ($begin) { sqlsrv_begin_transaction($this->connection); } elseif ($commit) { sqlsrv_commit($this->connection); } elseif ($rollback) { sqlsrv_rollback($this->connection); } } elseif ($is_ibm_db2) { if ($begin) { db2_autocommit($this->connection, FALSE); } elseif ($commit) { db2_commit($this->connection); db2_autocommit($this->connection, TRUE); } elseif ($rollback) { db2_rollback($this->connection); db2_autocommit($this->connection, TRUE); } } if ($result_class) { $result = new $result_class($this); $result->setSQL($sql); $result->setResult(TRUE); return $result; } return TRUE; }
$sql = "UPDATE MD_PROC_DELAY_REMS SET REMS = '{$REMS}',ENTRY_SIGN = '{$username}' WHERE HEAD_MARK = '{$HM}' AND ID='{$HMID}' AND ENTRY_DATE = TO_DATE('{$REMS_DT}','MM/DD/YYYY') AND PROC_TYPE = '{$PROC_TYP}' AND PROC_SUB_TYPE = '{$PROC_SUB_TYP}'"; $parse = oci_parse($conn, $sql); oci_execute($parse); if ($parse) { oci_commit($conn); echo "success"; } else { oci_rollback($conn); echo "failed"; } } else { $sql = "INSERT INTO MD_PROC_DELAY_REMS(HEAD_MARK,ID,REMS,ENTRY_DATE,ENTRY_SIGN,PROC_TYPE,PROC_SUB_TYPE) values ('{$HM}','{$HMID}','{$REMS}',TO_DATE('{$REMS_DT}','MM/DD/YYYY'),'{$username}','{$PROC_TYP}','{$PROC_SUB_TYP}')"; $parse = oci_parse($conn, $sql); oci_execute($parse); if ($parse) { oci_commit($conn); echo "success"; } else { oci_rollback($conn); echo "failed"; } } break; case 'show_md_remaks': $HM = $_POST['HM']; $HMID = $_POST['HMID']; $PROC_TYP = $_POST['PROC_TYP']; $PROC_SUB_TYP = $_POST['PROC_SUB_TYP']; $title = $_POST['title']; ?> <table class="table-bordered compact" width="100%">
/** * Commit a transaction and return to autocommit mode. * * @return void * @throws Zend_Db_Adapter_Oracle_Exception */ protected function _commit() { if (!oci_commit($this->_connection)) { /** * @see Zend_Db_Adapter_Oracle_Exception */ require_once 'Zend/Db/Adapter/Oracle/Exception.php'; throw new Zend_Db_Adapter_Oracle_Exception(oci_error($this->_connection)); } $this->_setExecuteMode(OCI_COMMIT_ON_SUCCESS); }
/** * Commit a transaction and return to autocommit mode. * * @return void * @throws Zend_Db_Adapter_Oracle_Exception */ protected function _commit() { if (!oci_commit($this->_connection)) { throw new Zend_Db_Adapter_Oracle_Exception(oci_error($this->_connection)); } $this->_setExecuteMode(OCI_COMMIT_ON_SUCCESS); }
/** * Ends a successful operation by committing the transaction * @return void */ public function transactionCommit() { oci_commit($this->linkDB); $this->bitTxOpen = false; }
/** * Commit Transaction * * @return bool */ protected function _trans_commit() { $this->commit_mode = OCI_COMMIT_ON_SUCCESS; return oci_commit($this->conn_id); }
/** * Commit a transaction * * @return void */ public function commit() { return @oci_commit($this->connection); }
public function registrar2(Denuncia $data, FiscEmpresa $empresa) { $this->conex = DataBase::getInstance(); /*Consultar Empresa*/ $id_empresa = $empresa->__GET('id_fisc_empresa'); $consulta_empresa = "SELECT * FROM FISC_EMPRESA WHERE ID_FISC_EMPRESA= '" . $id_empresa . "'"; $compemp = oci_parse($this->conex, $consulta_empresa); if (!$compemp) { return false; } $exemp = oci_execute($compemp); if (!$exemp) { return false; } $empresa_result = oci_fetch_assoc($compemp); /*Consultar Empresa*/ /*Verificar existencia de empresa*/ if (!isset($empresa_result['ID_EMPRESA'])) { /*Insertando en la tabla FISC_EMPRESA*/ $id_emp = $empresa->__GET('id_fisc_empresa'); $rif = $empresa->__GET('rif_fisc_empresa'); $nombre = $empresa->__GET('nombre_fisc_empresa'); $telefono = $empresa->__GET('telefono_fisc_empresa'); $email = $empresa->__GET('email_fisc_empresa'); $direccion = $empresa->__GET('direccion_fisc_empresa'); $referencia = $empresa->__GET('punto_ref_fisc_empresa'); $denuncias = 1; //clave foranea de tabla denuncia $fiscalizaciones = 3; //clave foranea de tabla fiscalizaciones $consulta = "INSERT INTO FISC_EMPRESA (\n\t\t\t\tID_FISC_EMPRESA, \n\t\t\t\tRIF_FISC_EMPRESA,\n\t\t\t\tNOMBRE_FISC_EMPRESA, \n\t\t\t\tTELEFONO_FISC_EMPRESA, \n\t\t\t\tEMAIL_FISC_EMPRESA, \n\t\t\t\tDIRECCION_FISC_EMPRESA, \n\t\t\t\tDENUNCIAS_FISC_EMPRESA, \n\t\t\t\tPUNTO_REF_FISC_EMPRESA, \n\t\t\t\tFISCALIZACIONES_FISC_EMPRESA)\nvalues\n(\n\t:id_emp,\n\t:rif_emp,\n\t:nombre, \n\t:telefono,\n\t:email,\n\t:direccion,\n\t:denuncias,\n\t:ref,\n\t:fiscalizaciones\n\t)"; $stid = oci_parse($this->conex, $consulta); if (!$stid) { echo "Desde el parse 1"; $e = oci_error($this->conex); trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR); //Libera los recursos oci_free_statement($stid); // Cierra la conexión Oracle oci_close($this->conex); return false; } oci_bind_by_name($stid, ':id_emp', $id_emp); oci_bind_by_name($stid, ':rif_emp', $rif); oci_bind_by_name($stid, ':nombre', $nombre); oci_bind_by_name($stid, ':telefono', $telefono); oci_bind_by_name($stid, ':email', $email); oci_bind_by_name($stid, ':direccion', $direccion); oci_bind_by_name($stid, ':denuncias', $denuncias); oci_bind_by_name($stid, ':ref', $referencia); oci_bind_by_name($stid, ':fiscalizaciones', $fiscalizaciones); $r = oci_execute($stid, OCI_NO_AUTO_COMMIT); if (!$r) { echo "Desde el execute 1"; $e = oci_error($this->conex); trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR); //Revertimos los cambios //oci_rollback($this->conex); //Libera los recursos oci_free_statement($stid); // Cierra la conexión Oracle oci_close($this->conex); return false; } /*Insertando en la tabla FISC_EMPRESA*/ } /*Verificar existencia de empresa*/ /*Insertando en la tabla FISC_APODERADO*/ $id_den = $data->__GET('id_denuncia'); $id_ciu = $data->__GET('id_ciudadano'); $motivo = $data->__GET('motivo_denuncia'); $sts = $data->__GET('estatus_denuncia'); $fecha = $data->__GET('fecha_denuncia'); $rif = $data->__GET('rif'); $descripcion = $data->__GET('descripcion'); $responsable = $data->__GET('responsable'); //$apoderado = $data->__GET('apoderado'); $consulta = "INSERT INTO FISC_APODERADO(\n\tid_denuncia,\n\tid_ciudadano,\n\trif,\n\tmotivo_denuncia,\n\testatus_denuncia,\n\tfecha_denuncia,\n\tdescripcion, \n\tresponsable)\nvalues (\n\t:id_den,\n\t:id_ciu,\n\t:rif,\n\t:mot,\n\t:sts,\n\t:fec,\n\t:descrip,\n\t:responsable)"; $stid = oci_parse($this->conex, $consulta); /*values ( :id_den,:id_ciu,:rif,:mot,:sts, :fec,:descrp,:creator,:upd)");*/ if (!$stid) { echo "Desde el parse 2"; $e = oci_error($this->conex); trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR); //$e = oci_error($this->conex); //trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR); //Libera los recursos oci_free_statement($stid); // Cierra la conexión Oracle oci_close($this->conex); return false; } // Realizar la lógica de la consulta oci_bind_by_name($stid, ':id_den', $id_den); oci_bind_by_name($stid, ':id_ciu', $id_ciu); oci_bind_by_name($stid, ':rif', $rif); oci_bind_by_name($stid, ':mot', $motivo); oci_bind_by_name($stid, ':sts', $sts); oci_bind_by_name($stid, ':fec', $fecha); oci_bind_by_name($stid, ':descrip', $descripcion); oci_bind_by_name($stid, ':responsable', $responsable); //oci_bind_by_name($stid, ':apoderado', $apoderado); /* oci_bind_by_name($stid, ':creator', $data->__GET('createdby')); oci_bind_by_name($stid, ':updater', $data->__GET('updatedby')); oci_bind_by_name($stid, ':upd', $data->__GET('updatedate')); */ $r = oci_execute($stid, OCI_NO_AUTO_COMMIT); if (!$r) { echo "Desde el execute 2"; $e = oci_error($this->conex); trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR); //Revertimos los cambios oci_rollback($this->conex); //Libera los recursos oci_free_statement($stid); // Cierra la conexión Oracle oci_close($this->conex); return false; } //Libera los recursos oci_free_statement($stid); /*Insertando en la tabla FISC_APODERADO*/ //No ocurrió ningún fallo al insertar los datos de la denuncia /*Insertando en la tabla FISC_DOCUMENTOS $documentos = $data->__GET('documentos'); //$error = false; for($i=0;$i<count($documentos);$i++) { $consulta = "INSERT INTO FISC_DOC_DEN( id_denuncia, id_documento) values ( :id_den,:id_doc)"; $stid = oci_parse($this->conex, $consulta); if (!$stid) { echo "Desde el parse 3"; $e = oci_error($this->conex); trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR); oci_rollback($this->conex); //$error = true; //self::eliminar($id_den); //$e = oci_error($this->conex); //trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR); //Libera los recursos oci_free_statement($stid); // Cierra la conexión Oracle oci_close($this->conex); return false; } oci_bind_by_name($stid, ':id_den', $id_den); oci_bind_by_name($stid, ':id_doc', $documentos[$i]); $r = oci_execute($stid, OCI_NO_AUTO_COMMIT); if (!$r) { echo "Desde el execute 3"; $e = oci_error($this->conex); trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR); //$error = true; //self::eliminar($id_den); oci_rollback($this->conex); //$e = oci_error($stid); //trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR); //Libera los recursos oci_free_statement($stid); // Cierra la conexión Oracle oci_close($this->conex); return false; } } Insertando en la tabla FISC_DOCUMENTOS*/ //Verificar existencia de Apoderado /* if( !isset($apoderado_result['ID_APODERADO'])) { //Insertando en la tabla FISC_APODERADO $nombres_apoderado = $data->__GET('nombres_apoderado'); $apellidos_apoderado = $data->__GET('apellidos_apoderado'); $consulta = "INSERT INTO FISC_APODERADO( id_apoderado, nombres_apoderado, apellidos_apoderado) values ( :id_apo, :name_apo, :ape_apo)"; $stid_apo = oci_parse($this->conex, $consulta); if (!$stid_apo) { echo "Desde el parse 4"; $e = oci_error($this->conex); trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR); oci_rollback($this->conex); //$error = true; //self::eliminar($id_den); //$e = oci_error($this->conex); //trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR); //Libera los recursos oci_free_statement($stid); // Cierra la conexión Oracle oci_close($this->conex); return false; } oci_bind_by_name($stid_apo, ':id_apo', $id_apoderado); oci_bind_by_name($stid_apo, ':name_apo', $nombres_apoderado); oci_bind_by_name($stid_apo, ':ape_apo', $apellidos_apoderado); $execute_apo = oci_execute($stid_apo, OCI_NO_AUTO_COMMIT); if (!$execute_apo) { echo "Desde el execute 4"; $e = oci_error($this->conex); trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR); //$error = true; //self::eliminar($id_den); oci_rollback($this->conex); //$e = oci_error($stid); //trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR); //Libera los recursos oci_free_statement($stid); // Cierra la conexión Oracle oci_close($this->conex); return false; } //Insertando en la tabla FISC_APODERADO }//Verificar existencia de Apoderado */ $r = oci_commit($this->conex); if (!$r) { oci_close($this->conex); return false; } // Cierra la conexión Oracle oci_close($this->conex); return true; }