public function Query($Procedimiento, $RetornaDatos, $arrayValores = "")
{
$parametros = array();
$NombreServidor = constant("sqlHost");
$InfoConexion = array("UID" => constant("sqlUsuario"), "PWD" => constant("sqlContrasena"), "Database" => $this->NombreBaseDatos);
$conn = sqlsrv_connect($NombreServidor, $InfoConexion);
if (is_array($arrayValores)) {
$stringInterrogacion = "(?";
for ($i = 1; $i < count($arrayValores); $i++) {
$stringInterrogacion .= ",?";
}
$stringInterrogacion .= ")";
$Procedimiento = "{call " . $Procedimiento . " " . $stringInterrogacion . "}";
for ($i = 0; $i < count($arrayValores); $i++) {
array_push($parametros, array($arrayValores[$i], SQLSRV_PARAM_IN));
}
} else {
$Procedimiento = "{call " . $Procedimiento . "}";
}
$stmt3 = sqlsrv_query($conn, $Procedimiento, $parametros);
if ($RetornaDatos) {
$array = array();
while ($obj = sqlsrv_fetch_array($stmt3, SQLSRV_FETCH_ASSOC)) {
$array[] = $obj;
}
return $array;
sqlsrv_free_stmt($stmt3);
}
sqlsrv_close($conn);
}
/**
* Establishes a connection to the database.
* Includes php_interface/after_connect_d7.php on success.
* Throws exception on failure.
*
* @return void
* @throws \Bitrix\Main\DB\ConnectionException
*/
protected function connectInternal()
{
if ($this->isConnected) {
return;
}
$connectionInfo = array("UID" => $this->login, "PWD" => $this->password, "Database" => $this->database, "ReturnDatesAsStrings" => true);
if (($this->options & self::PERSISTENT) != 0) {
$connectionInfo["ConnectionPooling"] = true;
} else {
$connectionInfo["ConnectionPooling"] = false;
}
$connection = sqlsrv_connect($this->host, $connectionInfo);
if (!$connection) {
throw new ConnectionException('MS Sql connect error', $this->getErrorMessage());
}
$this->resource = $connection;
$this->isConnected = true;
// hide cautions
sqlsrv_configure("WarningsReturnAsErrors", 0);
/** @noinspection PhpUnusedLocalVariableInspection */
global $DB, $USER, $APPLICATION;
if ($fn = \Bitrix\Main\Loader::getPersonal("php_interface/after_connect_d7.php")) {
include $fn;
}
}
/**
* Connects to a database.
* @return void
* @throws Dibi\Exception
*/
public function connect(array &$config)
{
Helpers::alias($config, 'options|UID', 'username');
Helpers::alias($config, 'options|PWD', 'password');
Helpers::alias($config, 'options|Database', 'database');
Helpers::alias($config, 'options|CharacterSet', 'charset');
if (isset($config['resource'])) {
$this->connection = $config['resource'];
} else {
$options =& $config['options'];
// Default values
if (!isset($options['CharacterSet'])) {
$options['CharacterSet'] = 'UTF-8';
}
$options['PWD'] = (string) $options['PWD'];
$options['UID'] = (string) $options['UID'];
$options['Database'] = (string) $options['Database'];
$this->connection = sqlsrv_connect($config['host'], $options);
}
if (!is_resource($this->connection)) {
$info = sqlsrv_errors();
throw new Dibi\DriverException($info[0]['message'], $info[0]['code']);
}
$this->version = sqlsrv_server_info($this->connection)['SQLServerVersion'];
}
private function connect()
{
$this->conn = sqlsrv_connect($this->server, array("Database" => $this->db, "UID" => $this->user, "PWD" => $this->pw));
if ($this->conn === false) {
die(print_r(sqlsrv_errors(), true));
}
}
private function getDbConnect($address, $account, $pwd, $name)
{
if (DB_TYPE == 'mssql') {
return mssql_connect($address, $account, $pwd);
}
if (DB_TYPE == 'sqlsrv') {
if (defined('DBITPro_Dev')) {
$connectionInfo = array("UID" => $account, "PWD" => $pwd, "Database" => $name);
} else {
$connectionInfo = array("UID" => $account, "PWD" => $pwd, "Database" => $name);
}
$conn = sqlsrv_connect($address, $connectionInfo);
if (false === $conn) {
echo "Could not connect.\n";
die(print_r(sqlsrv_errors(), true));
}
return $conn;
}
if (DB_TYPE == 'mysql') {
$conn = mysql_connect($address, $account, $pwd);
if (false === $conn) {
echo "Could not connect.\n";
die(print_r(mysql_errors(), true));
}
return $conn;
}
}
public function Ymssql($url)
{
$url = parse_url($url);
// Check if SQLSRV support is present in PHP
if (!function_exists('sqlsrv_connect')) {
die('Unable to use the Microsoft SQL Server database because the SQLSRV extension for PHP is not installed. Check your <code>php.ini</code> to see how you can enable it.');
}
// Decode url-encoded information in the db connection string
$url['user'] = urldecode($url['user']);
// Test if database url has a password.
$url['pass'] = isset($url['pass']) ? urldecode($url['pass']) : '';
$url['host'] = urldecode($url['host']);
$url['path'] = urldecode($url['path']);
// Allow for non-standard port.
if (isset($url['port'])) {
$url['host'] = $url['host'] . ', ' . $url['port'];
}
$connectionInfo = array("Database" => substr($url['path'], 1), "UID" => $url['user'], "PWD" => $url['pass']);
$connection = @sqlsrv_connect($url['host'], $connectionInfo);
if (!$connection) {
// Show error screen otherwise
throw new Exception(print_r(sqlsrv_errors(), true));
}
$this->lnk = $connection;
}
function getDentrix()
{
# PHPinfo();
$connInfo = array("Database" => "dentrix", "UID" => "jl149", "PWD" => "l3tm31n", "ReturnDatesAsStrings" => true);
$dentrix = sqlsrv_connect("192.168.14.55,1435", $connInfo);
return $dentrix;
}
/**
* @return false|mysqli|resource
*/
public function connect()
{
try {
if ($this->DRIVER == "sqlsrv") {
$server_name = $this->HOST_NAME . "," . $this->PORT;
$dbection_info = array("Database" => $this->DATABASE, "UID" => $this->USER, "PWD" => $this->PASSWORD);
$db = sqlsrv_connect($server_name, $dbection_info);
if ($db === false) {
die(print_r(sqlsrv_errors(), true));
} else {
return $db;
}
} else {
if ($this->DRIVER == "mysqli") {
$db = new mysqli($this->HOST_NAME, $this->USER, $this->PASSWORD, $this->DATABASE, $this->PORT);
if ($db->connect_error) {
die('Connect Error (' . $db->connect_errno . ') ' . $db->connect_error);
}
return $db;
} else {
die("Driver not found!");
}
}
} catch (Exception $e) {
var_dump("Error: {$e->getMessage()}");
return;
}
}
function GetFacultyQuestions($groupid)
{
include_once 'db_Connection.php';
$conn = sqlsrv_connect($serverName, $connectionInfo);
$questionvalues = array();
$questions = array();
$faculty = array();
$facultyquestions = array();
if ($conn) {
//----get acadyear-------------------
$acid = 0;
$sqlstr = " SELECT [AcadYearID] FROM [dbo].[Groups] where [groupid]=? ";
$params = array($groupid);
$sqlquery = sqlsrv_query($conn, $sqlstr, $params);
if ($sqlquery) {
while ($row = sqlsrv_fetch_array($sqlquery, SQLSRV_FETCH_ASSOC)) {
$acid = $row['AcadYearID'];
}
sqlsrv_free_stmt($sqlquery);
}
$sqlstr = " SELECT [questionTypeId],[value],[text] " . " FROM [dbo].[QuestionValues] " . " order by questionTypeId ";
// $params = array ($acid);
$sqlquery = sqlsrv_query($conn, $sqlstr);
if ($sqlquery) {
while ($row = sqlsrv_fetch_object($sqlquery)) {
$questionvalues[] = $row;
}
sqlsrv_free_stmt($sqlquery);
}
//----get question array-------------------
$sqlstr = " SELECT [QuestionID],[QueastionText],[questionType],[maxmark],-1 as mark,'' as description " . " FROM [dbo].[Questions] " . " where [QuestionLecturer]=0 " . " and [Acadyear]=? ";
$params = array($acid);
$sqlquery = sqlsrv_query($conn, $sqlstr, $params);
if ($sqlquery) {
while ($row = sqlsrv_fetch_object($sqlquery)) {
$row->questionValues = array();
foreach ($questionvalues as &$questValue) {
if ($questValue->questionTypeId === $row->questionType) {
array_push($row->questionValues, $questValue);
}
}
$questions[] = $row;
}
sqlsrv_free_stmt($sqlquery);
}
//----get faculty-------------------
$sqlstr = " SELECT [FacultyID],[FacultyName] FROM [dbo].[Groups] " . " where [groupid]=? ";
$params = array($groupid);
$sqlquery = sqlsrv_query($conn, $sqlstr, $params);
if ($sqlquery) {
while ($row = sqlsrv_fetch_object($sqlquery)) {
$row->quests = $questions;
$faculty[] = $row;
}
$facultyquestions = array("result" => 0, "data" => $faculty);
}
sqlsrv_close($conn);
}
return $facultyquestions;
}
public function AttemptConnection()
{
if (empty($this->type)) {
return false;
} elseif ($this->type == "MySQL") {
$this->connection = mysqli_connect($this->address, $this->username, $this->password, $this->database);
if (!$this->connection) {
$this->lastErrorMessage = "Error: Unable to connect to MySQL." . PHP_EOL . "Debugging errno: " . mysqli_connect_errno() . PHP_EOL . "Debugging error: " . mysqli_connect_error() . PHP_EOL;
return false;
}
//SQL Server
} elseif ($this->type == "MSSQL") {
$connectionInfo = array("Database" => $this->database, "UID" => $this->username, "PWD" => $this->password);
$this->connection = sqlsrv_connect($this->address, $connectionInfo);
if (!$this->connection) {
$errorString = "";
if (($errors = sqlsrv_errors()) != null) {
foreach ($errors as $error) {
$errorString .= PHP_EOL . "~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~" . PHP_EOL;
$errorString .= "SQLSTATE: " . $error['SQLSTATE'] . PHP_EOL;
$errorString .= "code: " . $error['code'] . PHP_EOL;
$errorString .= "message: " . $error['message'] . PHP_EOL;
}
}
$this->lastErrorMessage = "Error: Unable to connect to SQL Server." . PHP_EOL . "Debugging error: " . $errorString . PHP_EOL;
$this->lastError = $errorString;
return false;
}
}
return $this->connection;
}
public function connect($url, $username, $password)
{
if (!function_exists('sqlsrv_connect')) {
return false;
}
$tmp = parse_url($url);
if (!array_key_exists('scheme', $tmp) || $tmp['scheme'] != 'sqlserver') {
throw new DataAccessException("데이터베이스 스키마가 드라이버와 일치하지 않습니다.");
}
$arrTmp = explode(';', $tmp['host']);
$arrOptions = array();
foreach ($arrTmp as $option) {
if (trim($option) == '') {
continue;
}
if (substr_count($option, '=') > 0) {
list($k, $v) = explode('=', $option, 2);
$arrOptions[$k] = $v;
} else {
$arrOptions['host'] = $option;
}
}
if (!array_key_exists('DatabaseName', $arrOptions)) {
throw new DataAccessException("데이터베이스 명이 누락되었습니다.");
}
$characterSet = !array_key_exists('CharacterSet', $arrOptions) ? 'UTF-8' : $arrOptions['CharacterSet'];
$this->_host = $arrOptions['host'];
try {
$this->_conn = sqlsrv_connect($this->_host, array("Database" => $arrOptions['DatabaseName'], "UID" => $username, "PWD" => $password, "CharacterSet" => $characterSet));
} catch (Exception $ex) {
throw $ex;
}
$this->_connected = $this->_conn ? true : false;
return $this->_connected;
}
function dbcall()
{
session_start();
$seubid = (string) session_id();
$server = "bamsql2";
$options = array("UID" => "genes", "PWD" => "Genes12", "Database" => "genes");
$conn = sqlsrv_connect($server, $options);
if ($conn === false) {
die("<pre>" . print_r(sqlsrv_errors(), true));
}
$rno = $_POST['Rnumber'];
$name = $_POST['name'];
$email = $_POST['email'];
$gender = $_POST['gender'];
$sql = "insert INTO dbo.contactinfo values('{$rno}','{$name}','{$email}','{$gender}')";
$query = sqlsrv_query($conn, $sql);
if ($query === false) {
exit("<pre>" . print_r(sqlsrv_errors(), true));
}
#while ($row = sqlsrv_fetch_array($query))
# { echo "<p>Hello, $row[ascore]!</p>";
#}
sqlsrv_free_stmt($query);
sqlsrv_close($conn);
}
public function connect($parameters, $selectDB = false)
{
// Disable default warnings as errors behaviour for sqlsrv to keep it in line with mssql functions
if (ini_get('sqlsrv.WarningsReturnAsErrors')) {
ini_set('sqlsrv.WarningsReturnAsErrors', 'Off');
}
$charset = isset($parameters['charset']) ? $parameters : 'UTF-8';
$multiResultSets = isset($parameters['multipleactiveresultsets']) ? $parameters['multipleactiveresultsets'] : true;
$options = array('CharacterSet' => $charset, 'MultipleActiveResultSets' => $multiResultSets);
if (!(defined('MSSQL_USE_WINDOWS_AUTHENTICATION') && MSSQL_USE_WINDOWS_AUTHENTICATION == true) && empty($parameters['windowsauthentication'])) {
$options['UID'] = $parameters['username'];
$options['PWD'] = $parameters['password'];
}
// Required by MS Azure database
if ($selectDB && !empty($parameters['database'])) {
$options['Database'] = $parameters['database'];
}
$this->dbConn = sqlsrv_connect($parameters['server'], $options);
if (empty($this->dbConn)) {
$this->databaseError("Couldn't connect to SQL Server database");
} elseif ($selectDB && !empty($parameters['database'])) {
// Check selected database (Azure)
$this->selectedDatabase = $parameters['database'];
}
}
public function connect()
{
if ($this->_connection) {
return;
}
// Extract the connection parameters, adding required variabels
$mssql_config = $this->_config['connection'] + array('Database' => '', 'Server' => '', 'UID' => '', 'PWD' => '', 'ConnectionPooling' => FALSE, 'CharacterSet' => 'UTF-8');
// Extract the Server name
$server = $mssql_config['Server'];
// Prevent this information from showing up in traces
unset($mssql_config['Server'], $this->_config['connection']['UID'], $this->_config['connection']['PWD']);
// If any illegal properties is in $mssql_config, sqlsrv_connect won't connect
unset($mssql_config['hostname'], $mssql_config['database'], $mssql_config['username'], $mssql_config['password'], $mssql_config['persistent']);
try {
// Create a connection
$this->_connection = sqlsrv_connect($server, $mssql_config);
$errors = sqlsrv_errors(SQLSRV_ERR_ALL);
if ($this->_connection === FALSE) {
throw new Database_Sqlsrv_Exception(':error, :sqlstate', array(':error' => $errors[0]['message'], ':sqlstate' => $errors[0]['SQLSTATE']), $errors[0]['code']);
}
} catch (ErrorException $e) {
$errors = sqlsrv_errors(SQLSRV_ERR_ALL);
throw new Database_Sqlsrv_Exception(':error, :sqlstate', array(':error' => $errors[0]['message'], ':sqlstate' => $errors[0]['SQLSTATE']), $errors[0]['code']);
}
// \xFF is a better delimiter, but the PHP driver uses underscore
$this->_connection_id = sha1($server . '_' . $mssql_config['UID'] . '_' . $mssql_config['PWD']);
}
function OpenConnection()
{
global $mysqlAuthentication;
global $sqlserverAuthentication;
$host = null;
$options = null;
if (isset($mysqlAuthentication)) {
$host = $mysqlAuthentication["host"];
$options = $mysqlAuthentication;
}
if ($this->databaseType == 'mySql' || $this->databaseType == 'both') {
$this->mysqlConnection = @mysql_connect($host, $options["username"], $options["password"]);
}
if (isset($this->mysqlConnection)) {
@mysql_set_charset("utf8");
@mysql_select_db($options["database"], $this->mysqlConnection);
}
if (isset($sqlserverAuthentication)) {
$host = $sqlserverAuthentication["host"];
$options = array("Database" => $sqlserverAuthentication["database"], "CharacterSet" => "UTF-8", "UID" => $sqlserverAuthentication["username"], "PWD" => $sqlserverAuthentication["password"]);
}
if ($this->databaseType == 'sqlServer' || $this->databaseType == 'both') {
$this->sqlserverConnection = sqlsrv_connect($host, $options);
}
}
protected function connect()
{
if ($this->lnk === null) {
$options = $this->settings->options;
$options['Database'] = $this->settings->database;
$options['ReturnDatesAsStrings'] = true;
if ($this->settings->username) {
$options['UID'] = $this->settings->username;
}
if ($this->settings->password) {
$options['PWD'] = $this->settings->password;
}
if ($this->settings->charset) {
//$options["CharacterSet"] = strtoupper($this->settings->charset);
}
$server = $this->settings->servername;
if (isset($this->settings->serverport) && $this->settings->serverport) {
$server .= ', ' . $this->settings->serverport;
}
$this->lnk = @sqlsrv_connect($server, $options);
if ($this->lnk === false) {
throw new DatabaseException('Connect error');
}
}
}
function SaveLecturerMarks($marks)
{
$status = array();
include_once 'db_Connection.php';
$conn = sqlsrv_connect($serverName, $connectionInfo);
if ($conn) {
$login = "******";
$subjectid = 0;
$subjtype = 0;
$lectid = 0;
$qid = 0;
$mark = 0;
$ldescription = "0";
$sqlstr = " insert into [dbo].[MarkLecturer] ([Login],[subjid],[subjtype],[lectid],[qid],[mark],[ldescription]) " . " values (?,?,?,?,?,?,?) ";
$params = array(&$login, &$subjectid, &$subjtype, &$lectid, &$qid, &$mark, &$ldescription);
$stmt = sqlsrv_prepare($conn, $sqlstr, $params);
if ($stmt) {
foreach ($marks as &$data) {
$login = $data->login;
$subjectid = $data->subjectid;
$subjtype = $data->subjtype;
$lectid = $data->lectid;
$qid = $data->qid;
$mark = $data->mark;
$ldescription = $data->description;
if (!sqlsrv_execute($stmt)) {
array_push($status, "not inserted-L" . $login . "-S" . $subjectid . "-T" . $subjtype . "-L" . $lectid . "-Q" . $qid);
}
}
}
sqlsrv_close($conn);
}
return $status;
}
/**
* @param String $serverName Target server name or host.
* @param Array $conninfo Associative array containing the db connection required parameters.
* Expected keys: UID, PWD, Database
*/
public function __construct($serverName, $connInfo)
{
$this->dbh = sqlsrv_connect($serverName, $connInfo);
if ($this->dbh === false) {
return false;
}
}
public function __construct($serverName, $connectionOptions)
{
$this->conn = sqlsrv_connect($serverName, $connectionOptions);
if (!$this->conn) {
throw SQLSrvException::fromSqlSrvErrors();
}
$this->lastInsertId = new LastInsertId();
}
/**
* Constructs a new instance of NorthWindQueryProvider
*
*/
public function __construct()
{
$this->_connectionHandle = sqlsrv_connect(SERVER, array("Database" => DATABASE));
if ($this->_connectionHandle) {
} else {
die(print_r(sqlsrv_errors(), true));
}
}
function sqlsrvConnect()
{
// Functionalized it for later OOB
$serverName = "qserv\\sql2008";
//serverName\instanceName
$connectionInfo = array("Database" => "WYSAC_Website", "UID" => "wysacweb_app", "PWD" => "1p7kS5kiRp(dj33q");
return sqlsrv_connect($serverName, $connectionInfo);
}
private function connect()
{
$this->connection = sqlsrv_connect($this->hostname, $this->connInfo);
if (!$this->connection) {
//trigger_error("Incorrect Connection Parameter",E_USER_WARNING);
self::$error = true;
}
}
/**
* Criar conexão com servidor SQL
*
* @return void
*/
public function __construct()
{
$info = array('UID' => $this->user, 'PWD' => $this->password, 'Database' => $this->db, 'CharacterSet' => 'UTF-8');
$this->conn = sqlsrv_connect($this->host, $info);
if ($this->conn === false) {
die(print_r(sqlsrv_errors(), true));
}
}
/**
* @covers Zend\Db\Adapter\Driver\Sqlsrv\Connection::setResource
*/
public function testSetResource()
{
$resource = sqlsrv_connect($this->variables['hostname'], array('UID' => $this->variables['username'], 'PWD' => $this->variables['password']));
$connection = new Connection(array());
$this->assertSame($connection, $connection->setResource($resource));
$connection->disconnect();
unset($connection);
unset($resource);
}
/**
* Open a connection to db
*/
public function connect()
{
$connectionInfo = array("Database" => $this->dbname, "PWD" => $this->pwd, "UID" => $this->user);
$this->conn = sqlsrv_connect($this->host, $connectionInfo);
if (!$this->conn) {
triggerErrorMSSQL();
}
return $this->conn;
}
/**
* Constructor
*/
public function __construct()
{
$connectionInfo = array("UID" => DBSettings::$dbUser, "PWD" => DBSettings::$dbPass, "Database" => DBSettings::$database, "ReturnDatesAsStrings" => true);
$this->_connection = sqlsrv_connect(DBSettings::$Server, $connectionInfo);
// Creates and opens a connection.
if ($this->_connection == null) {
trigger_error('Failed to connect to SQL: ' . dbGetErrorMsg());
}
}
private function _connect()
{
$param = array('Database' => $this->databasename, 'UID' => $this->username, 'PWD' => $this->password, "CharacterSet" => $this->code);
$result = sqlsrv_connect($this->servername, $param);
if (is_resource($result)) {
$this->_db = $result;
}
return $result;
}
function db_connect($pooling = false)
{
$character_set = 0 === strcasecmp('utf8', $this->char_set) ? 'UTF-8' : $this->char_set;
$connection = array('UID' => empty($this->username) ? '' : $this->username, 'PWD' => empty($this->password) ? '' : $this->password, 'Database' => $this->database, 'ConnectionPooling' => $pooling ? 1 : 0, 'CharacterSet' => $character_set, 'ReturnDatesAsStrings' => 1);
if (empty($connection['UID']) && empty($connection['PWD'])) {
unset($connection['UID'], $connection['PWD']);
}
return sqlsrv_connect($this->hostname, $connection);
}
public function connect()
{
if ($connection = sqlsrv_connect($this->host, ['UID' => $this->user, 'PWD' => $this->pass, 'Database' => $this->name])) {
$this->connection = $connection;
} else {
trigger_error('Could not connect to Database');
exit;
}
}
/**
* Connect to the database.
*
* @throws <b>AgaviDatabaseException</b> If a connection could not be
* created.
*
* @author David Zülke <*****@*****.**>
* @since 1.0.4
*/
protected function connect()
{
$serverName = $this->getParameter('server_name');
if ($serverName == null) {
// missing required server_name parameter
$error = 'Database configuration is missing "server_name" parameter';
throw new AgaviDatabaseException($error);
}
if ($this->hasParameter('settings')) {
foreach ((array) $this->getParameter('settings') as $key => $value) {
if (!sqlsrv_configure($key, is_string($value) && strpos($value, 'SQLSRV_') === 0 && defined($value) ? constant($value) : (is_numeric($value) ? (int) $value : $value))) {
throw new AgaviDatabaseException(sprintf('Unsupported key or value for setting "%s".', $key));
}
}
}
$connectionInfo = $this->getParameter('connection_info');
foreach ($connectionInfo as &$value) {
$value = is_string($value) && strpos($value, 'SQLSRV_') === 0 && defined($value) ? constant($value) : (is_numeric($value) ? (int) $value : $value);
}
$this->connection = sqlsrv_connect($serverName, $connectionInfo);
if (!$this->connection) {
$this->connection = null;
throw new AgaviDatabaseException(sprintf("%s\n\n%s", sprintf('Could not open database connection "%s".', $this->getName()), implode("\n", $this->getErrors())));
}
$this->resource =& $this->connection;
foreach ((array) $this->getParameter('init_queries') as $query) {
sqlsrv_query($this->connection, $query);
}
}
