PHP ociexecute函数代码示例

OGeek|极客世界-中国程序员成长平台 › 门户 › 编程› PHP›PHP编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了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>&nbsp;" . htmlspecialchars(@ocicolumnname($stat, $j)) . "&nbsp;</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；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

PHP ocifetchinto函数代码示例发布时间：2022-05-15

PHP ocierror函数代码示例发布时间：2022-05-15

MATLAB文本注释及特殊符号的表示 - 那抹阳

1 librespeed/speedtest: Self-hosted Speedt

librespeed/speedtest: Self-hosted Speedtest for HTML5 and more. Easy setup, exam

阅读：1214|2022-08-30

2 avehtari/BDA_m_demos: Bayesian Data Anal

avehtari/BDA_m_demos: Bayesian Data Analysis demos for Matlab/Octave

阅读：1120|2022-08-17

3 四维彩超怎么看性别？四维看男孩女孩诀窍

女人怀孕后，为了有一个健康聪明的宝宝，经历各种体检、筛查。其实这些体检和筛查中的

阅读：931|2022-11-06

4 CVE-2022-26113

An execution with unnecessary privileges vulnerability in FortiClientWindows 7.

阅读：1175|2022-07-29

5 medfreeman/markdown-it-toc-and-anchor: m

medfreeman/markdown-it-toc-and-anchor: markdown-it plugin to add a toc and ancho

阅读：1330|2022-08-18

6 nuwave/lighthouse: A framework for servi

nuwave/lighthouse: A framework for serving GraphQL from Laravel

阅读：685|2022-08-13

7 sydney0zq/covid-19-detection: The implem

sydney0zq/covid-19-detection: The implementation of A Weakly-supervised Framewor

阅读：480|2022-08-16

8 世界上哪个国家离中国最远？

离中国最远的国家是阿根廷。从太平洋直线计算，即往东线走，北京到阿根廷的布宜诺斯艾

阅读：632|2022-11-06

9 【微信小程序】如何上传、提交审核、发布操

微信小程序对个人开发者也提供无认证发布上传、提交审核、提交发布等，个人可以开发一

阅读：976|2022-07-18

10 小程序笔记一：基础设置

一：AppID(小程序ID)和AppSecret(小程序密钥) 这两个参数要记录，不光小程序要用到；

阅读：580|2022-07-18

客服电话

电子邮件

PHP ociexecute函数代码示例

示例1: query

示例2: OracleSelectQueryResult

示例3: insert_id

示例4: num_rows

示例5: realisateurParId

示例6: exec

示例7: num_rows

示例8: ociparse

示例9: select_genres

示例10: db_query

示例11: query_exec

示例12: db_exec

示例13: batchProcess

示例14: query_oracle

示例15: db_query

示例16: ociparse

示例17: _sql_report

示例18: md5

示例19: _execute

示例20: foreach

请发表评论

全部评论

上一篇：

下一篇：

kojino/Harvard-Robust-Machine-Learning:

MATLAB程序：广义路径损耗模型

文的笔顺,诠释文的笔画,解读文的部首

vvanders/wasm_lua: Lua VM running in a W

MatthewPeterKelly/IntroMatlabDynamics: A

MATLAB文本注释及特殊符号的表示 - 那抹阳

谁说大象不会跳舞，你的企业是否这样转型

wenzhixin/bootstrap-table: An extended t

coreos/coreos-vagrant: Minimal Vagrantfi

cebe/markdown: A super fast, highly exte

delphi7动态添加checkbox

关于我们

产品与服务

解决方案

139-2527-9053