protected function getSingleResult($sql) { $statement = oci_parse($this->connection, $sql); oci_execute($statement); if ($result = oci_fetch_assoc($statement)) { oci_free_statement($statement); return $result; } else { oci_free_statement($statement); return NULL; } }
function dispCart() { $cartLen = count($_SESSION['cart']); if ($cartLen < 1) { echo 'You have no items in your cart.<br><a href="main.php">Keep shopping</a><br>'; die; } //for loop to iterate through cart items for ($i = 0; $i < $cartLen; $i++) { if ($cartLen > 0) { $newconn = conndb(); //sql $s = oci_parse($newconn, "select * from PRODUCT where PRODUCTID=:pid_prefix"); $plook = $_SESSION['cart'][$i]['productid']; oci_bind_by_name($s, ':pid_prefix', $plook); oci_execute($s); //fetch a single row depending on product id $res = oci_fetch_assoc($s); echo "Product name: ", $res['PRODUCTNAME'], " Price: ", $res['PRODUCTPRICE']; echo '<a href="cart.php?del=' . $i . '"> Remove item</a><br>'; } } if ($cartLen > 0) { echo '<a href="checkout.php">Proceed to checkout</a><br>'; } }
function afficher_produit($is_fruit) { if ($is_fruit) { $requete = "SELECT * FROM Produits WHERE `fruit`=1"; } else { $requete = "SELECT * FROM Produits WHERE `fruit`=0"; } $idcom = connex("Myparam"); $stmt = oci_parse($idcom, $requete); $result = oci_execute($result, OCI_DEFAULT); if (!$result) { echo "Lecture impossible"; } else { echo "<table cellspacing='0' cellpadding='5'>"; echo "<tr>"; echo "<th>Produit</th><th>Description</th><th>Stock</th><th>Prix</th><th>Quantité</th><th></th>"; echo "</tr>"; while ($ligne = oci_fetch_assoc($result)) { echo "<tr id='" . $ligne[0] . "'>"; echo "<td>" . $ligne[1] . "</td>"; echo "<td>" . $ligne[2] . "</td>"; echo "<td>" . $ligne[3] . "</td>"; echo "<td>" . $ligne[4] . "</td>"; echo "<td><select name='qte_v[]'>"; for ($i = 1; $i <= $ligne[3]; $i++) { echo "<option>" . $i . "</option>"; } echo "</select></td>"; echo '<td><button onclick="addProduit($(this));" class=bouton_produit>Ajouter au panier</button></td>'; echo "</tr>"; } echo "</table>"; } }
function addTransport() { global $con1; global $id; global $departmentId; global $transportTypeId; global $transportSubtypeId; global $model; global $gid; $query = "SELECT sq_request_all.nextval FROM DUAL"; $statement = oci_parse($con1, $query); if (oci_execute($statement, OCI_DEFAULT)) { $res = oci_fetch_assoc($statement); $id = $res["NEXTVAL"]; } else { $err = oci_error(); die("Не удалось получить индентификатор : " . $err[message]); echo false; } $query2 = "INSERT INTO TRANSPORT_ITEMS(ITEM_ID, ITEM_TITLE, ITEM_GID, DEP_ID, ITEM_TYPE_ID, ITEM_SUBTYPE_ID)\n VALUES({$id}, '{$model}', '{$gid}', {$departmentId}, {$transportTypeId}, {$transportSubtypeId})"; $statement2 = oci_parse($con1, $query2); if (oci_execute($statement2, OCI_COMMIT_ON_SUCCESS)) { $query3 = "SELECT * FROM TRANSPORT_ITEMS WHERE ITEM_ID = {$id}"; $statement3 = oci_parse($con1, $query3); if (oci_execute($statement3, OCI_DEFAULT)) { $transport = oci_fetch_assoc($statement3); echo json_encode($transport); } } else { $err = oci_error(); die("Не удалось добавить транспорт: " . $err[message]); echo "fail"; } }
public function Query($query_string, $params = null) { ++self::$query_count; $this->qid = $this->prepareSQL($query_string, $params); $result = oci_execute($this->qid); $this->row = 0; $this->selected_rows = null; $err = oci_error($this->qid); $this->error = $err['message']; $this->errno = $err['code']; if (oci_statement_type($this->qid) == 'SELECT') { $this->records = array(); $this->selected_rows = 0; $this->current_row = 0; while ($row = @oci_fetch_assoc($this->qid)) { $this->records[] = $row; ++$this->selected_rows; } } if (!$result) { throw new Exception('Invalid query: ' . $query_string . ': ' . $this->error, $this->errno); } //if return $result; }
function getUserForID($userId) { $user = new User(); ini_set('display_errors', 'On'); $db = "w4111c.cs.columbia.edu:1521/adb"; $conn = oci_connect("kpg2108", "test123", $db); $stmt = oci_parse($conn, "select * from users where user_Id='" . $userId . "'"); $rows = oci_execute($stmt); oci_close($conn); while ($row = oci_fetch_assoc($stmt)) { echo $row['LOGIN_ID']; $user->setUserId($row['USER_ID']); $user->setPassword($row['PASSWORD']); $user->setFirstName($row['FNAME']); $user->setLastName($row['LNAME']); $user->setLoginId($row['LOGIN_ID']); $user->setEmailId($row['EMAIL_ID']); $user->setAddress($row['ADDRESS']); $user->setPhoneNumber($row['PHONE_NO']); $user->setSecurityAnswer($row['ANSWER']); $user->setSecurityQuestion($row['QUESTION']); $user->setMiles($row['MILES']); } return $user; }
public function fetchAssoc() { set_error_handler(static::getErrorHandler()); $row = oci_fetch_assoc($this->resource); restore_error_handler(); return $row; }
public function get_next($res) { $data = oci_fetch_assoc($res); if (array_key_exists("VALUE", $data)) { $data["value"] = $data["VALUE"]; } return $data; }
protected function fetchDateFormat() { $sql = "select value from v\$nls_parameters where parameter = 'NLS_DATE_FORMAT'"; $query = oci_parse($this->conn->getResource(), $sql); oci_execute($query); $row = oci_fetch_assoc($query); oci_free_statement($query); return $row['VALUE']; }
function cari_tgl_pengangkatan($nid) { $sql = "SELECT HIRE_DATE\n\t\t\tFROM " . $USERPAYROLL . ".EMP_DETAIL \n\t\t\tWHERE NID = '{$nid}'\n\t\t\t"; $stmt = oci_parse($conn, $sql) or die("Query gagal"); oci_execute($stmt); $row = oci_fetch_assoc($stmt); $tgl = $row['HIRE_DATE']; return $tgl; }
private function fetch_next() { if ($row = oci_fetch_assoc($this->stmt)) { $row = array_change_key_case($row, CASE_LOWER); unset($row['oracle_rownum']); array_walk($row, array('oci_native_moodle_database', 'onespace2empty')); } return $row; }
public function findOne($tSql, $sClassRow) { $pRs = $this->query($this->bind($tSql)); if (empty($pRs)) { return null; } $tRow = oci_fetch_assoc($pRs); $oRow = new $sClassRow($tRow); return $oRow; }
function count() { $stmt = clone $this; $stmt->sql = "SELECT COUNT(*) AS THEROWC FROM ({$this->sql})"; $stmt->hasChanged = true; $queryId = $stmt->execute(); $row = oci_fetch_assoc($queryId); $stmt->free(); return $row['THEROWC']; }
public function get_next($res) { $data = oci_fetch_assoc($res); if ($data) { foreach ($data as $k => $v) { $data[strtolower($k)] = $v; } } return $data; }
function AchatProduit() { $conn = oci_connect("SYSTEM", "azerty", "//localhost/XE"); $select_stmt2 = "SELECT * FROM ALEXIS.AUTEUR"; $stid = oci_parse($conn, $select_stmt2); $result = oci_execute($stid); while ($ligne2 = oci_fetch_assoc($stid)) { echo '<li><a href="#">' . $ligne2['PRENOM_AUTEUR'] . " " . $ligne2["NOM_AUTEUR"] . "</a></li>"; } oci_free_statement($stid); }
public function fetch_row() { if ($this->flags['fetch_all_rows']) { return false; } if ($this->num_fields) { $this->flags['fetch_row']++; return oci_fetch_assoc($this->resource); } return false; }
function loadTables() { if ($this->isExisting) { $config = $this->connection->getConfig(); $schema = strtoupper($config['user']); $result = $this->connection->execute("SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER = '{$schema}'"); while ($row = oci_fetch_assoc($result)) { $this->tables[strtolower($row['TABLE_NAME'])] = 1; } oci_free_statement($result); $this->isTablesLoaded = true; } }
/** * @throws SQLException * @return void */ protected function initTables() { include_once 'creole/drivers/oracle/metadata/OCI8TableInfo.php'; $sql = "SELECT table_name\n FROM all_tables\n WHERE owner = '{$this->schema}'"; $statement = @oci_parse($this->conn->getResource(), $sql); $success = @oci_execute($statement, OCI_DEFAULT); if (!$success) { throw new SQLException("Could not get tables", $this->conn->getResource()->nativeError($statement)); } while ($statement && ($row = oci_fetch_assoc($statement))) { $row = array_change_key_case($row, CASE_LOWER); $this->tables[strtoupper($row['table_name'])] = new OCI8TableInfo($this, $row['table_name']); } }
function getIVal($col, $from, $where, $debug = false) { global $mysqli; if ($debug === true) { echo "<pre>SELECT {$col} FROM {$from} WHERE {$where}</pre>"; } //$result = oci_parse("SELECT $col FROM $from WHERE $where"); $result = oci_parse($GLOBALS['conn'], "SELECT {$col} FROM {$from} WHERE {$where}"); oci_execute($result); if ($result == null) { return null; } $row = oci_fetch_assoc($result); return $row[0]; }
public function execute() { if (!oci_execute($this->_cursor)) { require_once 'Zend/Db/Cursor/Exception.php'; throw new Zend_Db_Cursor_Exception('Couldn\'t execute the cursor.'); } // Cursor is ready to go while ($data = oci_fetch_assoc($this->_cursor)) { require_once 'Zend/Db/Cursor/Row.php'; $row = new Zend_Db_Cursor_Row(); foreach ($data as $key => $value) { $row->{$key} = $value; } $this->pushRow($row); } }
function dispCart() { $total = 0; //Price total of shopping cart. $cartLen = count($_SESSION['cart']); if ($cartLen < 1) { echo 'You have no items in your cart.<br><a href="main.php">Keep shopping</a><br>'; die; } //for loop to iterate through cart items for ($i = 0; $i < $cartLen; $i++) { if ($cartLen > 0) { $newconn = conndb(); /* *** A1 - Injection attacks, converted all SQL statments to include binding/placeholders to prevent injection attacks. * */ $s = oci_parse($newconn, "select * from PRODUCT where PRODUCTID=:pid_prefix"); $plook = $_SESSION['cart'][$i]['productid']; oci_bind_by_name($s, ':pid_prefix', $plook); oci_execute($s); //fetch a single row depending on product id $res = oci_fetch_assoc($s); //quantity update $qty_ = $_SESSION['cart'][$i]['qty']; $price_ = $res['PRODUCTPRICE']; //display cart total $total_ = $qty_ * $price_; $total += $total_; if ($res) { echo '<form name="form2" method="get">'; echo "Product name: ", $res['PRODUCTNAME'], " Price: ", number_format($res['PRODUCTPRICE'], 2, '.', ''); echo '<a href="cart.php?del=' . $i . '"> Remove item</a><br>'; echo "</form>"; } } } //add the cart total to the session array and display total //setlocale(LC_MONETARY, 'en_AUS'); $_SESSION['cart'][0]['total'] = $total; $cartTotal = $_SESSION['cart'][0]['total']; $cartTotal = number_format($cartTotal, 2, '.', ''); echo "<br>Your cart total is \${$cartTotal}<br>"; if ($cartLen > 0) { echo '<a href="payment_page.php">Proceed to checkout</a><br>'; } }
function getPAGEID() { $usera = ''; $passa = ''; $servera = ''; $ca = oci_connect($usera, $passa, $servera); $getStory = "SELECT max(TO_NUMBER(PAGEID)) as PAGEID FROM pages"; $storyg = oci_parse($ca, $getStory); oci_execute($storyg); $rows = array(); //Loop through each while ($r = oci_fetch_assoc($storyg)) { $PAGEID = $r['PAGEID']; $PAGEID++; return $PAGEID; } oci_close($ca); }
public function export($query, $outputTable, $incremental = false, $primaryKey = null) { $outFilename = tempnam("/tmp/ex-db", $outputTable) . ".csv"; $csv = new CsvFile($outFilename); $this->logger->info("Exporting to " . $outputTable); try { $stmt = oci_parse($this->conn, $query); oci_execute($stmt); } catch (\Exception $e) { throw new DbException("DB query failed: " . $e->getMessage(), $e); } // write header and first line try { $resultRow = oci_fetch_assoc($stmt); } catch (\Exception $e) { throw new DbException("DB query fetch failed: " . $e->getMessage(), $e); } if (is_array($resultRow) && !empty($resultRow)) { $csv->writeRow(array_keys($resultRow)); if (isset($this->dbConfig['null'])) { $resultRow = $this->replaceNull($resultRow, $this->dbConfig['null']); } $resultRow = str_replace('""', '"', $resultRow); $csv->writeRow($resultRow); // write the rest try { while ($resultRow = oci_fetch_assoc($stmt)) { if (isset($this->dbConfig['null'])) { $resultRow = $this->replaceNull($resultRow, $this->dbConfig['null']); } $resultRow = str_replace('""', '"', $resultRow); $csv->writeRow($resultRow); } } catch (\Exception $e) { throw new DbException("DB query fetch failed: " . $e->getMessage(), $e); } if (!count($csv->getHeader())) { throw new ApplicationException("Trying to upload an empty file"); } $this->writeTable($csv, $outputTable, $incremental, $primaryKey); } else { $this->logger->warning("Query returned empty result. Nothing was imported."); } }
/** * @group database */ public function testLogging() { $startTime = microtime(true) - 1000; $sql = "select * from dual"; $bindVariablesString = ":one => 1, :test => 'test'"; $this->logger->log($startTime, $sql, $bindVariablesString); // check if record was inserted $conn = new \Oracle\Connection('test'); $sql = "select count(*) amount from web_query_log where bind_vars = ':one => 1, :test => ''test''' and ip is null and start_time > trunc(sysdate)"; $resource = oci_parse($conn->getResource(), $sql); oci_execute($resource); $row = oci_fetch_assoc($resource); oci_free_statement($resource); $this->assertGreaterThan(0, $row['AMOUNT']); // remove this log record for the next test $sql = "delete from web_query_log where bind_vars = ':one => 1, :test => ''test''' and ip is null and start_time > trunc(sysdate)"; $resource = oci_parse($conn->getResource(), $sql); oci_execute($resource); oci_free_statement($resource); }
/** * Result - associative array * * Returns the result set as an array * * @return array */ protected function _fetch_assoc() { $id = $this->curs_id ? $this->curs_id : $this->stmt_id; return oci_fetch_assoc($id); }
foreach ($datatypes as $name => $prefix) { if (isset($_GET[$prefix])) { } } echo "</td></tr></table>"; draw_pager($url, $total_pages, $page, "index.php"); // Run table echo "<table class='runs'>"; if ($ndisplay == 0) { echo "<tr>"; foreach ($runselect_headers as $db_handle => $head) { echo "<th>{$head}</th>"; } echo "</tr>"; } while ($run = oci_fetch_assoc($stmt)) { // Run Header if ($ndisplay > 0) { echo "<tr>"; foreach ($runselect_headers as $db_handle => $head) { echo "<th>{$head}</th>"; } echo "</tr>"; } // Run data rows echo "<tr>"; foreach ($runselect_headers as $db_handle => $head) { if ($db_handle == 'RUN_NUM') { echo "<td class='run_num' rowspan='", $ndisplay + 1, "'>"; } else { echo "<td>";
exit; } $conn = oci_pconnect(ORA_CON_UN, ORA_CON_PW, ORA_CON_DB); $username = htmlentities($_SESSION['username'], ENT_QUOTES); switch ($_POST['action']) { case "change_job": $array_subjob = array(); $job = $_POST['job']; $subjobSql = "SELECT DISTINCT PROJECT_NAME, PROJECT_NAME_NEW FROM VW_SHOW_OPNAME_PRC WHERE PROJECT_NO = '{$job}' ORDER BY PROJECT_NAME"; $subjobParse = oci_parse($conn, $subjobSql); oci_execute($subjobParse); while ($row = oci_fetch_assoc($subjobParse)) { array_push($array_subjob, $row); } echo json_encode($array_subjob); break; case "change_subjob": $array_subcont = array(); $job = $_POST['job']; $subjob = $_POST['subjob']; $subcontSql = "SELECT DISTINCT SUBCONT_ID FROM VW_SHOW_OPNAME_PRC WHERE PROJECT_NO = '{$job}' AND PROJECT_NAME = '{$subjob}' AND SUBCONT_ID IS NOT NULL ORDER BY SUBCONT_ID"; $subcontParse = oci_parse($conn, $subcontSql); oci_execute($subcontParse); while ($row = oci_fetch_assoc($subcontParse)) { array_push($array_subcont, $row); } echo json_encode($array_subcont); break; default: break; }
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; }
<?php if ($conn = oci_connect('ggarg', 'AnkurGarg2008', 'oracle.cise.ufl.edu:1521/orcl')) { } else { die("could not connect to foo"); } // mysql_select_db($database_connect, $connect); // $sql2 = mysql_query(,$connect); $sql2 = oci_parse($connect, "select /*+ index_desc(product PRODSALE_IDX) */ * from product where QTYSOLD is not null and rownum < 4"); oci_define_by_name($sql2, "Name", $Name2); oci_define_by_name($sql2, "Type", $Type2); oci_define_by_name($sql2, "IMAGE", $image2); oci_define_by_name($sql2, "Price", $price2); oci_define_by_name($sql2, "Prodid", $Prodid); oci_execute($sql2); $dyn_table2 = '<tr>'; while ($row = oci_fetch_assoc($sql2)) { $dyn_table2 .= '<p><td><tr><tr><br>' . $Name2 . '</tr>'; $dyn_table2 .= '<br>' . $Type2 . '<br>'; $dyn_table2 .= '<br><a href="productdetail.php?Prodid=' . $Prodid . '"><img src="' . $image2 . '" width = 100, height = 100/></a><br/>'; $dyn_table2 .= '<br><center><strong>Price: Rs.' . $price2 . '</strong></center><br>'; $dyn_table2 .= '<form name="formx" id="formx" method="post" action="cart.php"><input type="hidden" name="Prodid" id="Prodid" value="' . $Prodid . '" /> <input type="image" src="images/templatemo_addtocart.png" name="add to cart" align="left"/><a href="productdetail.php?Prodid=' . $Prodid . '"><img src="images/templatemo_detail.png" height="21.5" align="right"></a></form></td></tr></p><br><br><br><br><br>'; } $dyn_table2 .= '</tr></table>'; ?> <div class="sidebar_box"><span class="bottom"></span> <h3><a class="sidebar_box_icon" title="image" rel="nofollow" target="_blank"><img src="images/templatemo_sidebar_header.png" alt="image" title="image" /></a>Bestsellers </h3> <div class="content"> <div class="bs_box"> <?php echo $dyn_table2;
public function testRunOracle() { $writerData = $this->prepareConfig('oracle'); $testing = $this->container->getParameter('testing'); $this->configuration->updateTable($this->writerId, $testing['table']['id'], ['dbName' => 'keboola.dummy']); $dbParams = $testing['oracle']['db']; $dbString = '//' . $dbParams['host'] . ':' . $dbParams['port'] . '/' . $dbParams['database']; $conn = oci_connect($dbParams['user'], $dbParams['password'], $dbString, 'AL32UTF8'); try { oci_execute("DROP TABLE keboola.dummy"); } catch (\Exception $e) { // table doesn't exist } $this->write($writerData['id']); $stid = oci_parse($conn, "SELECT * FROM keboola.dummy"); oci_execute($stid); $result = []; while ($res = oci_fetch_assoc($stid)) { $result[] = array_values($res); } $sapiData = $this->storageApi->exportTable($testing['table']['id']); $sapiDataArr = Table::csvStringToArray($sapiData); $sapiDataArrFinal = []; unset($sapiDataArr[0]); foreach ($sapiDataArr as $row) { unset($row[3]); $sapiDataArrFinal[] = array_values($row); } $this->assertEquals($sapiDataArrFinal, $result); }