/**
Execute an SQL query.
@param $sQueryString The query string
@return weeDatabaseDummyResult Only with SELECT queries: an object for results handling
*/
protected function doQuery($sQueryString)
{
$rStatement = oci_parse($this->rLink, $sQueryString);
$rStatement !== false or burn('DatabaseException', sprintf(_WT("Failed to parse the query with the following error:\n%s"), array_value(oci_error($this->rLink), 'message')));
// oci_execute triggers a warning when the statement could not be executed.
@oci_execute($rStatement, OCI_DEFAULT) or burn('DatabaseException', sprintf(_WT("Failed to execute the query with the following error:\n%s"), array_value(oci_error($rStatement), 'message')));
$this->iNumAffectedRows = oci_num_rows($rStatement);
if (oci_num_fields($rStatement) > 0) {
// TODO: Check whether the silence operator is really required here.
@oci_fetch_all($rStatement, $aRows, 0, -1, OCI_ASSOC | OCI_FETCHSTATEMENT_BY_ROW);
return new weeDatabaseDummyResult($aRows);
}
}
function cargarArray($FUPE_CD_PROMOTOR, $FUPE_FE_ESTADO_DESDE, $FUPE_FE_ESTADO_HASTA, $queries)
{
include dirname(__FILE__) . '/conectar_ORACLE.php';
//echo $queries.";<br /><br />";
$array = array();
$query = oci_parse($c, $queries);
oci_execute($query);
$error = 0;
$ncols = oci_num_fields($query);
$cont = 0;
$j = 0;
$k = 0;
while ($row = oci_fetch_array($query, OCI_BOTH + OCI_RETURN_NULLS)) {
while ($cont < $ncols) {
$array[$j][$cont] = $row[$cont];
$cont++;
}
$cont = 0;
$k = 0;
$j++;
}
if (oci_num_rows($query) == 0) {
return false;
} else {
return $array;
}
}
function cargarArray($sentencia)
{
include dirname(__FILE__) . '/conectar_ORACLE.php';
$array = array();
$sentenciaExec = oci_parse($c, $sentencia);
oci_execute($sentenciaExec);
$error = 0;
$k = 0;
$ncols = oci_num_fields($sentenciaExec);
for ($i = 1; $i <= $ncols; ++$i) {
$colname = oci_field_name($sentenciaExec, $i);
$array[0][$k] = $colname;
$k++;
}
$cont = 0;
$j = 1;
$k = 0;
while ($row = oci_fetch_array($sentenciaExec, OCI_BOTH + OCI_RETURN_NULLS)) {
while ($cont < $ncols) {
$array[$j][$cont] = $row[$cont];
$cont++;
}
$cont = 0;
$k = 0;
$j++;
}
if (oci_num_rows($sentenciaExec) == 0) {
oci_free_statement($sentenciaExec);
return false;
} else {
oci_free_statement($sentenciaExec);
return $array;
}
}
protected function _doExec($query)
{
if ($rs = $this->_doQuery($query)) {
return oci_num_rows($rs->id());
} else {
return 0;
}
}
/**
* @see ResultSet::getRecordCount()
*/
function getRecordCount()
{
$rows = oci_num_rows($this->result);
if ($rows === false) {
throw new SQLException('Error fetching num rows', $this->conn->nativeError($this->result));
}
return (int) $rows;
}
public function get_ams_student($student_id = NULL)
{
$conn = oci_connect('AMS_QUERIES', 'Oo_Hecha1_rohm3', '//192.168.170.171:1522/ACADEMIC');
if (!$conn) {
$e = oci_error();
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
} else {
if ($student_id == NULL) {
$sql = "SELECT * FROM GAOWNER.VIEW_STUDENT_DETAILS";
} else {
$sql = 'SELECT * FROM GAOWNER.VIEW_STUDENT_DETAILS WHERE STUDENT_NO LIKE \'%' . $student_id . '%\'';
}
$rs4 = oci_parse($conn, $sql);
oci_execute($rs4);
$rows = oci_num_rows($rs4);
$t = 0;
while (OCIFetch($rs4)) {
$t++;
$name1 = ociresult($rs4, "SURNAME");
$dob = ociresult($rs4, "DOB");
$gender = ociresult($rs4, "GENDER");
$oname1 = ociresult($rs4, "OTHER_NAMES");
$STUDENT_NO = ociresult($rs4, "STUDENT_NO");
$COURSES = ociresult($rs4, "COURSES");
$GUARDIAN_NAME1 = ociresult($rs4, "GUARDIAN_NAME");
$MOBILE_NO = ociresult($rs4, "MOBILE_NO");
$EMAIL = ociresult($rs4, "EMAIL");
$FACULTIES = ociresult($rs4, "FACULTIES");
// details to be saved
$name = str_replace("'", "", "{$name1}");
$oname = str_replace("'", "", "{$oname1}");
$GUARDIAN_NAME = str_replace("'", "", "{$GUARDIAN_NAME1}");
if (!empty($STUDENT_NO)) {
$exists = $this->student_exists($STUDENT_NO);
$data = array('title' => '', 'Surname' => $name, 'Other_names' => $oname, 'DOB' => $dob, 'contact' => $MOBILE_NO, 'gender' => $gender, 'student_Number' => $STUDENT_NO, 'courses' => $FACULTIES, 'GUARDIAN_NAME' => $GUARDIAN_NAME, 'faculty' => $FACULTIES);
if (!$exists) {
$this->db->insert('student', $data);
} else {
$this->db->where('student_Number', $STUDENT_NO);
$this->db->update('student', $data);
}
$date = date("Y-m-d H:i:s");
// data for patients patient date, visit type, strath number created by and modified by fields
if ($student_id != NULL) {
$patient_data = array('patient_number' => $this->create_patient_number(), 'patient_date' => $date, 'visit_type_id' => 1, 'strath_no' => $STUDENT_NO, 'created_by' => $this->session->userdata('personnel_id'), 'modified_by' => $this->session->userdata('personnel_id'));
$this->db->insert('patients', $patient_data);
return $this->db->insert_id();
}
} else {
$this->session->set_userdata("error_message", "Student could not be found");
return FALSE;
}
}
if ($student_id != NULL) {
return TRUE;
}
}
}
/**
* 执行一个SQL语句
*
* @param sql 需要执行的SQL语句
*/
public function exec($sql)
{
$this->arrSql[] = $sql;
$result = oci_parse($this->conn, $sql);
if (!oci_execute($result)) {
$e = oci_error($result);
spError("{$sql}<br />执行错误: " . strip_tags($e['message']));
}
$this->num_rows = oci_num_rows($result);
return $result;
}
public function exec(&$statement)
{
$result =& $this->temp_result;
if (($result = oci_parse($this->link, $statement)) && @oci_execute($result, $this->autocommit ? OCI_COMMIT_ON_SUCCESS : OCI_DEFAULT)) {
if ('SELECT' == oci_statement_type($result)) {
oci_free_statement($result);
$result = null;
return 0;
}
$rows = oci_num_rows($result);
$result = null;
return $rows;
}
return false;
}
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;
}
}
$descripcionArray[$i][1] = $row[1];
$descripcionArray[$i][2] = 0;
if (in_array($descripcionArray[$i][0], $FILTRO)) {
$descripcionArray[$i][2] = 1;
}
$sentencia = traerSentencia($FE_ESTADO_DESDE, $FE_ESTADO_HASTA, $OWNER, $TABLA_SENTENCIA, $TABLA_CONSULTAR, $TABLA_TITULOS, $i, $SELECT);
// Ejecuto el package que hace cada query y la almaceno en $sentencia.
$sentenciaArray = "sentenciaArray_" . $i;
if (isset($sentencia)) {
${$sentenciaArray} = cargarArray($sentencia);
// Le paso la sentencia, la ejecuto y la guardo en el array con nombre dinamico.
}
//echo $sentencia.";<br />\n\n";
$i++;
}
$cant = oci_num_rows($countTablaExec);
oci_free_statement($countTablaExec);
echo "<input type=\"hidden\" value=\"{$FE_ESTADO_DESDE}\" id=\"FE_ESTADO_DESDE\" />\n\t<input type=\"hidden\" value=\"{$FE_ESTADO_HASTA}\" id=\"FE_ESTADO_HASTA\" />\n\t<input type=\"hidden\" value=\"{$TABLAS}\" id=\"TABLAS\" />\n\t<input type=\"hidden\" value=\"{$OWNER}\" id=\"OWNER\" />\n\t<input type=\"hidden\" value=\"{$SELECT}\" id=\"SELECT\" />\n\t<input type=\"hidden\" value=\"{$NRO_SENTENCIA}\" id=\"NRO_SENTENCIA\" />\n\t<input type=\"hidden\" value=\"{$TABLA_TITULOS}\" id=\"TABLA_TITULOS\" />\n\t\n\t\n\t<div class='container'>\n\t<div class='sixteen columns'>\n\t\t<div id='page-title'>\n\t\t\t<h2>{$TIPO}</h2>\n\t\t\t<div id='bolded-line'></div>\n\t\t</div>\n\t</div>\n\t</div>\n\t<div class='container'>\n\t\t<div class='sixteen columns'>\n\t\t\t<div class='field'>\n\t\t\t\t<input type=\"button\" id=\"boton_descargar_control\" onclick=\"tableroControlMotivosIncidencias()\" value=\"Descargar {$TIPO} (Excel)\"/>\n\t\t\t</div>\n\t\t</div>\n\t\t<div class='sixteen columns'>\n\t\t\t\t<h3>Periodo entre el {$FE_ESTADO_DESDE} y el {$FE_ESTADO_HASTA}</h3>\n\t\t</div>\n\t</div>\n\t<div class='container'>";
echo "<div class='sixteen columns'>";
echo "<h3><a href=\"tableroControl_motivosIncidencias.php\">Volver Atrás</a></h3>";
echo "<table class='standard-table'>";
echo "<tr><th><b>Descripcion</b></th><th><b>Cantidad</b></th>";
echo "<th><b>Ver mas</b></th></tr>";
//$esControlProximo = false;
for ($i = 1; $i <= $cant; $i++) {
$esControl = false;
$esControlProximo = false;
if (strpos($descripcionArray[$i][1], 'Control ') !== false || strpos($descripcionArray[$i][1], 'Gestion Digital') !== false) {
$esControl = true;
}
if ($descripcionArray[$i][2] or $esControl) {
/**
* Execute Queries for Oracle Database
*
* @param type $sql
* @param type $connection
*/
function executeQueryOci($sql, $connection, $aParameter = array())
{
$aDNS = $connection->getDSN();
$sUsername = $aDNS["username"];
$sPassword = $aDNS["password"];
$sHostspec = $aDNS["hostspec"];
$sDatabse = $aDNS["database"];
$sPort = $aDNS["port"];
if ($sPort != "1521") {
// if not default port
$conn = oci_connect($sUsername, $sPassword, $sHostspec . ":" . $sPort . "/" . $sDatabse);
} else {
$conn = oci_connect($sUsername, $sPassword, $sHostspec . "/" . $sDatabse);
}
if (!$conn) {
$e = oci_error();
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
return $e;
}
switch (true) {
case preg_match("/^(SELECT|SHOW|DESCRIBE|DESC|WITH)\\s/i", $sql):
$stid = oci_parse($conn, $sql);
if (count($aParameter) > 0) {
foreach ($aParameter as $key => $val) {
oci_bind_by_name($stid, $key, $val);
}
}
oci_execute($stid, OCI_DEFAULT);
$result = array();
$i = 1;
while ($row = oci_fetch_array($stid, OCI_ASSOC + OCI_RETURN_NULLS)) {
$result[$i++] = $row;
}
oci_free_statement($stid);
oci_close($conn);
return $result;
break;
case preg_match("/^(INSERT|UPDATE|DELETE)\\s/i", $sql):
$stid = oci_parse($conn, $sql);
$isValid = true;
if (count($aParameter) > 0) {
foreach ($aParameter as $key => $val) {
oci_bind_by_name($stid, $key, $val);
}
}
$objExecute = oci_execute($stid, OCI_DEFAULT);
$result = oci_num_rows($stid);
if ($objExecute) {
oci_commit($conn);
} else {
oci_rollback($conn);
$isValid = false;
}
oci_free_statement($stid);
oci_close($conn);
if ($isValid) {
return $result;
} else {
return oci_error();
}
break;
default:
// Stored procedures
$stid = oci_parse($conn, $sql);
$aParameterRet = array();
if (count($aParameter) > 0) {
foreach ($aParameter as $key => $val) {
$aParameterRet[$key] = $val;
// The third parameter ($aParameterRet[$key]) returned a value by reference.
oci_bind_by_name($stid, $key, $aParameterRet[$key]);
}
}
$objExecute = oci_execute($stid, OCI_DEFAULT);
oci_free_statement($stid);
oci_close($conn);
return $aParameterRet;
break;
}
}
/**
* Affected Rows
*
* @return int
*/
public function affected_rows()
{
return oci_num_rows($this->stmt_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);
}
/**
* Número de Filas afectadas en un insert, update ó delete
*
* @param resource $resultQuery
* @return int
*/
function affected_rows($resultQuery = '')
{
if (!$this->id_connection) {
return false;
}
if (!$resultQuery) {
$resultQuery = $this->last_result_query;
if (!$resultQuery) {
return false;
}
}
if (($numberRows = oci_num_rows($resultQuery)) !== false) {
return $numberRows;
} else {
throw new KumbiaException($this->error('Resource invalido para db::affected_rows'));
}
return false;
}
/**
+----------------------------------------------------------
* 执行语句
+----------------------------------------------------------
* @access public
+----------------------------------------------------------
* @param string $str sql指令
+----------------------------------------------------------
* @return integer
+----------------------------------------------------------
* @throws ThinkExecption
+----------------------------------------------------------
*/
public function execute($str)
{
$this->initConnect(true);
if (!$this->_linkID) {
return false;
}
$this->queryStr = $str;
// 判断新增操作
$flag = false;
if (preg_match("/^\\s*(INSERT\\s+INTO)\\s+(\\w+)\\s+/i", $this->queryStr, $match)) {
$this->table = C("DB_SEQUENCE_PREFIX") . str_ireplace(C("DB_PREFIX"), "", $match[2]);
$flag = (bool) $this->query("SELECT * FROM user_sequences WHERE sequence_name='" . strtoupper($this->table) . "'");
}
//modify by wyfeng at 2009.08.28
//更改事务模式
$this->mode = OCI_COMMIT_ON_SUCCESS;
//释放前次的查询结果
if ($this->queryID) {
$this->free();
}
$this->W(1);
$stmt = oci_parse($this->_linkID, $str);
$this->debug();
if (false === oci_execute($stmt)) {
$this->error();
return false;
} else {
$this->numRows = oci_num_rows($stmt);
$this->lastInsID = $flag ? $this->insert_last_id() : 0;
//modify by wyfeng at 2009.08.28
return $this->numRows;
}
}
//filter
$connect1 = oci_connect($username_connect, $password_connect, $database_connect);
//$sqldd = "SELECT * from product WHERE (Name LIKE '%Music%' OR Type LIKE '%Music%' )and rownum < 20 ";
$query1 = oci_parse($connect1, "SELECT * from product WHERE ( Name LIKE '%{$searchq}%' OR Type LIKE '%{$searchq}%' ) and rownum < 20");
// $query = mysql_query("SELECT * from product WHERE Name LIKE '%$searchq%' OR Type LIKE '%$searchq%'") or die("could not search");
// print( "654654 SELECT * from product WHERE Name LIKE '%$searchq%' OR Type LIKE '%$searchq%'");
// exit;
//$count = mysql_num_rows($query);
oci_define_by_name($query1, "Name", $Name1);
oci_define_by_name($query1, "Type", $Type1);
oci_define_by_name($query1, "IMAGE", $image1);
oci_define_by_name($query1, "Prodid", $Prodid1);
oci_define_by_name($query1, "Quantity", $qty1);
oci_define_by_name($query1, "SALEPRICE", $price1);
oci_execute($query1);
$Count1 = oci_num_rows($query1);
print "SELECT * from product WHERE Name LIKE '%{$searchq}%' OR Type LIKE '%{$searchq}%'";
// print($Count1);
// exit;
// if ($Count1==0)
// {
// $output= 'There was no search results!';
//}else {;
$output = '<table border="0" cellpadding="10"><tr>';
while (oci_fetch($query1)) {
/*
$Name = $row["Name"];
$Type = $row["Type"];
$image=$row["prod_image"];
$Prodid = $row["Prodid"];
$qty = $row["Quantity"];
/**
* Returns the number of rows affected by the execution of the
* last INSERT, DELETE, or UPDATE statement executed by this
* statement object.
*
* @return int The number of rows affected.
* @throws \Zend\Db\Statement\Exception
*/
public function rowCount()
{
if (!$this->_stmt) {
return false;
}
$num_rows = oci_num_rows($this->_stmt);
if ($num_rows === false) {
throw new OracleException(oci_error($this->_stmt));
}
return $num_rows;
}
while ($row = oci_fetch_assoc($hasil)) {
array_push($arr, $row);
}
echo json_encode($arr);
break;
case "viewHeadMark":
$SubContId = $_GET['valSubContId__'];
$query = " SELECT HEAD_MARK, PROJECT_NAME , ID\r\n FROM vw_fab_info\r\n WHERE fab_status = 'NOTCOMPLETE' AND SUBCONT_ID = '{$SubContId}'\r\n ORDER BY HEAD_MARK ASC";
$hasil = oci_parse($conn, $query);
oci_execute($hasil);
$r = oci_num_rows($hasil);
$arr = array();
while ($row = oci_fetch_assoc($hasil)) {
array_push($arr, $row);
}
echo json_encode($arr);
break;
case "viewQty":
$head_mark = $_GET['hm__'];
$id_subcont = $_GET['id'];
$query = "select * from fabrication WHERE HEAD_MARK = '{$head_mark}' AND ID ='{$id_subcont}'";
$hasil = oci_parse($conn, $query);
oci_execute($hasil);
$r = oci_num_rows($hasil);
$arr = array();
while ($row = oci_fetch_assoc($hasil)) {
array_push($arr, $row);
}
echo json_encode($arr);
break;
}
/**
* Gets the number of rows affected by the data manipulation
* query.
*
* @return int Number of rows affected by the last query.
* @todo -cOCI8Connection Figure out whether getUpdateCount() should throw exception on error or just return 0.
*/
function getUpdateCount()
{
if (!$this->lastStmt) {
return 0;
}
$result = oci_num_rows($this->lastStmt);
if ($result === false) {
throw new SQLException('Update count failed', $this->nativeError($this->lastStmt));
}
return $result;
}
function sql_num_rows($sqltype, $result)
{
if ($sqltype == 'mysql') {
if (class_exists('mysqli_result')) {
return $result->mysqli_num_rows;
} elseif (function_exists('mysql_num_rows')) {
return mysql_num_rows($result);
}
} elseif ($sqltype == 'mssql') {
if (function_exists('sqlsrv_num_rows')) {
return sqlsrv_num_rows($result);
} elseif (function_exists('mssql_num_rows')) {
return mssql_num_rows($result);
}
} elseif ($sqltype == 'pgsql') {
return pg_num_rows($result);
} elseif ($sqltype == 'oracle') {
return oci_num_rows($result);
} elseif ($sqltype == 'sqlite3') {
$metadata = $result->fetchArray();
if (is_array($metadata)) {
return $metadata['count'];
}
} elseif ($sqltype == 'sqlite') {
return sqlite_num_rows($result);
} elseif ($sqltype == 'odbc') {
return odbc_num_rows($result);
} elseif ($sqltype == 'pdo') {
return $result->rowCount();
}
}
$NUM_COL = 0;
$NUM_HREF = 0;
echo "<div class='sixteen columns'>";
echo "<table class='standard-table'>";
$ncols = oci_num_fields($query1);
echo "<tr>\n";
for ($i = 1; $i <= $ncols; ++$i) {
$colname = oci_field_name($query1, $i);
echo " <th><b>" . htmlentities($colname, ENT_QUOTES) . "</b></th>\n";
}
echo "</tr>\n";
while ($row = oci_fetch_array($query1, OCI_BOTH + OCI_RETURN_NULLS)) {
//Genero las columnas dinamicamente
echo "<tr>";
while ($NUM_COL < $ncols) {
echo "<td>" . $row[$NUM_COL] . "</a></td>";
$NUM_COL++;
}
echo "</tr>";
$NUM_COL = 0;
$NUM_HREF++;
}
echo "<th> Registros: " . oci_num_rows($query1) . "</th>";
echo "</table>\n";
echo "</div>";
oci_free_statement($query1);
?>
</div>
</div>
<?php
include dirname(__FILE__) . "/footer.php";
<?php
include dirname(__FILE__) . "/header.php";
include dirname(__FILE__) . '/conectar_ORACLE.php';
$FUDS_CD_COD_SUCURSAL = $_REQUEST["FUDS_CD_COD_SUCURSAL"];
$FUDS_CD_FILIAL = strtoupper($_REQUEST["FUDS_CD_FILIAL"]);
$FUDS_CD_DOM = strtoupper($_REQUEST["FUDS_CD_DOMICILIO"]);
$FUDS_CD_DOMICILIO = str_replace("°", " ", strtoupper($FUDS_CD_DOM));
$FUDS_CD_LOCALIDAD = strtoupper($_REQUEST["FUDS_CD_LOCALIDAD"]);
$FUDS_CD_PROVINCIA = strtoupper($_REQUEST["FUDS_CD_PROVINCIA"]);
$FUDS_CD_COD_POSTAL = strtoupper($_REQUEST["FUDS_CD_COD_POSTAL"]);
$sucExistente = "SELECT * FROM CPI.DIR_SUCURSALES WHERE FUDS_CD_COD_SUCURSAL = {$FUDS_CD_COD_SUCURSAL}";
$sucExistentes = oci_parse($c, $sucExistente);
$error1 = @oci_execute($sucExistentes);
$row = oci_fetch_array($sucExistentes, OCI_BOTH + OCI_RETURN_NULLS);
$num_rows = oci_num_rows($sucExistentes);
if ($num_rows == 0) {
$STATE = 0;
$queryInsert = "BEGIN CPI.PKG_CHECK_SUCURSAL.PRC_INSERT_SUC (:FUDS_CD_COD_SUCURSAL, :FUDS_CD_FILIAL, :FUDS_CD_DOMICILIO, :FUDS_CD_LOCALIDAD, :FUDS_CD_PROVINCIA, :FUDS_CD_COD_POSTAL); END;";
$queryInsert1 = oci_parse($c, $queryInsert);
oci_bind_by_name($queryInsert1, ':FUDS_CD_COD_SUCURSAL', $FUDS_CD_COD_SUCURSAL);
oci_bind_by_name($queryInsert1, ':FUDS_CD_FILIAL', $FUDS_CD_FILIAL);
oci_bind_by_name($queryInsert1, ':FUDS_CD_DOMICILIO', $FUDS_CD_DOMICILIO);
oci_bind_by_name($queryInsert1, ':FUDS_CD_LOCALIDAD', $FUDS_CD_LOCALIDAD);
oci_bind_by_name($queryInsert1, ':FUDS_CD_PROVINCIA', $FUDS_CD_PROVINCIA);
oci_bind_by_name($queryInsert1, ':FUDS_CD_COD_POSTAL', $FUDS_CD_COD_POSTAL);
$error = @oci_execute($queryInsert1);
if (!$error) {
$e = oci_error($queryUpdate1);
$show = "\n\t\t<div class=\"container\">\n\t\t\t\t<div class=\"sixteen columns\">\n\t\t\t\t\t<h3>Error: " . $e['message'] . "</h3>\n\t\t\t\t</div>\n\t\t</div>";
}
<?php
include dirname(__FILE__) . "/header.php";
include dirname(__FILE__) . '/conectar_ORACLE.php';
$USUARIO = strtoupper($_REQUEST["USUARIO"]);
$query = "SELECT UPPER(USUARIO) FROM CPI.USUARIOS WHERE USUARIO='{$USUARIO}'";
$query1 = oci_parse($c, $query);
oci_execute($query1);
$row = oci_fetch_array($query1, OCI_BOTH + OCI_RETURN_NULLS);
$num_rows = oci_num_rows($query1);
if ($num_rows != 0) {
$STATE = 0;
$queryDelete = "DELETE FROM CPI.USUARIOS WHERE USUARIO='{$USUARIO}'";
$queryDelete1 = oci_parse($c, $queryDelete);
$error = @oci_execute($queryDelete1);
if (!$error) {
$e = oci_error($query1);
$show = "\n\t\t<div class=\"container\">\n\t\t\t\t<div class=\"sixteen columns\">\n\t\t\t\t\t<h3>Error: " . $e['message'] . "</h3>\n\t\t\t\t</div>\n\t\t</div>";
}
} else {
$STATE = 1;
}
?>
<div class="container">
<div class="sixteen columns">
<div id="page-title">
<h2>Baja de Usuarios</h2>
<div id="bolded-line"></div>
</div>
</div>
</div>
/**
* Get the number of affected rows
*
* @return int number of rows
*/
public function rowCount()
{
set_error_handler(array($this->_pdooci, "errorHandler"));
$rows = null;
try {
$rows = \oci_num_rows($this->_stmt);
} catch (\Exception $e) {
throw new \PDOException($e->getMessage());
}
restore_error_handler();
return $rows;
}
/**
* {@inheritdoc}
*/
public function rowCount()
{
return oci_num_rows($this->_sth);
}
echo $m['message'], "\n";
exit;
}
?>
<?php
$query = "SELECT * FROM DB_STAFF";
$parseRequest = oci_parse($conn, $query);
oci_execute($parseRequest);
$SID = array();
$ROLE = array();
$SALARY = array();
$EXP = array();
$index = 0;
while ($row = oci_fetch_array($parseRequest, OCI_RETURN_NULLS + OCI_ASSOC)) {
$index = oci_num_rows($parseRequest);
$SID[$index - 1] = $row['S_ID'];
$ROLE[$index - 1] = $row['ROLE'];
$SALARY[$index - 1] = $row['SALARY'];
$EXP[$index - 1] = $row['EXP'];
//$data{$index-1}{0} = $row['M_NAME'];
//$data{$index-1}{1} = $row['PRICE'];
}
//echo $data[0][0] . "PRICE : " . $data[0][1] . "<br>";
//echo $data[1][0] . "PRICE : " . $data[1][1]. "<br>";
//echo $data[2][0] . "PRICE : " . $data[2][1]. "<br>";
oci_close($conn);
?>
<form action='Staff_edit.php' method='post'>
<h1>Staff</h1>
/**
* Sets the number of rows affected by the query
*
* @param fResult $result The result object for the query
* @param mixed $resource Only applicable for `ibm_db2`, `pdo`, `oci8` and `sqlsrv` extentions or `mysqli` prepared statements - this is either the `PDOStatement` object, `mysqli_stmt` object or the `oci8` or `sqlsrv` resource
* @return void
*/
private function setAffectedRows($result, $resource = NULL)
{
if ($this->extension == 'ibm_db2') {
$insert_update_delete = preg_match('#^\\s*(INSERT|UPDATE|DELETE)\\b#i', $result->getSQL());
$result->setAffectedRows(!$insert_update_delete ? 0 : db2_num_rows($resource));
} elseif ($this->extension == 'mssql') {
$affected_rows_result = mssql_query('SELECT @@ROWCOUNT AS rows', $this->connection);
$result->setAffectedRows((int) mssql_result($affected_rows_result, 0, 'rows'));
} elseif ($this->extension == 'mysql') {
$result->setAffectedRows(mysql_affected_rows($this->connection));
} elseif ($this->extension == 'mysqli') {
if (is_object($resource)) {
$result->setAffectedRows($resource->affected_rows);
} else {
$result->setAffectedRows(mysqli_affected_rows($this->connection));
}
} elseif ($this->extension == 'oci8') {
$result->setAffectedRows(oci_num_rows($resource));
} elseif ($this->extension == 'pgsql') {
$result->setAffectedRows(pg_affected_rows($result->getResult()));
} elseif ($this->extension == 'sqlite') {
$result->setAffectedRows(sqlite_changes($this->connection));
} elseif ($this->extension == 'sqlsrv') {
$result->setAffectedRows(sqlsrv_rows_affected($resource));
} elseif ($this->extension == 'pdo') {
// This fixes the fact that rowCount is not reset for non INSERT/UPDATE/DELETE statements
try {
if (!$resource || !$resource->fetch()) {
throw new PDOException();
}
$result->setAffectedRows(0);
} catch (PDOException $e) {
// The SQLite PDO driver seems to return 1 when no rows are returned from a SELECT statement
if ($this->type == 'sqlite' && $this->extension == 'pdo' && preg_match('#^\\s*SELECT#i', $result->getSQL())) {
$result->setAffectedRows(0);
} elseif (!$resource) {
$result->setAffectedRows(0);
} else {
$result->setAffectedRows($resource->rowCount());
}
}
}
}
font-family: "DilleniaUPC",Tahoma;
font-style: Bold;
margin: 4px 2px;
cursor: pointer;
}
</style>
</head>
<body>
<?php
if (isset($_POST['submit'])) {
$username = urlencode($_POST['username']);
$password = encode($_POST['password']);
$sql = "SELECT ID, NAME, USERNAME, PASSWORD, IS_ADMIN\n\t\t\t\t\t\t\tFROM CB_USERS\n\t\t\t\t\t\t\tWHERE USERNAME = '******' AND\n\t\t\t\t\t\t\t\tPASSWORD = '******' AND\n\t\t\t\t\t\t\t\tROWNUM = 1";
$parse = oci_parse($connection, $sql);
oci_execute($parse);
$numrows = oci_num_rows($parse);
$userdata = oci_fetch_array($parse);
if ($userdata) {
$_SESSION['user'] = array("id" => $userdata['ID'], "name" => $userdata['NAME'], "username" => $userdata['USERNAME'], "password" => $userdata['PASSWORD'], "admin" => yn2bool($userdata['IS_ADMIN']));
header("location: userpanel.php");
} else {
error("", "ชื่อผู้ใช้งานหรือรหัสผ่านผิด");
}
}
?>
<form action="signin.php?submit" method="post">
<div align="center">
<img src="images/bbanner.png">
<br>
<span style="cursor:default"><hhead>เข้าสู่ระบบ</hhead></span><br><br>
<span style="cursor:default"><loc>ชื่อผู้ใช้</loc></span>
/**
* Returns affected rows count from last executed query.
*
* @return integer
*/
public function getAffectedRowsCount()
{
return oci_num_rows($this->lastQueryResult);
}
function getAffectedRowCount()
{
if (is_resource($this->queryId)) {
return oci_num_rows($this->queryId);
}
}
