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);
}
