public function get_json_data() { $lista = json_decode($this->field_list); $base = $this->db->getDB(); $this->conn = odbc_connect("DRIVER={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ={$base}", '', '') or exit('Cannot open with driver.'); if (!$this->conn) { exit("Connection Failed: " . $this->conn); } $rs = odbc_exec($this->conn, $this->sql); if (!$rs) { exit("Error in SQL"); } $value = '['; while (odbc_fetch_row($rs)) { $value .= '['; foreach ($lista as $valor) { $value .= $this->not_null(odbc_result($rs, $valor[0]), $valor[1]) . ','; } $value .= '],'; } $value .= ']'; $value = str_replace(",]", "]", $value); odbc_close_all(); //$value = utf8_encode($value); return $value; }
public function GetOdbcSqlServer($Ip, $User, $Pass, $Db) { $connstr = "Driver={SQL Server};Server={$Ip};Database={$Db}"; echo $connstr . "\n"; $con = odbc_connect($connstr, $User, $Pass, SQL_CUR_USE_ODBC) or False; return $con; }
/** * Connects to a database. * @return void * @throws DibiException */ public function connect(array &$config) { DibiConnection::alias($config, 'username', 'user'); DibiConnection::alias($config, 'password', 'pass'); if (isset($config['resource'])) { $this->connection = $config['resource']; } else { // default values if (!isset($config['username'])) { $config['username'] = ini_get('odbc.default_user'); } if (!isset($config['password'])) { $config['password'] = ini_get('odbc.default_pw'); } if (!isset($config['dsn'])) { $config['dsn'] = ini_get('odbc.default_db'); } if (empty($config['persistent'])) { $this->connection = @odbc_connect($config['dsn'], $config['username'], $config['password']); // intentionally @ } else { $this->connection = @odbc_pconnect($config['dsn'], $config['username'], $config['password']); // intentionally @ } } if (!is_resource($this->connection)) { throw new DibiDriverException(odbc_errormsg() . ' ' . odbc_error()); } }
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; } }
public function changeUserPassword($userName, $userOldPassword, $userNewPassword, $portalID) { VDSN; $conn = odbc_connect(VDSN, USER, PW) or die('ODBC Error:: ' . odbc_error() . ' :: ' . odbc_errormsg() . ' :: ' . VDSN); //test for user name if ($conn) { $sql = "SELECT '1' outputFlag FROM Portal_User WHERE User_Name = '" . $userName . "' AND Portal_ID = '" . $portalID . "'"; $rs = odbc_exec($conn, $sql); $row = odbc_fetch_row($rs); if ($row == null) { odbc_close($conn); return "You have entered an invalid user name; please try again."; } } //test for password if ($conn) { $sql = "SELECT '1' FROM Users WHERE User_Name = '" . $userName . "' AND User_Password = '******'"; $rs = odbc_exec($conn, $sql); $row = odbc_fetch_row($rs); if ($row == null) { odbc_close($conn); return "You have entered an invalid password for your account; please try again."; } } //save new password if ($conn) { $sql = "UPDATE Users SET User_Password = '******' WHERE User_Name = '" . $userName . "'"; $rs = odbc_exec($conn, $sql); } return "OK"; }
/** * Connect to server */ function sql_connect($sqlserver, $sqluser, $sqlpassword, $database, $port = false, $persistency = false, $new_link = false) { $this->persistency = $persistency; $this->user = $sqluser; $this->dbname = $database; $port_delimiter = defined('PHP_OS') && substr(PHP_OS, 0, 3) === 'WIN' ? ',' : ':'; $this->server = $sqlserver . ($port ? $port_delimiter . $port : ''); $max_size = @ini_get('odbc.defaultlrl'); if (!empty($max_size)) { $unit = strtolower(substr($max_size, -1, 1)); $max_size = (int) $max_size; if ($unit == 'k') { $max_size = floor($max_size / 1024); } else { if ($unit == 'g') { $max_size *= 1024; } else { if (is_numeric($unit)) { $max_size = floor((int) ($max_size . $unit) / 1048576); } } } $max_size = max(8, $max_size) . 'M'; @ini_set('odbc.defaultlrl', $max_size); } $this->db_connect_id = $this->persistency ? @odbc_pconnect($this->server, $this->user, $sqlpassword) : @odbc_connect($this->server, $this->user, $sqlpassword); return $this->db_connect_id ? $this->db_connect_id : $this->sql_error(''); }
public function connect() { $this->connection = @odbc_connect(@DNS_ODBC, @USER_ODBC, @PWD_ODBC); if (!$this->connection) { echo "<br>LdODBC Error: não foi possivel conectar do Banco de Dados."; } }
function InsereProduto($NomeProduto, $descProduto, $precProduto, $descontoProduto, $idCategoria, $ativoProduto, $idUsuario, $qtdMinEstoque) { $con = odbc_connect("DRIVER={SQL Server}; SERVER=i9yueekhr9.database.windows.net;\n\t\tDATABASE=lotus;", "TSI", "SistemasInternet123"); $SQL = "insert into produto(nomeProduto, descProduto, precProduto, descontoPromocao, idCategoria, ativoProduto, idUsuario, qtdMinEstoque, imagem)\n\t\tvalues('" . $NomeProduto . "', '" . $descProduto . "', " . $precProduto . ", \n\t\t\t" . $descontoProduto . ", " . $idCategoria . ", " . $ativoProduto . ", " . $idUsuario . ", " . $qtdMinEstoque . ", null)"; odbc_exec($con, $SQL); echo "PRODUTO INSERIDO COM SUCESSO"; }
public function db($query) { $connect = odbc_connect("SIT", "palagi01", "s1mple01"); $result = odbc_exec($connect, $query); return $result; #odbc_close($connect); }
/** * @return bool */ function Connect() { if (!extension_loaded('odbc')) { $this->ErrorDesc = 'Can\'t load ODBC extension.'; setGlobalError($this->ErrorDesc); $this->_log->WriteLine($this->ErrorDesc, LOG_LEVEL_ERROR); return false; } if ($this->_log->Enabled) { $ti = getmicrotime(); } $this->_conectionHandle = @odbc_connect($this->_dbCustomConnectionString, $this->_user, $this->_pass, SQL_CUR_USE_ODBC); if ($this->_conectionHandle && $this->_log->Enabled) { $this->_log->WriteLine(':: connection time -> ' . (getmicrotime() - $ti)); } if ($this->_conectionHandle) { if ($this->_dbType == DB_MYSQL) { @odbc_exec($this->_conectionHandle, 'SET NAMES utf8'); } return true; } else { $this->_setSqlError(); return false; } }
public static function toCti() { if (!(self::$ctiCnx = odbc_connect(env('ODBC_CTI_DSN'), env('ODBC_CTI_USER'), env('ODBC_CTI_PWD'), SQL_CUR_USE_ODBC))) { throw new \Exception('odbc error'); } return self::$ctiCnx; }
public function connect() { $this->link = $this->_config['pconnect'] == 0 ? @odbc_connect($this->_config['dsn'], $this->_config['username'], $this->_config['password'], SQL_CUR_USE_ODBC) : odbc_pconnect($this->_config['dsn'], $this->_config['username'], $this->_config['password'], SQL_CUR_USE_ODBC); if (!$this->link) { $this->halt("Connect to odbc failed"); } }
/** * The connection constructor accepts the following options: * - host (string, required) - hostname * - port (int, optional) - port - default 443 * - user (string, required) - username * - password (string, required) - password * - warehouse (string) - default warehouse to use * - database (string) - default database to use * - tracing (int) - the level of detail to be logged in the driver trace files * - loginTimeout (int) - Specifies how long to wait for a response when connecting to the Snowflake service before returning a login failure error. * - networkTimeout (int) - Specifies how long to wait for a response when interacting with the Snowflake service before returning an error. Zero (0) indicates no network timeout is set. * - queryTimeout (int) - Specifies how long to wait for a query to complete before returning an error. Zero (0) indicates to wait indefinitely. * * @param array $options */ public function __construct(array $options) { $requiredOptions = ['host', 'user', 'password']; $missingOptions = array_diff($requiredOptions, array_keys($options)); if (!empty($missingOptions)) { throw new Exception('Missing options: ' . implode(', ', $missingOptions)); } $port = isset($options['port']) ? (int) $options['port'] : 443; $tracing = isset($options['tracing']) ? (int) $options['tracing'] : 0; $dsn = "Driver=SnowflakeDSIIDriver;Server=" . $options['host']; $dsn .= ";Port=" . $port; $dsn .= ";Tracing=" . $tracing; if (isset($options['loginTimeout'])) { $dsn .= ";Login_timeout=" . (int) $options['loginTimeout']; } if (isset($options['networkTimeout'])) { $dsn .= ";Network_timeout=" . (int) $options['networkTimeout']; } if (isset($options['queryTimeout'])) { $dsn .= ";Query_timeout=" . (int) $options['queryTimeout']; } if (isset($options['database'])) { $dsn .= ";Database=" . $this->quoteIdentifier($options['database']); } if (isset($options['warehouse'])) { $dsn .= ";Warehouse=" . $this->quoteIdentifier($options['warehouse']); } try { $this->connection = odbc_connect($dsn, $options['user'], $options['password']); } catch (\Exception $e) { throw new Exception("Initializing Snowflake connection failed: " . $e->getMessage(), null, $e); } }
/** * Database object constructor * * @access public * @param array List of options used to configure the connection * @since 1.5 * @see bDatabase */ function __construct($options) { $host = array_key_exists('host', $options) ? $options['host'] : 'localhost'; $user = array_key_exists('user', $options) ? $options['user'] : ''; $password = array_key_exists('password', $options) ? $options['password'] : ''; $database = array_key_exists('database', $options) ? $options['database'] : ''; $prefix = array_key_exists('prefix', $options) ? $options['prefix'] : 'jos_'; $select = array_key_exists('select', $options) ? $options['select'] : true; // Requires the direct server path $driver = array(1 => '{Microsoft Access Driver (*.mdb)}', 2 => '{SQL Server Native Client 10.0}', 3 => '{Microsoft Excel Driver (*.xls)}', 4 => '{SQL Server}', 5 => '{Adaptive Server Anywhere 8.0}'); $provider = array(1 => 'Microsoft.ACE.OLEDB.12.0', 2 => 'Microsoft.Jet.OLEDB.4.0'); $dsn = "" . "Driver={$driver['1']};" . "DriverId=281;" . "Data Source=" . $host . $database . ";" . "DefaultDir=" . $host . ";" . "DATABASE=" . $database . ";" . "Servername=localhost;" . "Port=5432;" . "ReadOnly=Yes;" . "Persist Security Info=False;" . "UID=" . $user . ";" . "PWD=" . $password . ";"; echo $dsn . '<BR><BR>'; // perform a number of fatality checks, then return gracefully if (!function_exists('odbc_connect')) { $this->_errorNum = 1; $this->_errorMsg = 'The ODBC adapter "odbc" is not available.'; return; } //echo $dsn; // connect to the server if (!($this->_resource = odbc_connect($dsn, $user, $password, SQL_CUR_USE_ODBC))) { $this->_errorNum = 2; $this->_errorMsg = 'Could not connect to ODBC'; return; } // finalize initialization parent::__construct($options); // select the database if ($select) { $this->select($database); } }
function sql_db($sqlserver, $sqluser, $sqlpassword, $database, $persistency = true) { $mtime = microtime(); $mtime = explode(" ", $mtime); $mtime = $mtime[1] + $mtime[0]; $starttime = $mtime; $this->persistency = $persistency; $this->user = $sqluser; $this->password = $sqlpassword; $this->dbname = $database; $this->server = $sqlserver; if ($this->persistency) { $this->db_connect_id = odbc_pconnect($this->server, "", ""); } else { $this->db_connect_id = odbc_connect($this->server, "", ""); } if ($this->db_connect_id) { @odbc_autocommit($this->db_connect_id, off); $mtime = microtime(); $mtime = explode(" ", $mtime); $mtime = $mtime[1] + $mtime[0]; $endtime = $mtime; $this->sql_time += $endtime - $starttime; return $this->db_connect_id; } else { $mtime = microtime(); $mtime = explode(" ", $mtime); $mtime = $mtime[1] + $mtime[0]; $endtime = $mtime; $this->sql_time += $endtime - $starttime; return false; } }
function connectDB() { $dsn = 'TPDB'; $user = ''; $password = ''; $con = odbc_connect($dsn, $user, $password); return $con; }
public function try_connect($login, $pasw, $db_name = NULL) { if ($db_name == NULL || empty($db_name)) { $db_name = $this->db; } $try_dsn = sprintf("Driver={%s};UID=%s;PWD=%s;DBQ=%s", $this->drvr, $login, $pasw, $db_name); return odbc_connect($try_dsn, NULL, NULL); }
/** * Connect to the database */ public function db_connect() { /**================================================================== * Connect to the user databsae ====================================================================*/ $this->link = odbc_connect($this->c_ident['host'], $this->c_ident['user'], $this->c_ident['password']); /*===================================================================*/ }
/** * @return boolean successfully connected or not */ public function connect() { // No changes needed from now on $connection_string = "Driver={$this->driver};Server={$this->host};Database={$this->dbname}"; // $connection_string = "DSN=testdsn"; $this->connection = @odbc_connect($connection_string, $this->user, $this->pass); return $this->connection; }
function db_connect($oArray) { $oCon = odbc_connect($oArray[2], $oArray[0], $oArray[1]); if (!$oCon) { die("could not connect"); } return $oCon; }
function DeletarProduto($idProduto) { $con = odbc_connect("DRIVER={SQL Server}; SERVER=i9yueekhr9.database.windows.net;\n\t\tDATABASE=lotus;", "TSI", "SistemasInternet123"); //$SQL = 'SELECT COUNT(*) AS QTD FROM ESTOQUE WHERE IDPRODUTO='.$idProduto; $SQL = 'delete from produto where idproduto = ' . $idProduto; echo "PRODUTO EXCLUIDO COM SUCESSO"; odbc_exec($con, $SQL); }
public function getConnection_mssql() { $host = "vasquez-pc"; $dbname = "tramites"; $user = "******"; $password = "******"; $conn = odbc_connect("Driver={SQL Server Native Client 10.0};Server={$host};Database={$dbname};", $user, $password); return $conn; }
/** * check the connection. * * @return void */ public static function chkConnect($config) { $conid = @odbc_connect($config['dsn'], $config['username'], $config['password'], SQL_CUR_USE_ODBC); if (odbc_error()) { //return odbc_errormsg(); //SQL Server 2005 不支持 utf-8 编码,其使用 UCS-2 编码架构(所有 unicode 字符都占用 2 个字节)。 return 'connect failed'; } return true; }
public function connect($config = array()) { $this->config = $config; $dsn = !empty($this->config['dsn']) ? $this->config['dsn'] : 'DRIVER=' . $this->config['host'] . ';SERVER=' . $this->config['server'] . ';DATABASE=' . $this->config['database']; $this->connect = $this->config['pconnect'] === true ? @odbc_pconnect($dsn, $this->config['user'], $this->config['password']) : @odbc_connect($dsn, $this->config['user'], $this->config['password']); if (empty($this->connect)) { die(getErrorMessage('Database', 'mysqlConnectError')); } }
function _connect($argDSN, $argUsername, $argPassword, $argDatabasename) { global $php_errormsg; $php_errormsg = ''; $this->_connectionID = odbc_connect($argDSN, $argUsername, $argPassword, $this->curmode); $this->_errorMsg = $php_errormsg; //if ($this->_connectionID) odbc_autocommit($this->_connectionID,true); return $this->_connectionID != false; }
/** * 连接数据库,参数与 odbc_connect 相同 * * 连接成功后存储在$this->db 中,无返回,出错则返回错误信息 * * @version 0.13.9.28 * @param unknown $dsn * @param unknown $user * @param unknown $password * @param string $cursor_type * @return multitype:string */ function connect($dsn, $user, $password, $cursor_type = null) { $this->db = odbc_connect($dsn, $user, $password, $cursor_type); // 连接数据库 if (false === $this->db) { return array('error' => '错误代码' . odbc_error() . '。错误信息:' . odbc_errormsg()); } // 出错时返回错误代码 }
function connect() { if (0 == $this->Link_ID) { $this->Link_ID = odbc_connect($this->Database, $this->User, $this->Password, $this->UseODBCCursor); if (!$this->Link_ID) { $this->halt("Link-ID == false, connect failed"); } } }
function DBGetConnection($name, $db, $user, $password) { // Establece una conexión con el servidor Oracle.. $conn = odbc_connect($name, $user, $password); if (!$conn) { echo "Error al conectarse al servidor de la base de datos."; } return $conn; }
function sql_connect($sqlserver, $sqluser, $sqlpassword, $database, $port = false, $persistency = false) { $this->persistency = $persistency; $this->user = $sqluser; $this->server = $sqlserver . ($port ? ':' . $port : ''); $this->dbname = $database; $this->db_connect_id = $this->persistency ? @odbc_pconnect($this->server, $this->user, $sqlpassword) : @odbc_connect($this->server, $this->user, $sqlpassword); return $this->db_connect_id ? $this->db_connect_id : $this->sql_error(''); }
/** * Connect to server */ function sql_connect($sqlserver, $sqluser, $sqlpassword, $database, $port = false, $persistency = false, $new_link = false) { $this->persistency = $persistency; $this->user = $sqluser; $this->server = $sqlserver . (($port) ? ':' . $port : ''); $this->dbname = $database; $max_size = @ini_get('odbc.defaultlrl'); if (!empty($max_size)) { $unit = strtolower(substr($max_size, -1, 1)); $max_size = (int) $max_size; if ($unit == 'k') { $max_size = floor($max_size / 1024); } else if ($unit == 'g') { $max_size *= 1024; } else if (is_numeric($unit)) { $max_size = floor((int) ($max_size . $unit) / 1048576); } $max_size = max(8, $max_size) . 'M'; @ini_set('odbc.defaultlrl', $max_size); } $this->db_connect_id = ($this->persistency) ? @odbc_pconnect($this->server, $this->user, $sqlpassword) : @odbc_connect($this->server, $this->user, $sqlpassword); return ($this->db_connect_id) ? $this->db_connect_id : $this->sql_error(''); }