<?php 
	 class dbconnect {
			//MSSQL	
			protected $db;	
			//MSSQL
			protected $sql_db;
			
			public function open_db(){
				require '../database.php';
				$this->host 	= $db['default']['hostname'];
				$this->username = $db['default']['username'];
				$this->password = $db['default']['password'];
				$this->database = $db['default']['database'];
				$this->db 		= new mysqli($this->host, $this->username, $this->password, $this->database);
				if(mysqli_connect_errno()){
					return false;
				}else{
					return true;
				}
			}
			
			public function runQuery($query){
				$result = mysqli_query($this->db,$query);
				if(!$result){
					echo('Error description: '.mysqli_error($this->db).'<br/>');
					return false;
				}else{
					return $result;
				}		
			}
			
			public function result($result){
				$data = array();
				while ($obj = mysqli_fetch_object($result)) {
					if($obj){				
						$data[] = $obj;
					}
				}
				return $data;
			}
			# RETURNS RESULT AS ASSOCIATIVE ARRAY [MS 23-10-2024]
			public function result_array($result){
				$data = array();
				while ($obj = mysqli_fetch_assoc($result)) {
					if($obj){				
						$data[] = $obj;
					}
				}
				return $data;
			}
			public function runQuery_insert_id($query) {
				$result    = mysqli_query($this->db,$query);
				$insert_id = $this->db->insert_id;
				if(!$result){
					echo('Error description: '.mysqli_error($this->db).'<br/>');
					return false;
				}else{
					return $insert_id;
				}
			}
			
			public function num_rows($result){
				return mysqli_num_rows($result);
			}
			
			public function close_db(){
				mysqli_close($this->db);
			}
			public function sql_runQuery($query) {
				$result = sqlsrv_query($this->sql_db,$query);
				if(!$result){
					//echo('Error description: '.sqlsrv_errors($this->sql_db).'<br/>');
					return false;
				}else{
					return $result;
				}		
			}
			public function sql_result($result){
				$data = array();
				while ($obj = sqlsrv_fetch_object($result)){
					if($obj){				
						$data[] = $obj;
					}
				}
				return $data;
			}
			//SQL Functions
			public function sql_open_db(){
				require '../database.php';
				$this->sql_host 	 = $db['default']['sql_hostname'];
				$this->sql_database = $db['default']['sql_database'];
				$this->sql_db = sqlsrv_connect($this->sql_host, array( 'Database'=>$this->sql_database));
				if($this->sql_db === false ) {
					return false;
				}else{
					return true;
				}
			}
		} 
	 ?>