<?php
 
require_once("connectioni.php");

class DBConnector
{

// private $server = '';
// private $userName = '';
// private $password = '';
// private $database = '';


private $server = 'localhost';
private $userName = 'coolmans_npeidcs';
private $password = 'e1E]0Mfua.0T4LL';
private $database = 'coolmans_npeidcs';
private $con = null;

	// Object construction with database connectivity - Default Constructor
	function __construct()
	{	
// 		$this->server = DB_SERVER ;
// 		$this->userName = DB_USER_NAME;
// 		$this->password = DB_PASSWORD;
// 		$this->database = DB_DATABSE;
		
		$this->server = 'localhost' ;
		$this->userName = 'coolmans_npeidcs';
		$this->password = 'e1E]0Mfua.0T4LL';
		$this->database = 'coolmans_npeidcs';
	}

	/*
	 * DBConnector::OpenConnection()
	 * 
	 * Open mysql database connection
	 * 
	 * @access public
	 * 
	 * @return void
	 */
	public function OpenConnection()
	{
		$this->con = mysqli_connect($this->server, $this->userName, $this->password,$this->database);

		if (!$this->con)
		{
		  die($password . 'Could not connect: ' . mysqli_error());
		}
	}
	
	/*
	 * DBConnector::RunQuery()
	 * 
	 * Use to execute select statements
	 *
	 * @param String $SQL : The SQL statement to be executed
	 * 
	 * @access public
	 * 
	 * @return Array
	 */
	public function RunQuery($SQL)
	{
		$this->OpenConnection();
		//mysql_select_db($this->database,  $this->con);
		$result = mysqli_query($GLOBALS['dbinv'],$SQL);
		$this->CloseConnection();		
		return $result;
	}
	
	/*
	 * DBConnector::ExecuteQuery()
	 * 
	 * Use to execute insert, update and delete statements
	 *
	 * @param String $SQL : The SQL statement to be executed
	 * 
	 * @access public
	 * 
	 * @return boolean
	 */
	public function ExecuteQuery($SQL)
	{
		$this->OpenConnection();
		//mysql_select_db($this->database,  $this->con);
		$result = mysqli_query($GLOBALS['dbinv'],$SQL);
		if (mysqli_error())	
			$result = false;
		$this->CloseConnection();
		return $result;
	}	
	
	/*
	 * DBConnector::CheckRecordAvailability()
	 * 
	 * Checks whtether records available or not for the given SQL statement
	 *
	 * @param String $SQL : The SQL statement to be executed
	 * 
	 * @access public
	 * 
	 * @return boolean
	 */
	public function CheckRecordAvailability($SQL)
	{
		$this->OpenConnection();
		mysql_select_db($this->database,  $this->con);
		$result = mysqli_query($GLOBALS['dbinv'],$SQL);
		$this->CloseConnection();
		if(mysqli_num_rows($result) > 0)
			return true;
  		return false;		
	}
	
	/*
	 * DBConnector::AutoIncrementExecuteQuery()
	 * 
	 * Get generated auto increment key/ID, after the execution of given SQL statement
	 *
	 * @param String $SQL : The SQL statement to be executed
	 * 
	 * @access public
	 * 
	 * @return Integer
	 */
	public function AutoIncrementExecuteQuery($SQL)
	{
		$id = -1;
		$this->OpenConnection();
		mysql_select_db($this->database,  $this->con);
		$result = mysqli_query($GLOBALS['dbinv'],$SQL);
		echo mysqli_error();	
		$id =  mysql_insert_id();
		$this->CloseConnection();
		return $id;
	}
	
	/*
	 * DBConnector::CloseConnection()
	 * 
	 * Close MySQL Connection
	 * 
	 * @access public
	 * 
	 * @return void
	 */
	public function CloseConnection()
	{
		mysqli_close($this->con);		
	}
}

?>