<?php
//Constructor -> Schrijft fields die worden gebruikt in de connectiestring

//openConnection -> Kan worden gebruikt als $clsDbConnection->openConnection(); om de verbinding handmatig open te zetten

//closeConnection -> Sluit de verbinding

//executeQuery -> Geeft een array terug van de ingevoerde query. Lees uit bijv met echo $query_result[0];
//Voorbeeld:
//	$query = "SELECT CompanyName FROM Customers WHERE CustomerID = 'ALFKI'";
//	$query_result = $clsDbConnection->executeQuery($query);

//executeStoredprocedure -> Geeft een array terug van geselecteerde stored procedure en meegegeven parameters.
//Bij 2e variabele die mee moet worden gegeven: $requested_sp,$parm_sp1, $parm_query1,$type1,$parm_query2,type2...
//Voorbeeld:
//	$requested_sp = "sp_test";
//	$parm_query1 = "ALFKI";
//	$parm_sp1 = "@username";
//	$type1= SQLCHAR;
//	$query_result = $clsDbConnection->executeStoredprocedure($requested_sp,$parm_sp1, $parm_query1,$type1);

	class clsDbConnection
	{
		private $sqlServer;
		private $sqlUser;
		private $sqlPassword;
		private $sqlDatabase;

		private $selected_database;
		private $mssql_connection;

		function clsDbConnection($sqlServer,$sqlUser,$sqlPassword,$sqlDatabase)
		{
			$this->sqlServer = $sqlServer;
			$this->sqlUser = $sqlUser;
			$this->sqlPassword = $sqlPassword;
			$this->sqlDatabase = $sqlDatabase;
		}

		public function openConnection()
		{
			$this->mssql_connection = mssql_connect($this->sqlServer, $this->sqlUser, $this->sqlPassword)
			or die("Couldn't connect to SQL Server on $sqlServer");

			$this->selected_database = mssql_select_db($this->sqlDatabase, $this->mssql_connection)
			or die("Couldn't open database $this->sqlDatabase");
		}

		public function closeConnection()
		{
			mssql_close();
		}

		public function executeQuery($query_input)
		{
			$this->openConnection();

			$query_string = $query_input;
			$query_executed = mssql_query($query_string);
			$query_result = mssql_fetch_array($query_executed);

			$this->closeConnection();

			return $query_result;
		}

		public function executeStoredprocedure($requested_sp,$parm_sp1,$parm_query1,$type1)
		{
			$this->openConnection();

			$stmt = mssql_init($requested_sp);
			mssql_bind($stmt, $parm_sp1, $parm_query1, $type1, false, false, 10);
			$result = mssql_execute($stmt);
			$row = mssql_fetch_array($result);

			mssql_free_statement($stmt);
			$this->closeConnection();

			return $row;
		}

		public function executeStoredprocedure($requested_sp,$parm_sp1,$parm_query1,$type1,$parm_sp2,$parm_query2,$type2)
		{
			$this->openConnection();

			$stmt = mssql_init($requested_sp);
			mssql_bind($stmt, $parm_sp1, $parm_query1, $type1, false, false, 10);
			mssql_bind($stmt, $parm_sp1, $parm_query1, $type1, false, false, 10);
			$result = mssql_execute($stmt);
			$row = mssql_fetch_array($result);

			mssql_free_statement($stmt);
			$this->closeConnection();

			return $row;
		}
	}
?>