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