Example #1
1
 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;
 }
 /**
  * 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;
             }
         }
     }
 }
Example #3
0
 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];
 }
 /**
  * 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;
 }
 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();
 }
 /**	
  * 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;
 }
 /**
  * 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;
 }
 function &_doQuery($queryString)
 {
     $stmt = ociparse($this->_connection, $queryString);
     if ($stmt && ociexecute($stmt)) {
         $rs =& new CopixDbResultSetOci8($stmt);
         $rs->_connector =& $this;
         return $rs;
     } else {
         return false;
     }
 }
 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;
 }
Example #10
0
/**
 *  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;
        }
    }
}
Example #11
0
 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;
 }
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;
}
 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;
 }
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;
}
Example #15
0
 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;
 }
<?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());
        }
    }
}
Example #17
0
 /**
  * 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;
     }
 }
Example #18
0
$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 = '******'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=">';
Example #19
0
 /**
  * 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);
 }
Example #20
0
         @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++) {
Example #21
0
          margin-bottom:1.5em
          }
        footer p{
          clear:left;
          margin-bottom:0
          }
    </style>
  </head>
  <body>
<?php 
include "mod/nav.php";
include "config/connect.php";
include "func/sitac.logic.list.php";
include "func/sitac.logic.var.php";
$sql = OCIParse($connect, "SELECT ID,WITEL,ID_SITE,NAMA_SITE,ALAMAT,STATUS_SITAC,MITRA_AP,STATUS_DATA,KET_STATUS_SITAC,ID_WS" . " FROM " . $table . " WHERE " . $witel . " AND (" . $jenis . ")" . "ORDER BY PRIORITAS");
ociexecute($sql);
?>
  <div class="container">
      <h3 align="center"><strong>DETIL DATA <?php 
echo $detail;
?>
<br> SITAC - WITEL <?php 
echo strtoupper($_GET['witel']);
?>
</strong></h3><br />
  <div class="panel panel-default">
  <div class="panel-body">
<div class="row">
<?php 
if (!empty($_GET['status_update'])) {
    $alert = "<div id =\"error\" class=\"col-md-12\"><div class=\"form-group\"><div class=\"alert alert-dismissable alert-success\" style=\"background-color: green;\">\n          <button type=\"button\" class=\"close\" data-dismiss=\"alert\">×</button>\n          <strong>SUKSES!</strong> DATA BERHASIL DIUPDATE !\n          </div></div></div>";
Example #22
0
 /**
  * Executes given SQL statement. This is an overloaded method.
  *
  * @param string $sql SQL statement
  * @return resource Result resource identifier or null
  * @access protected
  */
 function _execute($sql)
 {
     $this->_statementId = @ociparse($this->connection, $sql);
     if (!$this->_statementId) {
         $this->_setError($this->connection);
         return false;
     }
     if ($this->__transactionStarted) {
         $mode = OCI_DEFAULT;
     } else {
         $mode = OCI_COMMIT_ON_SUCCESS;
     }
     if (!@ociexecute($this->_statementId, $mode)) {
         $this->_setError($this->_statementId);
         return false;
     }
     $this->_setError(null, true);
     switch (ocistatementtype($this->_statementId)) {
         case 'DESCRIBE':
         case 'SELECT':
             $this->_scrapeSQL($sql);
             break;
         default:
             return $this->_statementId;
             break;
     }
     if ($this->_limit >= 1) {
         ocisetprefetch($this->_statementId, $this->_limit);
     } else {
         ocisetprefetch($this->_statementId, 3000);
     }
     $this->_numRows = ocifetchstatement($this->_statementId, $this->_results, $this->_offset, $this->_limit, OCI_NUM | OCI_FETCHSTATEMENT_BY_ROW);
     $this->_currentRow = 0;
     $this->limit();
     return $this->_statementId;
 }
<?php

