function disconnect() { if ($this->connectionId) { mssql_close($this->connectionId); $this->connectionId = null; } }
/** Disconnects from database * */ function disconnect() { if (DB_TYPE == 'sqlsrv') { if (@sqlsrv_close($this->_dbHandle) != 0) { return 1; } else { return 0; } } else { if (DB_TYPE == 'mssql') { if (@mssql_close($this->_dbHandle) != 0) { return 1; } else { return 0; } } else { if (DB_TYPE == 'mysql') { if (@mysql_close($this->_dbHandle) != 0) { return 1; } else { return 0; } } } } }
function __destruct() { if ($this->link) { mssql_close($this->link); } $this->link = null; }
public function __destruct() { /* | About: | -> Close the connection and returns the elapsed time. */ if (!empty($this->connection['debugMode'])) { $this->errorHandling(); } switch ($this->connection['db_type']) { case 'mysql': $this->conn->close(); break; case 'mssql': mssql_close($this->conn); break; case 'sqlserv': sqlsrv_close($this->conn); break; case 'pgsql': pg_close($this->conn); break; } return $this->elapsedTime(); }
function dbactionAdd() { print "starting\n"; if (!windowsOs()) { throw new lxException('mssql_is_only_on_windows', '', ''); } print "\n mantu\n"; $req = mssql_connect("localhost,1433"); if (!$req) { throw new lxException('MsSql Connection is Failed', '', ''); } $loginname = $this->main->username; $dbname = $loginname; print "\n" . $loginname; $pass = $this->main->dbpassword; print "\n" . $pass; $result = mssql_query("select loginname from syslogins where loginname='{$loginname}'"); $row = mssql_fetch_array($result, MSSQL_ASSOC); if (!$row) { mssql_query("sp_addlogin '{$loginname}', '{$pass}'"); } else { print "user already exist by this name\n"; throw new Exception("couldn't create {$loginname}--already user exist\n"); } print "executing\n"; try { mssql_query("create database {$dbname}"); } catch (Exception $e) { print "\n ERROR: Create database"; } mssql_query("use {$dbname}"); mssql_query("sp_adduser '{$loginname}', '{$loginname}', 'db_owner'"); mssql_close(); print "\ndone\n"; }
/** * 关闭数据库连接 */ function close() { if ($this->conn) { mssql_close($this->conn); } parent::close(); }
public function closeConnection() { if ($this->isConnected()) { mssql_close($this->_connection); } $this->_connection = null; }
function sql_close() { $mtime = microtime(); $mtime = explode(" ", $mtime); $mtime = $mtime[1] + $mtime[0]; $starttime = $mtime; if ($this->db_connect_id) { // // Commit any remaining transactions // if ($this->in_transaction) { @mssql_query("COMMIT", $this->db_connect_id); } $mtime = microtime(); $mtime = explode(" ", $mtime); $mtime = $mtime[1] + $mtime[0]; $endtime = $mtime; $this->sql_time += $endtime - $starttime; return @mssql_close($this->db_connect_id); } else { $mtime = microtime(); $mtime = explode(" ", $mtime); $mtime = $mtime[1] + $mtime[0]; $endtime = $mtime; $this->sql_time += $endtime - $starttime; return false; } }
/** * 关闭数据库,如果数据库连接已经打开则关闭它 * 请在调用connect()并处理后使用close() * * @return void */ public function close() { if ($this->linkId) { mssql_close($this->linkId); $this->linkId = false; } }
function getProductos() { $myServer = "172.30.5.49"; $myUser = "******"; $myPass = "******"; $myDB = "LAUMAYER"; $dbhandle = mssql_connect($myServer, $myUser, $myPass) or die("Couldn't connect to SQL Server on {$myServer}"); $selected = mssql_select_db($myDB, $dbhandle) or die("Couldn't open database {$myDB}"); //Realiza el query en la base de datos $mysqli = makeSqlConnection(); //$sql = "SELECT * FROM psg_productos a LEFT JOIN psg_productos_cstm ac ON a.id = ac.id_c"; $sql = "SELECT id,name FROM psg_productos where deleted ='0'"; $res = $mysqli->query($sql); $rows = array(); while ($r = mysqli_fetch_assoc($res)) { $obj = (object) $r; $querySaldo = "Select dbo.F_Saldo_Bodega_Informe(Year(GETDATE()),MONTH(GETDATE()),'" . $r['id'] . "','BODPRDCTO','T','C') as Saldo"; $result = mssql_query($querySaldo); if ($row = mssql_fetch_array($result)) { $obj->saldo = $row['Saldo']; } $a = (array) $obj; $rows[] = $a; } mssql_close($dbhandle); if (empty($rows)) { return '{"results" :[]}'; } else { //Convierte el arreglo en json y lo retorna $temp = json_encode(utf8ize($rows)); return '{"results" :' . $temp . '}'; } }
/** * MSSQL::close() * * Close the connection * * @return bool * @access public * @author Teye Heimans */ function close() { if ($this->_isConnected) { $this->_isConnected = false; return mssql_close($this->_conn); } }
function Connect() { if ($this->connection != 0) { if (!strcmp($this->connected_host, $this->host) && !strcmp($this->connected_user, $this->user) && !strcmp($this->connected_password, $this->password) && $this->opened_persistent == $this->persistent) { return 1; } $this->Close(); } $function = $this->persistent ? "mssql_pconnect" : "mssql_connect"; if (!function_exists($function)) { return $this->SetError("Connect", "Microsoft SQL server support is not available in this PHP configuration"); } if (($this->connection = @$function($this->host, $this->user, $this->password)) <= 0) { return $this->SetMSSQLError("Connect", "Could not connect to the Microsoft SQL server"); } if (strcmp($this->database_name, "") && !@mssql_select_db($this->database_name, $this->connection)) { $this->SetMSSQLError("Connect", "Could not select a Microsoft SQL server database"); mssql_close($this->connection); $this->connection = 0; return 0; } $this->selected_database = $this->database_name; if (!$this->auto_commit && !$this->DoQuery("BEGIN TRANSACTION")) { $this->SetMSSQLError("Connect", "Could not begin the initial transaction"); mssql_close($this->connection); $this->connection = 0; return 0; } $this->connected_host = $this->host; $this->connected_user = $this->user; $this->connected_password = $this->password; $this->opened_persistent = $this->persistent; return 1; }
/** * Close the connection to the database if still connected. * * @return bool Returns TRUE if the connection was closed, FALSE if it failed. */ function Close() { if (mssql_close($this->link)) { $this->link = NULL; return TRUE; } return FALSE; }
function disconnect() { if (!$this->link_identifier) { return; } @mssql_close($this->link_identifier); $this->link_identifier = false; }
/** * Disconnect * * @return bool success */ public function close() { if ($this->handle && ($r = mssql_close($this->handle))) { $this->handle = NULL; return $r; } return FALSE; }
public function close() { //$this->dispatchEvent('preClose', $this); if ($this->conn_id && $this->state != self::CLOSED) { $this->state = self::CLOSED; mssql_close($this->conn_id); } //$this->dispatchEvent('posClose', $this); }
/** * Database object destructor * * @return boolean * @since 1.5 */ function __destruct() { $return = false; if (is_resource($this->_resource)) { $return = mssql_close($this->_resource); $this->connected = false; } return $return; }
/** * This function closes an open connection. * * @access public * @override * @return boolean whether an open connection was closed */ public function close() { if ($this->is_connected()) { if (!@mssql_close($this->resource)) { return FALSE; } $this->resource = NULL; } return TRUE; }
protected function close() { $msclose = mssql_close($this->connection); if ($msclose === FALSE) { wLog(get_class($this), "Couldn't close db connection"); wLog(get_class($this), "Last message on server was: " . mssql_get_last_message()); die("Couldn't close db connection"); } return; }
public function close() { $this->conn_open = false; if (!$this->reuse_connection) { if ($this->handle && !$this->data_result) { return mssql_close($this->handle); } } return true; }
function close() { if ($this->dbh === false) { return; } if (isset($this->mssql)) { @mssql_close($this->dbh); } else { @mysql_close($this->dbh); } }
function CanConnectDatabase() { global $dcl_domain_info, $dcl_domain; $conn = mssql_connect($dcl_domain_info[$dcl_domain]['dbHost'], $dcl_domain_info[$dcl_domain]['dbUser'], $dcl_domain_info[$dcl_domain]['dbPassword']); if ($conn > 0) { $bRetVal = mssql_select_db($dcl_domain_info[$dcl_domain]['dbName'], $conn); mssql_close($conn); return $bRetVal; } return false; }
public function __destruct() { if ($this->activeTransaction) { if ($this->autoCommit) { $this->transactionCommit(); } else { $this->transactionRollback(); } } @mssql_close($this->connection); }
/** * @return bool */ function Disconnect() { $result = true; if ($this->_conectionHandle) { $this->FreeResult(); $result = @mssql_close($this->_conectionHandle); $this->_conectionHandle = null; return $result; } else { return false; } }
/** * @see ILumine_Connection::close() */ public function close() { $this->dispatchEvent(new Lumine_ConnectionEvent(Lumine_Event::PRE_CLOSE, $this)); if ($this->conn_id && $this->state != self::CLOSED) { Lumine_Log::debug('Liberando resultados todos os resultados'); Lumine_Dialect_Factory::getByName('MsSQL')->freeAllResults(); $this->state = self::CLOSED; Lumine_Log::debug('Fechando conexao com ' . $this->getDatabase()); mssql_close($this->conn_id); } $this->dispatchEvent(new Lumine_ConnectionEvent(Lumine_Event::POS_CLOSE, $this)); }
private function close($connection) { $msclose = mssql_close($connection); if ($msclose === FALSE) { $msg = "Couldn't close connection {$mssqlDB} \n"; file_put_contents(RTD2SQL_log_main, date("YmdHis ") . $msg, FILE_APPEND); $msg = "Last message on server was: " . mssql_get_last_message() . "\n"; file_put_contents(RTD2SQL_log_main, date("YmdHis ") . $msg, FILE_APPEND); die("Couldn't close connection {$mssqlDB}"); } return; }
/** * Close an MSSQL database */ function close() { $this->mOpened = false; if ($this->mConn) { if ($this->trxLevel()) { $this->immediateCommit(); } return mssql_close($this->mConn); } else { return true; } }
public function DBClose(){ switch($this->sqltype){ case 'mysql': mysql_close(); break; case 'mssql': mssql_close(); break; default: break; } $this->cn = null; }
function __destruct() { //close the connection switch ($this->_engine) { case "mssql": mssql_close($this->_dbhandle); break; case "mysql": mysql_close($this->_dbhandle); break; } $this->_client = null; }
function checkToken($token) { global $url_login, $url_authenn, $sys_code; if (isset($token)) { $data = getAuthen($token); if (isset($data->BappGetSessionResult->Username)) { $_SESSION["user_name"] = sprintf("%08s", $data->BappGetSessionResult->Username); $_SESSION["name"] = $data->BappGetSessionResult->FullNameTH; $_SESSION['token'] = $token; $_SESSION['image_url'] = $data->BappGetSessionResult->ImageUrl; // Role $conn = ConnectDB(); $sql = "select ROLE_CODE from DB_DS.DBO.GET_ROLE_BY_PER_SYSID ('" . sprintf("%08s", $_SESSION["user_name"]) . "', '" . $sys_code . "')"; $query = mssql_query($sql); $row = mssql_fetch_array($query, MSSQL_ASSOC); $_SESSION["role"] = $row['ROLE_CODE']; mssql_free_result($query); mssql_close($conn); header('Location: /meeting/index.php'); } else { header('Location: ' . $url_login); } } else { header('Location: ' . $url_login); } }