本文整理汇总了PHP中ociexecute函数的典型用法代码示例。如果您正苦于以下问题:PHP ociexecute函数的具体用法?PHP ociexecute怎么用?PHP ociexecute使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了ociexecute函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: query
function query($SQLCmd)
{
if (!$this->isConnect) {
return null;
}
$stmt = ociparse($this->connection, $SQLCmd);
ociexecute($stmt, OCI_DEFAULT);
$results = array();
oci_fetch_all($stmt, $results, 0, -1, OCI_FETCHSTATEMENT_BY_COLUMN);
$rs = new ResultSet();
$rs->setHolder($results);
oci_free_statement($stmt);
return $rs;
}
开发者ID:bryanbacus,项目名称:skripsi-martin,代码行数:14,代码来源:ORA8Access.php
示例2: OracleSelectQueryResult
/**
* Creates a new OracleSelectQueryResult object.
* Creates a new OracleSelectQueryResult object.
* @access public
* @param integer $resourceId The resource id for this SELECT query.
* @param integer $linkId The link identifier for the database connection.
* @return object OracleSelectQueryResult A new OracleSelectQueryResult object.
*/
function OracleSelectQueryResult($resourceId, $linkId)
{
// ** parameter validation
$resourceRule = ResourceValidatorRule::getRule();
ArgumentValidator::validate($resourceId, $resourceRule, true);
ArgumentValidator::validate($linkId, $resourceRule, true);
// ** end of parameter validation
$this->_resourceId = $resourceId;
$this->_linkId = $linkId;
$this->_currentRowIndex = 0;
$this->_currentRow = array();
$this->_currentRow[BOTH] = array();
$this->_currentRow[NUMERIC] = array();
$this->_currentRow[ASSOC] = array();
$this->_numRows = ocifetchstatement($this->_resourceId);
ociexecute($this->_resourceId);
// if we have at least one row in the result, fetch its array
if ($this->hasMoreRows()) {
ocifetchinto($this->_resourceId, $this->_currentRow[BOTH], OCI_ASSOC + OCI_NUM + OCI_RETURN_LOBS);
foreach ($this->_currentRow[BOTH] as $key => $value) {
if (is_int($key)) {
$this->_currentRow[NUMERIC][$key] = $value;
} else {
$this->_currentRow[ASSOC][$key] = $value;
}
}
}
}
开发者ID:adamfranco,项目名称:harmoni,代码行数:36,代码来源:OracleSelectQueryResult.class.php
示例3: insert_id
function insert_id($table)
{
$sql = "SELECT max(id) ID FROM {$table}";
$query = ociparse($this->conn, $sql);
ociexecute($query);
ocifetchinto($query, $row, OCI_BOTH);
return $row[ID];
}
开发者ID:pamcruz,项目名称:unimedjp,代码行数:8,代码来源:oracle.class.php
示例4: num_rows
/**
* Number of rows in the result set.
*
* Oracle doesn't have a graceful way to retun the number of rows
* so we have to use what amounts to a hack.
*
*
* @access public
* @return integer
*/
function num_rows()
{
$rowcount = count($this->result_array());
@ociexecute($this->stmt_id);
if ($this->curs_id) {
@ociexecute($this->curs_id);
}
return $rowcount;
}
开发者ID:nigelpeters,项目名称:css-recruitment-ee,代码行数:19,代码来源:oci8_result.php
示例5: realisateurParId
public static function realisateurParId($id)
{
$bd = new Mconnect();
$connect = $bd->getRessource();
$stmt = ociparse($connect, "select p.ID_PERS, p.NOM_PERS, p.PRENOM_PERS\r\t\t\t\t\t\t\t\t\tfrom PERSONNE p, REALISER r\r\t\t\t\t\t\t\t\t\tWHERE p.ID_PERS=r.ID_PERS\r\t\t\t\t\t\t\t\t\tAND r.ID_FILM='" . $id . "'");
ociexecute($stmt, OCI_DEFAULT);
$tab = Mutilitaire::tableau($stmt);
return $tab;
$bd->close();
}
开发者ID:googlecode-mirror,项目名称:projettuteurexml,代码行数:10,代码来源:Mpersonne.php
示例6: exec
/**
* Execute an SQL query
* @param String sql
*/
public function exec($sql)
{
$this->debugInfo($sql);
$stmt = ociparse($this->conn, $sql);
$stmt_type = ocistatementtype($stmt);
if (!ociexecute($stmt)) {
trigger_error($this->lastError(), E_USER_ERROR);
return 0;
}
return 1;
}
开发者ID:ryanblanchard,项目名称:Dashboard,代码行数:15,代码来源:OracleConnection.php
示例7: num_rows
/**
* Number of rows in the result set.
*
* Oracle doesn't have a graceful way to retun the number of rows
* so we have to use what amounts to a hack.
*
*
* @access public
* @return integer
*/
function num_rows()
{
if ($this->num_rows === 0 && count($this->result_array()) > 0) {
$this->num_rows = count($this->result_array());
@ociexecute($this->stmt_id);
if ($this->curs_id) {
@ociexecute($this->curs_id);
}
}
return $this->num_rows;
}
开发者ID:hack4reno2011,项目名称:get_instance--,代码行数:21,代码来源:oci8_result.php
示例8: ociparse
function &_doQuery($queryString)
{
$stmt = ociparse($this->_connection, $queryString);
if ($stmt && ociexecute($stmt)) {
$rs =& new CopixDbResultSetOci8($stmt);
$rs->_connector =& $this;
return $rs;
} else {
return false;
}
}
开发者ID:BackupTheBerlios,项目名称:phpaie,代码行数:11,代码来源:CopixDbConnection.oci8.class.php
示例9: select_genres
public function select_genres()
{
//Connexion à la base
$bd = new Mconnect();
$connect = $bd->getRessource();
$stmt = ociparse($connect, "select NOM_GENRE, ID_GENRE from GENRE ORDER BY NOM_GENRE");
//On parse la requête à effectuer sans oublier de lui passer la chaine de connexion en paramêtre
ociexecute($stmt, OCI_DEFAULT);
//On execute la requête en lui passant l'option OCI_DEFAULT
$bd->close();
$tab = Mutilitaire::tableau($stmt);
return $tab;
}
开发者ID:googlecode-mirror,项目名称:projettuteurexml,代码行数:13,代码来源:Mgenres.php
示例10: db_query
/**
* db_query() - Query the database
*
* NOTE - the OCI version of this may be somewhat inefficient
* for large result sets (hundreds or thousands of rows selected)
* However - most queries are returning 25-50 rows
*
* @param string SQL statement
* @param int How many rows do you want returned
* @param int Of matching rows, return only rows starting here
*/
function db_query($qstring, $limit = '-1', $offset = 0)
{
global $QUERY_COUNT, $sys_db_results, $sys_db_row_pointer, $sys_db_oci_commit_mode;
$QUERY_COUNT++;
$stmt = @ociparse($gfconn, $qstring);
if (!$stmt) {
return 0;
} else {
if ($limit > 0) {
if (!$offset || $offset < 0) {
$offset = 0;
}
}
$res = @ociexecute($stmt, $sys_db_oci_commit_mode);
if (!$res) {
return 0;
} else {
//if offset, seek to starting point
//potentially expensive if large offset
//however there is no data_seek feature AFAICT
$more_data = true;
if ($offset > 0) {
for ($i = 0; $i < $offset; $i++) {
//burn them off
@ocifetchinto($res, $x);
if (!$x[1]) {
//if no data be returned
//get out of loop
$more_data = false;
break;
}
}
}
$i = 0;
while ($more_data) {
$i++;
@ocifetchinto($res, $x, 'OCI_ASSOC+OCI_RETURN_NULLS+OCI_RETURN_LOBS');
$sys_db_results[$res][$i - 1] = $x;
//see if data is being returned && we are
//still within the requested $limit
if (count($x) < 1 || $limit > 0 && $i >= $limit) {
$more_data = false;
}
}
$sys_db_row_pointer[$res] = 0;
return $res;
}
}
}
开发者ID:neymanna,项目名称:fusionforge,代码行数:60,代码来源:database-oci8.php
示例11: query_exec
function query_exec($query)
{
# IMPORT MYSQL PARAMETERS (NOTE: IT WORKS WITH ABSOLUTE PATH ONLY !!)
include '../config/registry_oracle_db.php';
# open connection to db
//putenv("ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0");
$conn = OCILogOn($user_db, $password_db, $db) or die("Could not connect to Oracle database!") or die(ocierror());
# execute the EXEC query
$statement = ociparse($conn, $query);
$risultato = ociexecute($statement);
# close connection
ocilogoff($conn);
$a = 1;
return $a;
}
开发者ID:athoncopy,项目名称:athon,代码行数:15,代码来源:SVUOTA_REGISTRY_DB.php
示例12: db_exec
function db_exec($qstring,$conn)
{
global $strLastSQL,$dDebug;
if ($dDebug===true)
echo $qstring."<br>";
$strLastSQL=$qstring;
$stmt=ociparse($conn,$qstring);
$stmt_type=ocistatementtype($stmt);
if(!ociexecute($stmt))
{
trigger_error(db_error($conn), E_USER_ERROR);
return 0;
}
else
return 1;
}
开发者ID:helbertfurbino,项目名称:sgmofinanceiro,代码行数:16,代码来源:dbconnection.ora.php
示例13: batchProcess
public function batchProcess($batch_id, $username)
{
// $result = array();
$sql = " DECLARE " . " v_result VARCHAR2(90); " . " BEGIN " . " PKG_PROC_BATCH.proc_batch(:params1,:params2, :v_result); END;";
//$params = array($period, $username, $batch_type);
$params = array(array('name' => ':params1', 'value' => $batch_id, 'type' => SQLT_CHR, 'length' => 100), array('name' => ':params2', 'value' => $username, 'type' => SQLT_CHR, 'length' => 32));
// Bind the output parameter
$stmt = oci_parse($this->db->conn_id, $sql);
foreach ($params as $p) {
// Bind Input
oci_bind_by_name($stmt, $p['name'], $p['value'], $p['length']);
}
$message = '';
oci_bind_by_name($stmt, ':v_result', $message, 32);
ociexecute($stmt);
return $message;
}
开发者ID:wiliamdecosta,项目名称:channel_management,代码行数:17,代码来源:m_loaddata.php
示例14: query_oracle
function query_oracle($sql)
{
$db = get_oracle_db();
if (!$db) {
return false;
}
$r = oci_parse($db, $sql);
if ($r === false) {
return false;
}
$qresult = ociexecute($r);
if ($qresutl === false) {
return false;
}
//var_dump(oci_fetch_array($r));
//oci_fetch_all($r, $result);
return oci_fetch_array($r);
return $result;
}
开发者ID:sauger,项目名称:forbes_front,代码行数:19,代码来源:oracle_data_handler.php
示例15: db_query
function db_query($ASql, $AQueryType = 0)
{
global $conn;
$ASql = "/*" . $_SERVER['REMOTE_ADDR'] . ", " . $_SERVER['SCRIPT_FILENAME'] . ", " . date('d.m.Y H:i', time()) . "*/" . $ASql;
$result = oci_parse($conn, $ASql);
$return = array();
ociexecute($result, OCI_DEFAULT);
switch ($AQueryType) {
case 0:
$return = oci_fetch_array($result, OCI_ASSOC);
break;
case 1:
while ($row = oci_fetch_array($result, OCI_ASSOC)) {
$return[] = $row;
}
break;
}
return $return;
}
开发者ID:pinicilin2006,项目名称:osago,代码行数:19,代码来源:ibs_connector_2.php
示例16: ociparse
<?php
$sqlTotvsDA4010 = ociparse($totvsConexao, "SELECT DA4_FILIAL\r\n\t\t\t\t\t\t\t\t\t\t\t , DA4_COD\r\n\t\t\t\t\t\t\t\t\t\t\t\t , DA4_NOME\r\n\t\t\t\t\t\t\t\t\t\t\t , DA4_NREDUZ\r\n\t\t\t\t\t\t\t\t\t\t\t , DA4_END\r\n\t\t\t\t\t\t\t\t\t\t\t , DA4_BAIRRO\r\n\t\t\t\t\t\t\t\t\t\t\t , DA4_MUN\r\n\t\t\t\t\t\t\t\t\t\t\t , DA4_EST\r\n\t\t\t\t\t\t\t\t\t\t\t , DA4_CEP\r\n\t\t\t\t\t\t\t\t\t\t\t , DA4_CGC\r\n\t\t\t\t\t\t\t\t\t\t\t , DA4_TEL\r\n\t\t\t\t\t\t\t\t\t\t\t , DA4_BLQMOT\r\n\t\t\t\t\t\t\t\t\t\t\t , DA4_TRANPO\r\n\t\t\t\t\t\t\t\t\t\t\t , R_E_C_N_O_\r\n\t\t\t\t\t\t\t\t\t\t\t , D_E_L_E_T_\r\n\t\t\t\t\t\t\t\t\t\t\t FROM DA4010\r\n\t\t\t\t\t\t\t\t\t\t ORDER BY R_E_C_N_O_");
ociexecute($sqlTotvsDA4010);
while ($rowTotvsDA4010 = oci_fetch_array($sqlTotvsDA4010)) {
$sqlFatMotorista = mysql_query("SELECT null FROM tb_fat_motorista WHERE CO_RECNO = '" . $rowTotvsDA4010['R_E_C_N_O_'] . "'", $conexaoExtranet) or die(mysql_error());
if (mysql_num_rows($sqlFatMotorista) == 0) {
if (trim($rowTotvsDA4010['D_E_L_E_T_']) == '*') {
mysql_query("INSERT INTO tb_fat_motorista (CO_FILIAL\r\n\t\t\t\t\t\t\t , CO_MOTORISTA\r\n\t\t\t\t\t\t\t\t , NU_CPF_CNPJ\r\n\t\t\t\t\t\t\t\t , NO_MOTORISTA\r\n\t\t\t\t\t\t\t\t , NO_REDUZ_MOTORISTA\r\n\t\t\t\t\t\t\t\t , DS_ENDERECO\r\n\t\t\t\t\t\t\t\t , NO_BAIRRO\r\n\t\t\t\t\t\t\t\t , NO_MUNICIPIO\r\n\t\t\t\t\t\t\t\t , SG_UF\r\n\t\t\t\t\t\t\t\t , NU_CEP\r\n\t\t\t\t\t\t\t\t , NU_TEL\r\n\t\t\t\t\t\t\t\t , CO_TRANSPORTADORA\r\n\t\t\t\t\t\t\t\t , FL_BLOQUEADO\r\n\t\t\t\t\t\t\t\t , CO_RECNO\r\n\t\t\t\t\t\t\t\t , FL_DELET)\r\n\t\t\t\t\t\t\t VALUES('" . trim($rowTotvsDA4010['DA4_FILIAL']) . "' \r\n\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['DA4_COD']) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['DA4_CGC']) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsDA4010['DA4_NOME'])) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsDA4010['DA4_NREDUZ'])) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsDA4010['DA4_END'])) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsDA4010['DA4_BAIRRO'])) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsDA4010['DA4_MUN'])) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsDA4010['DA4_EST'])) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['DA4_CEP']) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['DA4_TEL']) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['DA4_TRANPO']) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['DA4_BLQMOT']) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['R_E_C_N_O_']) . "'\r\n\t\t\t\t\t\t\t\t , '*')", $conexaoExtranet) or die(mysql_error());
} else {
mysql_query("INSERT INTO tb_fat_motorista (CO_FILIAL\r\n\t\t\t\t\t\t\t , CO_MOTORISTA\r\n\t\t\t\t\t\t\t\t , NU_CPF_CNPJ\r\n\t\t\t\t\t\t\t\t , NO_MOTORISTA\r\n\t\t\t\t\t\t\t\t , NO_REDUZ_MOTORISTA\r\n\t\t\t\t\t\t\t\t , DS_ENDERECO\r\n\t\t\t\t\t\t\t\t , NO_BAIRRO\r\n\t\t\t\t\t\t\t\t , NO_MUNICIPIO\r\n\t\t\t\t\t\t\t\t , SG_UF\r\n\t\t\t\t\t\t\t\t , NU_CEP\r\n\t\t\t\t\t\t\t\t , NU_TEL\r\n\t\t\t\t\t\t\t\t , CO_TRANSPORTADORA\r\n\t\t\t\t\t\t\t\t , FL_BLOQUEADO\r\n\t\t\t\t\t\t\t\t , CO_RECNO)\r\n\t\t\t\t\t\t\t VALUES('" . trim($rowTotvsDA4010['DA4_FILIAL']) . "' \r\n\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['DA4_COD']) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['DA4_CGC']) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsDA4010['DA4_NOME'])) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsDA4010['DA4_NREDUZ'])) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsDA4010['DA4_END'])) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsDA4010['DA4_BAIRRO'])) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsDA4010['DA4_MUN'])) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsDA4010['DA4_EST'])) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['DA4_CEP']) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['DA4_TEL']) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['DA4_TRANPO']) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['DA4_BLQMOT']) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['R_E_C_N_O_']) . "')", $conexaoExtranet) or die(mysql_error());
}
} else {
if (trim($rowTotvsDA4010['D_E_L_E_T_']) == '*') {
mysql_query("UPDATE tb_fat_motorista SET\r\n\t\t\t\t\t\t\t CO_FILIAL = '" . trim($rowTotvsDA4010['DA4_FILIAL']) . "' \r\n\t\t\t\t\t\t\t\t , CO_MOTORISTA = '" . trim($rowTotvsDA4010['DA4_COD']) . "' \r\n\t\t\t\t\t\t\t\t , NU_CPF_CNPJ = '" . trim($rowTotvsDA4010['DA4_CGC']) . "' \r\n\t\t\t\t\t\t\t\t , NO_MOTORISTA = '" . trim(addslashes($rowTotvsDA4010['DA4_NOME'])) . "' \r\n\t\t\t\t\t\t\t\t , NO_REDUZ_MOTORISTA = '" . trim(addslashes($rowTotvsDA4010['DA4_NREDUZ'])) . "' \r\n\t\t\t\t\t\t\t\t , DS_ENDERECO = '" . trim(addslashes($rowTotvsDA4010['DA4_END'])) . "' \r\n\t\t\t\t\t\t\t\t , NO_BAIRRO = '" . trim(addslashes($rowTotvsDA4010['DA4_BAIRRO'])) . "' \r\n\t\t\t\t\t\t\t\t , NO_MUNICIPIO = '" . trim(addslashes($rowTotvsDA4010['DA4_MUN'])) . "' \r\n\t\t\t\t\t\t\t\t , SG_UF = '" . trim(addslashes($rowTotvsDA4010['DA4_EST'])) . "' \r\n\t\t\t\t\t\t\t\t , NU_CEP = '" . trim($rowTotvsDA4010['DA4_CEP']) . "' \r\n\t\t\t\t\t\t\t\t , NU_TEL = '" . trim($rowTotvsDA4010['DA4_TEL']) . "' \r\n\t\t\t\t\t\t\t\t , CO_TRANSPORTADORA = '" . trim($rowTotvsDA4010['DA4_TRANPO']) . "' \r\n\t\t\t\t\t\t\t\t , FL_BLOQUEADO = '" . trim($rowTotvsDA4010['DA4_BLQMOT']) . "' \r\n\t\t\t\t\t\t\t\t , FL_DELET = '*'\t\t\t\t\t \r\n\t\t\t\t\t\t\t WHERE CO_RECNO = '" . $rowTotvsDA4010['R_E_C_N_O_'] . "'", $conexaoExtranet) or die(mysql_error());
} else {
mysql_query("UPDATE tb_fat_motorista SET\r\n\t\t CO_FILIAL = '" . trim($rowTotvsDA4010['DA4_FILIAL']) . "' \r\n\t\t\t\t\t\t\t\t , CO_MOTORISTA = '" . trim($rowTotvsDA4010['DA4_COD']) . "' \r\n\t\t\t\t\t\t\t\t , NU_CPF_CNPJ = '" . trim($rowTotvsDA4010['DA4_CGC']) . "' \r\n\t\t\t\t\t\t\t\t , NO_MOTORISTA = '" . trim(addslashes($rowTotvsDA4010['DA4_NOME'])) . "' \r\n\t\t\t\t\t\t\t\t , NO_REDUZ_MOTORISTA = '" . trim(addslashes($rowTotvsDA4010['DA4_NREDUZ'])) . "' \r\n\t\t\t\t\t\t\t\t , DS_ENDERECO = '" . trim(addslashes($rowTotvsDA4010['DA4_END'])) . "' \r\n\t\t\t\t\t\t\t\t , NO_BAIRRO = '" . trim(addslashes($rowTotvsDA4010['DA4_BAIRRO'])) . "' \r\n\t\t\t\t\t\t\t\t , NO_MUNICIPIO = '" . trim(addslashes($rowTotvsDA4010['DA4_MUN'])) . "' \r\n\t\t\t\t\t\t\t\t , SG_UF = '" . trim(addslashes($rowTotvsDA4010['DA4_EST'])) . "' \r\n\t\t\t\t\t\t\t\t , NU_CEP = '" . trim($rowTotvsDA4010['DA4_CEP']) . "' \r\n\t\t\t\t\t\t\t\t , NU_TEL = '" . trim($rowTotvsDA4010['DA4_TEL']) . "' \r\n\t\t\t\t\t\t\t\t , CO_TRANSPORTADORA = '" . trim($rowTotvsDA4010['DA4_TRANPO']) . "' \r\n\t\t\t\t\t\t\t\t , FL_BLOQUEADO = '" . trim($rowTotvsDA4010['DA4_BLQMOT']) . "'\r\n\t\t\t\t\t\t\t WHERE CO_RECNO = '" . $rowTotvsDA4010['R_E_C_N_O_'] . "'", $conexaoExtranet) or die(mysql_error());
}
}
}
开发者ID:wtnj,项目名称:sincronismo-totvs-extranet,代码行数:19,代码来源:sincronismo_GERAL_DA4010.php
示例17: _sql_report
/**
* Build db-specific report
* @access private
*/
function _sql_report($mode, $query = '')
{
switch ($mode) {
case 'start':
$html_table = false;
// Grab a plan table, any will do
$sql = "SELECT table_name\n\t\t\t\t\tFROM USER_TABLES\n\t\t\t\t\tWHERE table_name LIKE '%PLAN_TABLE%'";
$stmt = ociparse($this->db_connect_id, $sql);
ociexecute($stmt);
$result = array();
if (ocifetchinto($stmt, $result, OCI_ASSOC + OCI_RETURN_NULLS)) {
$table = $result['TABLE_NAME'];
// This is the statement_id that will allow us to track the plan
$statement_id = substr(md5($query), 0, 30);
// Remove any stale plans
$stmt2 = ociparse($this->db_connect_id, "DELETE FROM {$table} WHERE statement_id='{$statement_id}'");
ociexecute($stmt2);
ocifreestatement($stmt2);
// Explain the plan
$sql = "EXPLAIN PLAN\n\t\t\t\t\t\tSET STATEMENT_ID = '{$statement_id}'\n\t\t\t\t\t\tFOR {$query}";
$stmt2 = ociparse($this->db_connect_id, $sql);
ociexecute($stmt2);
ocifreestatement($stmt2);
// Get the data from the plan
$sql = "SELECT operation, options, object_name, object_type, cardinality, cost\n\t\t\t\t\t\tFROM plan_table\n\t\t\t\t\t\tSTART WITH id = 0 AND statement_id = '{$statement_id}'\n\t\t\t\t\t\tCONNECT BY PRIOR id = parent_id\n\t\t\t\t\t\t\tAND statement_id = '{$statement_id}'";
$stmt2 = ociparse($this->db_connect_id, $sql);
ociexecute($stmt2);
$row = array();
while (ocifetchinto($stmt2, $row, OCI_ASSOC + OCI_RETURN_NULLS)) {
$html_table = $this->sql_report('add_select_row', $query, $html_table, $row);
}
ocifreestatement($stmt2);
// Remove the plan we just made, we delete them on request anyway
$stmt2 = ociparse($this->db_connect_id, "DELETE FROM {$table} WHERE statement_id='{$statement_id}'");
ociexecute($stmt2);
ocifreestatement($stmt2);
}
ocifreestatement($stmt);
if ($html_table) {
$this->html_hold .= '</table>';
}
break;
case 'fromcache':
$endtime = explode(' ', microtime());
$endtime = $endtime[0] + $endtime[1];
$result = @ociparse($this->db_connect_id, $query);
$success = @ociexecute($result, OCI_DEFAULT);
$row = array();
while (@ocifetchinto($result, $row, OCI_ASSOC + OCI_RETURN_NULLS)) {
// Take the time spent on parsing rows into account
}
@ocifreestatement($result);
$splittime = explode(' ', microtime());
$splittime = $splittime[0] + $splittime[1];
$this->sql_report('record_fromcache', $query, $endtime, $splittime);
break;
}
}
开发者ID:puring0815,项目名称:OpenKore,代码行数:62,代码来源:oracle.php
示例18: md5
$ID_EJERCICIOM = '001-2008';
$ID_CCOSTOM = '4.01';
//********************COMIENZAN VALIDACIONES***********************************
if (!$usuario and !isset($_POST['username']) and !isset($_POST['password']) and !isset($_POST['ingresar'])) {
echo '<META HTTP-EQUIV="Refresh"
CONTENT="0; URL=' . CONSTANT_PATH_SIMA_RAIZ . '/index.php">';
exit;
}
if (!$usuario) {
//encriptar
$crypt = $_POST['password'];
$_POST['password'] = md5($_POST['password']);
if (isset($_POST['username']) and isset($_POST['password']) and isset($_POST['ingresar'])) {
$cmdstr3 = "select * from PEDRO.USUARIO WHERE LOGIN = '" . $_POST['username'] . "' AND PASSWORD1 = '" . $_POST['password'] . "'\r\nAND STATUS='A'\r\n";
$parsed3 = ociparse($db_conn, $cmdstr3);
ociexecute($parsed3);
$nrows3 = ocifetchstatement($parsed3, $resulta3);
for ($i = 0; $i < $nrows3; $i++) {
$user = $resulta3['LOGIN'][$i];
$passwd = $resulta3['PASSWORD1'][$i];
}
if ($user == $_POST['username'] and $passwd == $_POST['password']) {
//agregar sesiones
session_destroy();
session_start();
$llave = session_id();
$agregaIP = "INSERT INTO sesiones ( \r\nusuario,ip,llave\r\n) values ('" . $user . "','" . $ip . "','" . $llave . "')";
mysql_db_query($basedatos, $agregaIP);
echo mysql_error();
echo '<META HTTP-EQUIV="Refresh"
CONTENT="0; URL=">';
开发者ID:rusli-nasir,项目名称:hospitalPhp,代码行数:31,代码来源:menuing.php
示例19: _execute
/**
* Execute the query
*
* @access private called by the base class
* @param string an SQL query
* @return resource
*/
function _execute($sql)
{
// oracle must parse the query before it is run. All of the actions with
// the query are based on the statement id returned by ociparse
$this->_set_stmt_id($sql);
ocisetprefetch($this->stmt_id, 1000);
return @ociexecute($this->stmt_id, $this->_commit);
}
开发者ID:qlixes,项目名称:springphp,代码行数:15,代码来源:oci8_driver.php
示例20: foreach
@pg_close($db);
} else {
echo "<div align=center><font face=Verdana size=-2 color=red><b>Can't connect to PostgreSQL server</b></font></div>";
}
break;
case 'Oracle':
$db = @ocilogon($_POST['mysql_l'], $_POST['mysql_p'], $_POST['mysql_db']);
if ($error = @ocierror()) {
echo "<div align=center><font face=Verdana size=-2 color=red><b>Can't connect to Oracle server.<br>" . $error['message'] . "</b></font></div>";
} else {
$querys = @explode(';', $_POST['db_query']);
foreach ($querys as $num => $query) {
if (strlen($query) > 5) {
echo "<font face=Verdana size=-2 color=green><b>Query#" . $num . " : " . htmlspecialchars($query) . "</b></font><br>";
$stat = @ociparse($db, $query);
@ociexecute($stat);
if ($error = @ocierror()) {
echo "<table width=100%><tr><td><font face=Verdana size=-2>Error : <b>" . $error['message'] . "</b></font></td></tr></table><br>";
} else {
$rowcount = @ocirowcount($stat);
if ($rowcount != 0) {
echo "<table width=100%><tr><td><font face=Verdana size=-2>affected rows : <b>" . $rowcount . "</b></font></td></tr></table><br>";
} else {
echo "<table width=100%><tr>";
for ($j = 1; $j <= @ocinumcols($stat); $j++) {
echo "<td bgcolor=#cccccc><font face=Verdana size=-2><b> " . htmlspecialchars(@ocicolumnname($stat, $j)) . " </b></font></td>";
}
echo "</tr>";
while (ocifetch($stat)) {
echo "<tr>";
for ($j = 1; $j <= @ocinumcols($stat); $j++) {
开发者ID:Theov,项目名称:webshells,代码行数:31,代码来源:r57.php
注:本文中的ociexecute函数示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论