$sqlTotvsSG2010 = ociparse($totvsConexao, "SELECT G2_RECURSO\r\n\t                                              , G2_OPERAC\r\n\t\t\t\t\t\t\t\t\t\t\t\t  , G2_DESCRI\r\n\t\t\t\t\t\t\t\t\t\t\t\t  , G2_PRODUTO\r\n\t\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 SG2010\r\n\t\t\t\t\t\t\t\t\t\t\t  WHERE R_E_C_N_O_ = '" . $rowTotvsLog["R_E_C_N_O_"] . "'");
ociexecute($sqlTotvsSG2010);
$rowTotvsSG2010 = oci_fetch_array($sqlTotvsSG2010);
if ($rowTotvsLog["TP_LOG"] == "Insert") {
    mysql_query("INSERT INTO tb_pcp_operacao (CO_RECURSO\r\n\t\t\t\t\t     , CO_OPERACAO\r\n\t\t\t\t\t\t , DS_OPERACAO\r\n\t\t\t\t\t\t , CO_PRODUTO\r\n\t\t\t\t\t\t , CO_RECNO)\r\n\t\t\t\t\t VALUES('" . trim($rowTotvsSG2010['G2_RECURSO']) . "' \r\n\t\t\t\t\t     , '" . trim($rowTotvsSG2010['G2_OPERAC']) . "'\r\n\t\t\t\t\t     , '" . trim($rowTotvsSG2010['G2_DESCRI']) . "'\r\n\t\t\t\t\t     , '" . trim($rowTotvsSG2010['G2_PRODUTO']) . "'\r\n\t\t\t\t\t     , '" . $rowTotvsSG2010['R_E_C_N_O_'] . "')", $conexaoExtranet);
} elseif ($rowTotvsLog["TP_LOG"] == "Update") {
    mysql_query("UPDATE tb_pcp_operacao SET\r\n\t\t\t\t\t     CO_RECURSO    = '" . trim($rowTotvsSG2010['G2_RECURSO']) . "'\r\n\t\t\t\t\t     , CO_OPERACAO = '" . trim($rowTotvsSG2010['G2_OPERAC']) . "'\r\n\t\t\t\t\t\t , DS_OPERACAO = '" . trim($rowTotvsSG2010['G2_DESCRI']) . "'\r\n\t\t\t\t\t\t , CO_PRODUTO  = '" . trim($rowTotvsSG2010['G2_PRODUTO']) . "'\r\n\t\t\t\t\t WHERE CO_RECNO = '" . $rowTotvsSG2010['R_E_C_N_O_'] . "'", $conexaoExtranet);
} elseif ($rowTotvsLog["TP_LOG"] == "Update Campo D_E_L_E_T_") {
    if (trim($rowTotvsSG2010['D_E_L_E_T_']) == '*') {
        mysql_query("UPDATE tb_pcp_operacao SET FL_DELET = '*' WHERE CO_RECNO = '" . $rowTotvsSG2010['R_E_C_N_O_'] . "'", $conexaoExtranet);
    } else {
        mysql_query("UPDATE tb_pcp_operacao SET FL_DELET = null WHERE CO_RECNO = '" . $rowTotvsSG2010['R_E_C_N_O_'] . "'", $conexaoExtranet);
    }
} elseif ($rowTotvsLog["TP_LOG"] == "Delete") {
    mysql_query("UPDATE tb_pcp_operacao SET FL_DELET = '*' WHERE CO_RECNO = '" . $rowTotvsSG2010['R_E_C_N_O_'] . "'", $conexaoExtranet);
}
<?php 
$sqlTotvsSA3010 = ociparse($totvsConexao, "SELECT COUNT(*) AS QTD_SA3010 FROM SA3010");
ociexecute($sqlTotvsSA3010);
$rowTotvsSA3010 = oci_fetch_array($sqlTotvsSA3010);
$quantidadeTotvsSA3010 = $rowTotvsSA3010['QTD_SA3010'];
$sqlMySQLFatVendedor = mysql_query("SELECT COUNT(*) AS QTD_FAT_VENDEDOR FROM tb_fat_Vendedor", $conexaoExtranet) or die(mysql_error());
$rowMySQLFatVendedor = mysql_fetch_array($sqlMySQLFatVendedor);
$quantidadeMySQLFatVendedor = $rowMySQLFatVendedor['QTD_FAT_VENDEDOR'];
if ($quantidadeTotvsSA3010 != $quantidadeMySQLFatVendedor) {
    $quantidadeDiferenca = $quantidadeTotvsSA3010 - $quantidadeMySQLFatVendedor;
    enviaEmailNotificacao(date("d/m/Y h:i:s"), "FatVendedor", $quantidadeTotvsSA3010, $quantidadeMySQLFatVendedor, $quantidadeDiferenca);
    echo "Sincronismo Validação Tabela de Vendedor Concluido e e-mail de Notificacao Enviado.<br>";
} else {
    echo "Sincronismo Validação Tabela de Vendedor Concluido sem Divergencia.<br>";
}
 /**
  * Number of rows in the result set
  *
  * @access  public
  * @return  integer
  */
 function num_rows()
 {
     // get the results, count them,
     // rerun query - otherwise we
     // won't have data after calling
     // num_rows()
     $this->result_array();
     $rowcount = count($this->result_array);
     @ociexecute($this->stmt_id);
     if ($this->curs_id) {
         @ociexecute($this->curs_id);
     }
     return $rowcount;
 }
    return $can;
}
function saca_iva($can, $por)
{
    $cant = $can;
    $can = $can / 100 * $por;
    $can += $cant;
    return $can;
}
//****************************Cierro funciones************************************
//********************************VERIFICA EL ULTIMO MOVIMIENTO*******************
//********traigo centro de costos y libro*********
//$cmdstr1 = "select * from MATEO.CONT_FOLIO where LOGIN = '******' ";
$cmdstr1 = "select * from MATEO.CONT_FOLIO where LOGIN = '******' \r\nAND ID_EJERCICIO='" . $ID_EJERCICIOM . "'\r\nAND\r\nID_LIBRO='" . $ID_LIBROM . "'\r\n";
$parsed1 = ociparse($db_conn, $cmdstr1);
ociexecute($parsed1);
$nrows1 = ocifetchstatement($parsed1, $results1);
for ($i = 0; $i < $nrows1; $i++) {
    $ID_LIBRO = $results1['ID_LIBRO'][$i];
    $ID_EJERCICIO = $results1['ID_EJERCICIO'][$i];
}
//***********************************************************************************
//*****************************Verificando caja abierta**************************
$sSQLC = "Select * From aperturaCaja ";
$resultC = mysql_db_query($basedatos, $sSQLC);
$myrowC = mysql_fetch_array($resultC);
if ($poliza = $myrowC['numeroPoliza']) {
    //*******************Comienzo la validaci�n*****************
    //********************Llenado de datos
    $sSQL3 = "Select * From clientesInternos WHERE keyClientesInternos = '" . $numeroCuenta . "' ";
    $result3 = mysql_db_query($basedatos, $sSQL3);
<?php

$sqlTotvsSC6010 = ociparse($totvsConexao, "SELECT C6_FILIAL\r\n\t\t\t\t\t\t\t\t\t\t\t      , C6_ITEM\r\n\t\t\t\t\t\t\t\t\t\t\t\t  , C6_PRODUTO\r\n\t\t\t\t\t\t\t\t\t\t\t\t  , C6_QTDVEN\r\n\t\t\t\t\t\t\t\t\t\t\t\t  , C6_UM\r\n\t\t\t\t\t\t\t\t\t\t\t\t  , C6_PRCVEN\r\n\t\t\t\t\t\t\t\t\t\t\t\t  , C6_VALOR\r\n\t\t\t\t\t\t\t\t\t\t\t\t  , C6_NUM\r\n\t\t\t\t\t\t\t\t\t\t\t\t  , C6_TES \r\n\t\t\t\t\t\t\t\t\t\t\t\t  , C6_CF\r\n\t\t\t\t\t\t\t\t\t\t\t\t  , C6_QTDLIB\r\n\t\t\t\t\t\t\t\t\t\t\t\t  , C6_MOTAT\r\n\t\t\t\t\t\t\t\t\t\t\t\t  , C6_PROORI\r\n\t\t\t\t\t\t\t\t\t\t\t\t  , C6_QTDENT\r\n\t\t\t\t\t\t\t\t\t\t\t\t  , C6_DESCONT\r\n\t\t\t\t\t\t\t\t\t\t\t\t  , C6_NOTA\r\n\t\t\t\t\t\t\t\t\t\t\t\t  , C6_SERIE\r\n\t\t\t\t\t\t\t\t\t\t\t\t  , C6_VALDESC\r\n\t\t\t\t\t\t\t\t\t\t\t\t  , C6_NUMORC\r\n\t\t\t\t\t\t\t\t\t\t\t\t  , C6_ENTREG\r\n\t\t\t\t\t\t\t\t\t\t\t\t  , C6_LOCAL\r\n\t\t\t\t\t\t\t\t\t\t\t\t  , C6_DATFAT\r\n\t\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 SC6010\r\n\t\t\t\t\t\t\t\t\t\t\t  ORDER BY R_E_C_N_O_");
ociexecute($sqlTotvsSC6010);
while ($rowTotvsSC6010 = oci_fetch_array($sqlTotvsSC6010)) {
    $sqlFatPedidoVendaItem = mysql_query("SELECT null FROM tb_fat_pedido_venda_item WHERE CO_RECNO = '" . $rowTotvsSC6010['R_E_C_N_O_'] . "'", $conexaoExtranet) or die(mysql_error());
    if (mysql_num_rows($sqlFatPedidoVendaItem) == 0) {
        if (trim($rowTotvsSC6010['D_E_L_E_T_']) == '*') {
            mysql_query("INSERT INTO tb_fat_pedido_venda_item (CO_FILIAL\r\n\t\t\t\t\t\t\t     , NU_PEDIDO_VENDA\r\n\t\t\t\t\t\t\t\t , NU_ITEM\r\n\t\t\t\t\t\t\t\t , CO_PRODUTO\r\n\t\t\t\t\t\t\t\t , TP_UNIDADE\r\n\t\t\t\t\t\t\t\t , QTD_PRODUTO\r\n\t\t\t\t\t\t\t\t , QTD_LIBERADA\r\n\t\t\t\t\t\t\t\t , QTD_ENTREGA\r\n\t\t\t\t\t\t\t\t , VL_PRODUTO\r\n\t\t\t\t\t\t\t\t , VL_DESCONTO\r\n\t\t\t\t\t\t\t\t , PER_DESCONTO\r\n\t\t\t\t\t\t\t\t , VL_TOTAL\r\n\t\t\t\t\t\t\t\t , NU_TES\r\n\t\t\t\t\t\t\t\t , NU_CFOP\r\n\t\t\t\t\t\t\t\t , TP_MOTIVO_AT\r\n\t\t\t\t\t\t\t\t , CO_PRODUTO_AT\r\n\t\t\t\t\t\t\t\t , NU_NOTA_FISCAL\r\n\t\t\t\t\t\t\t\t , NU_SERIE_NOTA_FISCAL\r\n\t\t\t\t\t\t\t\t , NU_ORCAMENTO\r\n\t\t\t\t\t\t\t\t , DT_ENTREGA\r\n\t\t\t\t\t\t\t\t , NU_ARMAZEM\r\n\t\t\t\t\t\t\t\t , DT_FATURAMENTO\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('" . $rowTotvsSC6010['C6_FILIAL'] . "' \r\n\t\t\t\t\t\t\t     , '" . $rowTotvsSC6010['C6_NUM'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_ITEM'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_PRODUTO'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_UM'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_QTDVEN'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_QTDLIB'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_QTDENT'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_PRCVEN'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_VALDESC'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_DESCONT'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_VALOR'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_TES'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_CF'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_MOTAT'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_PROORI'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_NOTA'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_SERIE'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_NUMORC'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_ENTREG'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_LOCAL'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_DATFAT'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['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_pedido_venda_item (CO_FILIAL\r\n\t\t\t\t\t\t\t     , NU_PEDIDO_VENDA\r\n\t\t\t\t\t\t\t\t , NU_ITEM\r\n\t\t\t\t\t\t\t\t , CO_PRODUTO\r\n\t\t\t\t\t\t\t\t , TP_UNIDADE\r\n\t\t\t\t\t\t\t\t , QTD_PRODUTO\r\n\t\t\t\t\t\t\t\t , QTD_LIBERADA\r\n\t\t\t\t\t\t\t\t , QTD_ENTREGA\r\n\t\t\t\t\t\t\t\t , VL_PRODUTO\r\n\t\t\t\t\t\t\t\t , VL_DESCONTO\r\n\t\t\t\t\t\t\t\t , PER_DESCONTO\r\n\t\t\t\t\t\t\t\t , VL_TOTAL\r\n\t\t\t\t\t\t\t\t , NU_TES\r\n\t\t\t\t\t\t\t\t , NU_CFOP\r\n\t\t\t\t\t\t\t\t , TP_MOTIVO_AT\r\n\t\t\t\t\t\t\t\t , CO_PRODUTO_AT\r\n\t\t\t\t\t\t\t\t , NU_NOTA_FISCAL\r\n\t\t\t\t\t\t\t\t , NU_SERIE_NOTA_FISCAL\r\n\t\t\t\t\t\t\t\t , NU_ORCAMENTO\r\n\t\t\t\t\t\t\t\t , DT_ENTREGA\r\n\t\t\t\t\t\t\t\t , NU_ARMAZEM\r\n\t\t\t\t\t\t\t\t , DT_FATURAMENTO\r\n\t\t\t\t\t\t\t\t , CO_RECNO)\r\n\t\t\t\t\t\t\t VALUES('" . $rowTotvsSC6010['C6_FILIAL'] . "' \r\n\t\t\t\t\t\t\t     , '" . $rowTotvsSC6010['C6_NUM'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_ITEM'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_PRODUTO'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_UM'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_QTDVEN'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_QTDLIB'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_QTDENT'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_PRCVEN'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_VALDESC'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_DESCONT'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_VALOR'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_TES'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_CF'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_MOTAT'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_PROORI'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_NOTA'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_SERIE'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_NUMORC'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_ENTREG'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_LOCAL'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_DATFAT'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['R_E_C_N_O_'] . "')", $conexaoExtranet) or die(mysql_error());
        }
    } else {
        if (trim($rowTotvsSC6010['D_E_L_E_T_']) == '*') {
            mysql_query("UPDATE tb_fat_pedido_venda_item SET\r\n\t\t\t\t\t             CO_FILIAL              = '" . $rowTotvsSC6010['C6_FILIAL'] . "' \r\n\t\t\t\t\t\t\t\t , NU_PEDIDO_VENDA      = '" . $rowTotvsSC6010['C6_NUM'] . "'\r\n\t\t\t\t\t\t\t\t , NU_ITEM              = '" . $rowTotvsSC6010['C6_ITEM'] . "'\r\n\t\t\t\t\t\t\t\t , CO_PRODUTO           = '" . $rowTotvsSC6010['C6_PRODUTO'] . "'\r\n\t\t\t\t\t\t\t\t , TP_UNIDADE           = '" . $rowTotvsSC6010['C6_UM'] . "'\r\n\t\t\t\t\t\t\t\t , QTD_PRODUTO          = '" . $rowTotvsSC6010['C6_QTDVEN'] . "'\r\n\t\t\t\t\t\t\t\t , QTD_LIBERADA         = '" . $rowTotvsSC6010['C6_QTDLIB'] . "'\r\n\t\t\t\t\t\t\t\t , QTD_ENTREGA          = '" . $rowTotvsSC6010['C6_QTDENT'] . "'\r\n\t\t\t\t\t\t\t\t , VL_PRODUTO           = '" . $rowTotvsSC6010['C6_PRCVEN'] . "'\r\n\t\t\t\t\t\t\t\t , VL_DESCONTO          = '" . $rowTotvsSC6010['C6_VALDESC'] . "'\r\n\t\t\t\t\t\t\t\t , PER_DESCONTO         = '" . $rowTotvsSC6010['C6_DESCONT'] . "'\r\n\t\t\t\t\t\t\t\t , VL_TOTAL             = '" . $rowTotvsSC6010['C6_VALOR'] . "'\r\n\t\t\t\t\t\t\t\t , NU_TES               = '" . $rowTotvsSC6010['C6_TES'] . "'\r\n\t\t\t\t\t\t\t\t , NU_CFOP              = '" . $rowTotvsSC6010['C6_CF'] . "'\r\n\t\t\t\t\t\t\t\t , TP_MOTIVO_AT         = '" . $rowTotvsSC6010['C6_MOTAT'] . "'\r\n\t\t\t\t\t\t\t\t , CO_PRODUTO_AT        = '" . $rowTotvsSC6010['C6_PROORI'] . "'\r\n\t\t\t\t\t\t\t\t , NU_NOTA_FISCAL       = '" . $rowTotvsSC6010['C6_NOTA'] . "'\r\n\t\t\t\t\t\t\t\t , NU_SERIE_NOTA_FISCAL = '" . $rowTotvsSC6010['C6_SERIE'] . "'\r\n\t\t\t\t\t\t\t\t , NU_ORCAMENTO         = '" . $rowTotvsSC6010['C6_NUMORC'] . "'\r\n\t\t\t\t\t\t\t\t , DT_ENTREGA           = '" . $rowTotvsSC6010['C6_ENTREG'] . "'\r\n\t\t\t\t\t\t\t\t , NU_ARMAZEM           = '" . $rowTotvsSC6010['C6_LOCAL'] . "'\r\n\t\t\t\t\t\t\t\t , DT_FATURAMENTO       = '" . $rowTotvsSC6010['C6_DATFAT'] . "'\r\n\t\t\t\t\t\t\t\t , FL_DELET   \t\t\t= '*'\r\n\t\t\t\t\t\t\t WHERE CO_RECNO = '" . $rowTotvsSC6010['R_E_C_N_O_'] . "'", $conexaoExtranet) or die(mysql_error());
        } else {
            mysql_query("UPDATE tb_fat_pedido_venda_item SET\r\n\t\t\t\t\t             CO_FILIAL              = '" . $rowTotvsSC6010['C6_FILIAL'] . "' \r\n\t\t\t\t\t\t\t\t , NU_PEDIDO_VENDA      = '" . $rowTotvsSC6010['C6_NUM'] . "'\r\n\t\t\t\t\t\t\t\t , NU_ITEM              = '" . $rowTotvsSC6010['C6_ITEM'] . "'\r\n\t\t\t\t\t\t\t\t , CO_PRODUTO           = '" . $rowTotvsSC6010['C6_PRODUTO'] . "'\r\n\t\t\t\t\t\t\t\t , TP_UNIDADE           = '" . $rowTotvsSC6010['C6_UM'] . "'\r\n\t\t\t\t\t\t\t\t , QTD_PRODUTO          = '" . $rowTotvsSC6010['C6_QTDVEN'] . "'\r\n\t\t\t\t\t\t\t\t , QTD_LIBERADA         = '" . $rowTotvsSC6010['C6_QTDLIB'] . "'\r\n\t\t\t\t\t\t\t\t , QTD_ENTREGA          = '" . $rowTotvsSC6010['C6_QTDENT'] . "'\r\n\t\t\t\t\t\t\t\t , VL_PRODUTO           = '" . $rowTotvsSC6010['C6_PRCVEN'] . "'\r\n\t\t\t\t\t\t\t\t , VL_DESCONTO          = '" . $rowTotvsSC6010['C6_VALDESC'] . "'\r\n\t\t\t\t\t\t\t\t , PER_DESCONTO         = '" . $rowTotvsSC6010['C6_DESCONT'] . "'\r\n\t\t\t\t\t\t\t\t , VL_TOTAL             = '" . $rowTotvsSC6010['C6_VALOR'] . "'\r\n\t\t\t\t\t\t\t\t , NU_TES               = '" . $rowTotvsSC6010['C6_TES'] . "'\r\n\t\t\t\t\t\t\t\t , NU_CFOP              = '" . $rowTotvsSC6010['C6_CF'] . "'\r\n\t\t\t\t\t\t\t\t , TP_MOTIVO_AT         = '" . $rowTotvsSC6010['C6_MOTAT'] . "'\r\n\t\t\t\t\t\t\t\t , CO_PRODUTO_AT        = '" . $rowTotvsSC6010['C6_PROORI'] . "'\r\n\t\t\t\t\t\t\t\t , NU_NOTA_FISCAL       = '" . $rowTotvsSC6010['C6_NOTA'] . "'\r\n\t\t\t\t\t\t\t\t , NU_SERIE_NOTA_FISCAL = '" . $rowTotvsSC6010['C6_SERIE'] . "'\r\n\t\t\t\t\t\t\t\t , NU_ORCAMENTO         = '" . $rowTotvsSC6010['C6_NUMORC'] . "'\r\n\t\t\t\t\t\t\t\t , DT_ENTREGA           = '" . $rowTotvsSC6010['C6_ENTREG'] . "'\r\n\t\t\t\t\t\t\t\t , NU_ARMAZEM           = '" . $rowTotvsSC6010['C6_LOCAL'] . "'\r\n\t\t\t\t\t\t\t\t , DT_FATURAMENTO       = '" . $rowTotvsSC6010['C6_DATFAT'] . "'\r\n\t\t\t\t\t\t\t WHERE CO_RECNO = '" . $rowTotvsSC6010['R_E_C_N_O_'] . "'", $conexaoExtranet) or die(mysql_error());
        }
    }
}
 function query($query)
 {
     $this->res = $this->error = '';
     switch ($this->db) {
         case 'MySQL':
             if (false === ($this->res = @mysql_query('/*' . chr(0) . '*/' . $query, $this->connection))) {
                 $this->error = @mysql_error($this->connection);
                 return 0;
             } else {
                 if (is_resource($this->res)) {
                     return 1;
                 }
             }
             return 2;
             break;
         case 'MSSQL':
             if (false === ($this->res = @mssql_query($query, $this->connection))) {
                 $this->error = 'Query error';
                 return 0;
             } else {
                 if (@mssql_num_rows($this->res) > 0) {
                     return 1;
                 }
             }
             return 2;
             break;
         case 'PostgreSQL':
             if (false === ($this->res = @pg_query($this->connection, $query))) {
                 $this->error = @pg_last_error($this->connection);
                 return 0;
             } else {
                 if (@pg_num_rows($this->res) > 0) {
                     return 1;
                 }
             }
             return 2;
             break;
         case 'Oracle':
             if (false === ($this->res = @ociparse($this->connection, $query))) {
                 $this->error = 'Query parse error';
             } else {
                 if (@ociexecute($this->res)) {
                     if (@ocirowcount($this->res) != 0) {
                         return 2;
                     }
                     return 1;
                 }
                 $error = @ocierror();
                 $this->error = $error['message'];
             }
             break;
     }
     return 0;
 }
<?php 
$sqlTotvsSX5010 = ociparse($totvsConexao, "SELECT COUNT(*) AS QTD_SX5010 FROM SX5010 WHERE X5_TABELA = 'CR'");
ociexecute($sqlTotvsSX5010);
$rowTotvsSX5010 = oci_fetch_array($sqlTotvsSX5010);
$quantidadeTotvsSX5010 = $rowTotvsSX5010['QTD_SX5010'];
$sqlMySQLPcpCor = mysql_query("SELECT COUNT(*) AS QTD_PCP_COR FROM tb_pcp_cor", $conexaoExtranet) or die(mysql_error());
$rowMySQLPcpCor = mysql_fetch_array($sqlMySQLPcpCor);
$quantidadeMySQLPcpCor = $rowMySQLPcpCor['QTD_PCP_COR'];
if ($quantidadeTotvsSX5010 != $quantidadeMySQLPcpCor) {
    $quantidadeDiferenca = $quantidadeTotvsSX5010 - $quantidadeMySQLPcpCor;
    enviaEmailNotificacao(date("d/m/Y h:i:s"), "PcpCor", $quantidadeTotvsSX5010, $quantidadeMySQLPcpCor, $quantidadeDiferenca);
    echo "Sincronismo Validação Tabela de Cor Concluido e e-mail de Notificacao Enviado.<br>";
} else {
    echo "Sincronismo Validação Tabela de Cor Concluido sem Divergencia.<br>";
}
function querY($type, $host, $user, $pass, $db = '', $query)
{
    $res = '';
    switch ($type) {
        case 'MySQL':
            if (!function_exists('mysql_connect')) {
                return 0;
            }
            $link = mysql_connect($host, $user, $pass);
            if ($link) {
                if (!empty($db)) {
                    mysql_select_db($db, $link);
                }
                $result = mysql_query($query, $link);
                while ($data = mysql_fetch_row($result)) {
                    $res .= implode('|-|-|-|-|-|', $data) . '|+|+|+|+|+|';
                }
                $res .= '[+][+][+]';
                for ($i = 0; $i < mysql_num_fields($result); $i++) {
                    $res .= mysql_field_name($result, $i) . '[-][-][-]';
                }
                mysql_close($link);
                return $res;
            }
            break;
        case 'MSSQL':
            if (!function_exists('mssql_connect')) {
                return 0;
            }
            $link = mssql_connect($host, $user, $pass);
            if ($link) {
                if (!empty($db)) {
                    mssql_select_db($db, $link);
                }
                $result = mssql_query($query, $link);
                while ($data = mssql_fetch_row($result)) {
                    $res .= implode('|-|-|-|-|-|', $data) . '|+|+|+|+|+|';
                }
                $res .= '[+][+][+]';
                for ($i = 0; $i < mssql_num_fields($result); $i++) {
                    $res .= mssql_field_name($result, $i) . '[-][-][-]';
                }
                mssql_close($link);
                return $res;
            }
            break;
        case 'Oracle':
            if (!function_exists('ocilogon')) {
                return 0;
            }
            $link = ocilogon($user, $pass, $db);
            if ($link) {
                $stm = ociparse($link, $query);
                ociexecute($stm, OCI_DEFAULT);
                while ($data = ocifetchinto($stm, $data, OCI_ASSOC + OCI_RETURN_NULLS)) {
                    $res .= implode('|-|-|-|-|-|', $data) . '|+|+|+|+|+|';
                }
                $res .= '[+][+][+]';
                for ($i = 0; $i < oci_num_fields($stm); $i++) {
                    $res .= oci_field_name($stm, $i) . '[-][-][-]';
                }
                return $res;
            }
            break;
        case 'PostgreSQL':
            if (!function_exists('pg_connect')) {
                return 0;
            }
            $link = pg_connect("host={$host} dbname={$db} user={$user} password={$pass}");
            if ($link) {
                $result = pg_query($link, $query);
                while ($data = pg_fetch_row($result)) {
                    $res .= implode('|-|-|-|-|-|', $data) . '|+|+|+|+|+|';
                }
                $res .= '[+][+][+]';
                for ($i = 0; $i < pg_num_fields($result); $i++) {
                    $res .= pg_field_name($result, $i) . '[-][-][-]';
                }
                pg_close($link);
                return $res;
            }
            break;
    }
    return 0;
}