/** * Internal method to fetch the next row from the result set * * @return array|null */ protected function getNextRow() { # If the result resource is invalid then don't bother trying to fetch if (!$this->result) { return; } switch ($this->mode) { case "mysql": $row = $this->result->fetch_assoc(); break; case "postgres": case "redshift": $row = pg_fetch_assoc($this->result); break; case "odbc": $row = odbc_fetch_array($this->result, $this->position + 1); break; case "sqlite": $row = $this->result->fetchArray(SQLITE3_ASSOC); break; case "mssql": $row = mssql_fetch_assoc($this->result); break; } # If the fetch fails then there are no rows left to retrieve if (!$row) { return; } $this->position++; return $row; }
public function query($sql) { $rs = odbc_exec($this->dbConnection(), $sql); if (is_resource($rs)) { while ($result[] = odbc_fetch_array($rs)) { } odbc_free_result($rs); $this->close(); return $result; } else { $this->halt('Database query error', $sql); } }
function ImportData($objOdbc, $objMySql, $strTableName) { global $objMySql; $objMySql->query("TRUNCATE `" . strtolower($strTableName) . '`;'); $objResult = odbc_exec($objOdbc, "SELECT * FROM " . $strTableName . ";"); print "Migrating " . odbc_num_rows($objResult) . " rows of data for " . $strTableName . "... [0]"; $intCount = 0; while ($arrResult = odbc_fetch_array($objResult)) { print str_repeat(chr(8), strlen($intCount) + 1); $intCount++; print $intCount . ']'; $strColumns = 'pkid'; $strValues = 'NULL'; foreach ($arrResult as $strKey => $strValue) { $strColumns .= ', `' . strtolower($strKey) . '`'; if (strlen($strValue)) { $strValues .= ", '" . $objMySql->escape_string($strValue) . "'"; } else { $strValues .= ', NULL'; } } $strSql = sprintf('INSERT INTO `%s` VALUES (%s);', strtolower($strTableName), $strValues); $objMySql->query($strSql); } print " Done.\r\n"; }
function fetch() { if ($this->rows = odbc_fetch_array($this->result)) { return 1; } else { $this->err_no = -1; $this->err_msg = ""; return 0; } }
/** * * @param type $query * @param type $type * @return type */ public function execute($query, $type = null) { $result = array(); switch ($this->db_engine) { case "pgsql": $resultado = pg_query($this->conn, $query); while ($row = pg_fetch_row($resultado)) { $result[] = $row; } pg_close($this->conn); break; case "mssql": $resultado = odbc_exec($this->conn, $query); while ($row = odbc_fetch_array($resultado)) { $result[] = $row; } break; case "mysql": $result = array(); $resultado = mysql_query($query); if (gettype($resultado) == "boolean") { $result = $resultado; } else { while ($row = mysql_fetch_row($resultado)) { $result[] = $row; } } mysql_close($this->conn); break; } return $result; }
function db_fetch($oStmt) { if (function_exists(odbc_fetch_array)) { return odbc_fetch_array($oStmt); } return odbc_fetch_array_hack($oStmt); }
function doquery($query, $table, $fetch = false) { global $link, $debug, $ugamela_root_path; @(include $ugamela_root_path . 'config.php'); if (!$link) { $link = odbc_connect($dbsettings["server"], $dbsettings["user"], $dbsettings["pass"]) or $debug->error(odbc_error() . "<br />{$query}", "SQL Error"); //message(mysql_error()."<br />$query","SQL Error"); odbc_select_db($dbsettings["name"]) or $debug->error(odbc_error() . "<br />{$query}", "SQL Error"); } // por el momento $query se mostrara // pero luego solo se vera en modo debug $sqlquery = odbc_exec($query, str_replace("{{table}}", $dbsettings["prefix"] . $table)) or $debug->error(odbc_error() . "<br />{$query}", "SQL Error"); //message(mysql_error()."<br />$query","SQL Error"); unset($dbsettings); //se borra la array para liberar algo de memoria global $numqueries, $debug; //,$depurerwrote003; $numqueries++; //$depurerwrote003 .= ; $debug->add("<tr><th>Query {$numqueries}: </th><th>{$query}</th><th>{$table}</th><th>{$fetch}</th></tr>"); if ($fetch) { //hace el fetch y regresa $sqlrow $sqlrow = odbc_fetch_array($sqlquery); return $sqlrow; } else { //devuelve el $sqlquery ("sin fetch") return $sqlquery; } }
function listadoProductosPorSO($CODIGOSO) { //realizamos la conexion mediante odbc $conn = odbc_connect("cnx_sistemaBD", "ANDREA", "1234") or die(odbc_errormsg()); $consulta = "SELECT productos.CODIGOPRODUCTO, UPPER(productos.NOMBREPRODUCTO) As NOMBREPRODUCTO, \n productos.DESCRIPCIONPUB, productos.PRECIOPUBLICO, productos.CANTIDADDISPONIBLE, \n productos.TIPOPRODUCTO, productos.ESPECIFICACIONTEC, productos.VIDEO,\n FABRICANTES.NOMBREFABRICANTE , CATEGORIAS.NOMBRECATEGORIA\n FROM productos, fabricantes, categorias where \n productos.FABRICANTES_CODFABRICANTE =FABRICANTES.CODFABRICANTE \n and categorias.CODIGOCATEGORIA= productos.CATEGORIAS_CODIGOCATEGORIA AND productos.SISTEMAOP_CODIGOSO='" . $CODIGOSO . "'\n ORDER BY productos.NOMBREPRODUCTO"; //almacena el resultado de la consulta $resultado = odbc_exec($conn, $consulta) or die(odbc_errormsg()); //exit($resultado); // echo get_resource_type ( $resultado); //crea variable de tipo array $SO = array(); while ($row = odbc_fetch_array($resultado)) { array_push($SO, $row); //$SO = $row; // echo $row['CODIGOPRODUCTO']; //echo $row['DESCRIPCIONPUB']; } //return print_r($SO); if (!json_encode($SO)) { exit("problemas al imprimir con json_encode"); } else { return json_encode($SO); } //cierra la conexion odbc_close($conn); }
function PegaData($banco) { $sql = "SELECT GETDATE() as data ;"; $result = mysql_query($sql, $conexao); $dados = odbc_fetch_array($result); return $dados['data']; }
function _import_db() { // $sql = 'SELECT * FROM provedor ORDER BY nit'; $result = $this->query($sql); while ($row = odbc_fetch_array($result)) { $this->p[] = $row; } odbc_free_result($result); unset($row); // $sql = 'SELECT * FROM constancia ORDER BY exencion'; $result = $this->query($sql); while ($row = odbc_fetch_array($result)) { $this->e[] = $row; } odbc_free_result($result); unset($row); // $sql = 'SELECT * FROM factura ORDER BY exencion, factura'; $result = $this->query($sql); while ($row = odbc_fetch_array($result)) { $this->f[] = $row; } odbc_free_result($result); // return; }
function head_cus($customer_no) { $link = Fconectar(); if ($link) { // Se define la consulta que va a ejecutarse, como en sql $sql_datos_cus = "\n\t\t\t\t\tSELECT C.par_cus_no, C.cus_no, C.cus_name, V1.slspsn_name AS Vendedor, V2.slspsn_name AS Cobrador, C.ar_terms_cd \n\t\t\t\t\tFROM\n\t\t\t\t\tARCUSFIL_SQL AS C,\n\t\t\t\t\tARSLMFIL_SQL AS V1,\n\t\t\t\t\tARSLMFIL_SQL AS V2\n\t\t\t\t\tWHERE\n\t\t\t\t\tC.slspsn_no = V1.slspsn_no AND\n\t\t\t\t\tC.collector = V2.slspsn_no AND\n\t\t\t\t\tC.cus_no = '{$customer_no}'\n\t\t\t\t"; // Se ejecuta la consulta y se guardan los resultados $results = odbc_exec($link, $sql_datos_cus) or die("Error en instruccion SQL {$sql_datos_cus}"); $existe = odbc_num_rows($results); if ($existe) { $registro = odbc_fetch_array($results); $head_cus_no = $registro['cus_no']; $head_cus_name = $registro['cus_name']; $head_ar_terms_cd = $registro['ar_terms_cd']; $head_slspsn_name = $registro['Vendedor']; $head_collector = $registro['Cobrador']; } else { $mensaje = "No existen registros!"; } } else { Ferror("No se pudo establecer coneccion con la Base de Datos!"); } // Se cierra la conexión odbc_close($link); echo "\n\t\t<div align='center'>\n\t\t<table width='40%' border='3' cellpadding='0' cellspacing='10' bordercolor='#DCF3A4' align='center'>\n\t\t\t<th colspan='2'>EDADES DE CARTERA POR CLIENTE (Datos hasta: " . date('d-m-Y') . ")</th>\t\n\t\t\t<tr>\n\t\t\t\t<td>Cliente:</td>\n\t\t\t\t<td>(" . number_format($head_cus_no, 0, '', '') . ") - {$head_cus_name}</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td>Vendedor:</td>\n\t\t\t\t<td>{$head_slspsn_name}</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td>Cobrador:</td>\n\t\t\t\t<td>{$head_collector}</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td>Condición de Pago:</td>\n\t\t\t\t<td>{$head_ar_terms_cd}</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td colspan='2' align='center'>Generado: " . date('d-m-Y H:i:s') . "</td>\n\t\t\t</tr>\n\t\t</table>\n\t\t</div>\n\t\t"; }
public function fetchData($sql) { try { $res = odbc_exec(self::connection(), $sql); //execute sql query using db connection /*var_dump($res);*/ if (!$res) { throw new Exception('odbc error code: ' . odbc_error() . '\\n sql query: ' . $sql); } $arrReturn = array(); //define array to collect channel data //echo odbc_num_rows($res); while ($data = odbc_fetch_array($res)) { // check for all records returned $arrReturn[] = $data; //fetch data into return array from db resultset } self::closeConnection(); // close db connection return $arrReturn; //return array back } catch (Exception $e) { throw new Exception($e->getMessage()); } }
public function setStartCode() { $query = 'SELECT TOP 1 MemberCardNo FROM POS_Member WHERE MemberCardNo LIKE \'T%\' ORDER BY Code DESC'; $res = Processor::execErp($query); $member = odbc_fetch_array($res); $this->code = getArrayVal($member, 'MemberCardNo'); return $this; }
function to_array($res) { if ($array = odbc_fetch_array($res)) { return $array; } else { return false; } }
public function Query($sql) { $rs = odbc_exec($this->db_link, $sql); while ($row = odbc_fetch_array($rs)) { $rows[] = $row; } return $rows; }
function _odbc_num_rows($res) { $rows = 0; while (odbc_fetch_array($res)) { $rows++; } return $rows; }
/** Returns a full list of tables in an array. */ function getTables(){ if ($this->getConn()){ $return = array(); if ($this->getType() == "mysql"){ $f_gt = $this->query("SHOW TABLE STATUS", $this->conn); while($d_gt = $this->query_fetch_assoc($f_gt)){ $return[] = array( "name" => $d_gt[Name], "engine" => $d_gt[Engine], "collation" => $d_gt[Collation], "rows" => $d_gt[Rows] ); } return $return; }elseif($this->getType() == "pgsql"){ $f_gt = $this->query("SELECT relname FROM pg_stat_user_tables ORDER BY relname"); while($d_gt = $this->query_fetch_assoc($f_gt)){ $return[] = array( "name" => $d_gt[relname], "engine" => "pgsql", "collation" => "pgsql" ); } return $return; }elseif($this->getType() == "sqlite" || $this->getType() == "sqlite3"){ $f_gt = $this->query("SELECT name FROM sqlite_master WHERE type = 'table' ORDER BY name"); while($d_gt = $this->query_fetch_assoc($f_gt)){ if ($d_gt["name"] != "sqlite_sequence"){ $return[] = array( "name" => $d_gt[name], "engine" => "sqlite", "collation" => "sqlite" ); } } return $return; }elseif($this->getType() == "access"){ $f_gt = odbc_tables($this->conn); while($d_gt = odbc_fetch_array($f_gt)){ if ($d_gt[TABLE_TYPE] == "TABLE"){ $return[] = array( "name" => $d_gt[TABLE_NAME], "engine" => "access", "collation" => "access" ); } } return $return; }else{ throw new Exception("Not a valid type: " . $this->getType()); } } }
public function fetchAssoc($result) { if (!is_resource($result)) { throw new DbControlException("Ilegal parameter result. Must be valid result resource."); } else { # odbc_fetch_array returns the same array like forexample mysql_fetch_assoc (array associated by colnames) return $row = odbc_fetch_array($result); } }
public function clienteDebug() { $sth = odbc_exec($this->objOdbc, "SELECT CLIE, NOME, CGC FROM SIF01D WHERE CLIE = 1044"); while ($data[] = odbc_fetch_array($sth)) { } $this->Close(); array_pop($data); return $data; }
public static function fetchMightExistMembers($result) { $mightExistMembers = []; $nameQuery = self::getNameQuery(self::getNameList($result)); if ($res = Processor::execErp($nameQuery)) { while ($mightExistMembers[] = odbc_fetch_array($res)) { } } return $mightExistMembers; }
function validaCategoria($strID) { $con = odbc_connect("DRIVER={SQL Server}; SERVER=i9yueekhr9.database.windows.net;\n DATABASE=lotus;", "TSI", "SistemasInternet123"); $SQL = "select count(*) as 'QTD' from PRODUTO where IDPRODUTO = '" . $strID . "'"; $res = odbc_exec($con, $SQL); $RFP = odbc_fetch_array($res); if ($RFP['QTD'] >= 1) { return 1; } else { return 0; } }
function VERICAUSUARIO($login) { $con = odbc_connect("DRIVER={SQL Server}; SERVER=i9yueekhr9.database.windows.net;\n\t\t\t\tDATABASE=lotus;", "TSI", "SistemasInternet123"); $SQL = "SELECT COUNT(*) AS QTD FROM USUARIO WHERE LOGINUSUARIO = '" . $login . "'"; odbc_exec($con, $SQL); $res = odbc_exec($con, $SQL); $RFP = odbc_fetch_array($res); if ($RFP['QTD'] >= 1) { return 0; } else { return 1; } }
public function getRank() { $this->sql = "SELECT [GuildID] FROM [PS_GameData].[dbo].[Guilds] WHERE [Del] = 0\r\t\t\t\t\t ORDER BY [GuildPoint] DESC"; $this->res = odbc_exec($this->link, $this->sql); $this->count = 1; while ($this->fet = odbc_fetch_array($this->res)) { if ($this->fet['GuildID'] == $this->gid) { break; } $this->count++; } return $this->count; }
function odbc_fila($sql, $fila) { $cnn_odbc = odbc_connect("ctw", "", ""); $rs = odbc_exec($cnn_odbc, $sql); $value = "NO_EXISTE"; $value = odbc_fetch_array($rs, 1); odbc_free_result($rs); odbc_close($cnn_odbc); //if(!$rs){ // return odbc_error($rs); //} else { return $value[$fila]; //} }
function ccb_odbc_utility_fetch_array($result) { $finalArray; $ti = 0; $temp; while (1) { $temp = odbc_fetch_array($result); if ($temp == false) { break; } $finalArray[$ti] = $temp; $ti = $ti + 1; } return $finalArray; }
function VerificaUsuario() { $con = odbc_connect("DRIVER={SQL Server}; SERVER=i9yueekhr9.database.windows.net;\n\t\t\tDATABASE=lotus;", "TSI", "SistemasInternet123"); $SQL = "select count(*) AS RESULTADO from usuario where LoginUsuario ='" . $_GET['nome'] . "' and senhaUsuario = '" . $_GET['pass'] . "'"; $res = odbc_exec($con, $SQL); while ($RFP = odbc_fetch_array($res)) { if ($RFP['RESULTADO'] >= 1) { print '<script>alert("Bem Vindo");</script>'; sucess(); } else { print '<script>alert("Usuario nao encontrado");</script>'; nonSucess(); } } }
public function count() { if ($res = odbc_num_rows($this->result) == -1) { $res = 0; $tmp = $this->numrow; $this->moveFirst(); while ($this->next()) { $res++; } $this->numrow = $tmp; odbc_fetch_array($this->result, $tmp); return $res; } else { return $res; } }
function db_fetch_assoc($res) { switch (DATABASE) { case 'mysql': return mysql_fetch_assoc($res); case 'mysqli': return mysqli_fetch_assoc($res); case 'sqlserver': return odbc_fetch_array($res); } }
function fetch_array($resource_array) { global $db_connection_type; switch ($db_connection_type) { case "odbc": $result = odbc_fetch_array($resource_array); break; case "mysql": $result = mysql_fetch_array($resource_array); } return $result; }
function verificaIntegridade2($idProduto) { $con = odbc_connect("DRIVER={SQL Server}; SERVER=i9yueekhr9.database.windows.net;\n\t\tDATABASE=lotus;", "TSI", "SistemasInternet123"); $SQL = "select count(*) as QTD from itempedido where idProduto =" . $idProduto; odbc_exec($con, $SQL); $res = odbc_exec($con, $SQL); $RFP = odbc_fetch_array($res); if ($RFP['QTD'] >= 1) { return false; } else { return true; } }