| @@ -12,9 +12,9 @@ | ||
| 12 | 12 | |
| 13 | 13 |  class EmptyArrayException extends Exception { | 
| 14 | 14 | |
| 15 | - public static function checkEmptyArrayException($message) | |
| 16 | -    { | |
| 17 | - return new static($message); | |
| 18 | - } | |
| 15 | + public static function checkEmptyArrayException($message) | |
| 16 | +	{ | |
| 17 | + return new static($message); | |
| 18 | + } | |
| 19 | 19 | |
| 20 | 20 | } | 
| @@ -12,9 +12,9 @@ | ||
| 12 | 12 | |
| 13 | 13 |  class NoArgumentPassedToFunctionException extends Exception { | 
| 14 | 14 | |
| 15 | - public static function checkNoArgumentPassedToFunction($message) | |
| 16 | -    { | |
| 17 | - return new static($message); | |
| 18 | - } | |
| 15 | + public static function checkNoArgumentPassedToFunction($message) | |
| 16 | +	{ | |
| 17 | + return new static($message); | |
| 18 | + } | |
| 19 | 19 | |
| 20 | 20 | } | 
| @@ -12,8 +12,8 @@ | ||
| 12 | 12 | |
| 13 | 13 |  class NoRecordInsertionException extends Exception { | 
| 14 | 14 | |
| 15 | - public static function checkNoRecordAddedException($mesaage) | |
| 16 | -    { | |
| 17 | - return new static($mesaage); | |
| 18 | - } | |
| 15 | + public static function checkNoRecordAddedException($mesaage) | |
| 16 | +	{ | |
| 17 | + return new static($mesaage); | |
| 18 | + } | |
| 19 | 19 | } | 
| @@ -12,9 +12,9 @@ | ||
| 12 | 12 | |
| 13 | 13 |  class NoRecordUpdateException extends  Exception { | 
| 14 | 14 | |
| 15 | - public static function checkNoRecordUpdateException($message) | |
| 16 | -    { | |
| 17 | - return new static($message); | |
| 18 | - } | |
| 15 | + public static function checkNoRecordUpdateException($message) | |
| 16 | +	{ | |
| 17 | + return new static($message); | |
| 18 | + } | |
| 19 | 19 | |
| 20 | 20 | } | 
| @@ -12,9 +12,9 @@ | ||
| 12 | 12 | |
| 13 | 13 |  class WrongArgumentException extends Exception { | 
| 14 | 14 | |
| 15 | - public function checkWrongArgumentException($message) | |
| 16 | -    { | |
| 17 | - return new static ($message); | |
| 18 | - } | |
| 15 | + public function checkWrongArgumentException($message) | |
| 16 | +	{ | |
| 17 | + return new static ($message); | |
| 18 | + } | |
| 19 | 19 | |
| 20 | 20 | } | 
| @@ -13,25 +13,25 @@ | ||
| 13 | 13 | |
| 14 | 14 |  class DatabaseHelper { | 
| 15 | 15 | |
| 16 | - public $dbConn; | |
| 16 | + public $dbConn; | |
| 17 | 17 | |
| 18 | - /** | |
| 19 | - * This is a constructor; a default method that will be called automatically during class instantiation | |
| 20 | - */ | |
| 21 | - public function __construct($dbConnect) | |
| 22 | -    { | |
| 23 | - $this->dbConn = $dbConnect; | |
| 24 | - } | |
| 18 | + /** | |
| 19 | + * This is a constructor; a default method that will be called automatically during class instantiation | |
| 20 | + */ | |
| 21 | + public function __construct($dbConnect) | |
| 22 | +	{ | |
| 23 | + $this->dbConn = $dbConnect; | |
| 24 | + } | |
| 25 | 25 | |
| 26 | - /** | |
| 27 | - * This method creates a particular table | |
| 28 | - * @param tableName | |
| 29 | - * $return boolean true or false | |
| 30 | - */ | |
| 26 | + /** | |
| 27 | + * This method creates a particular table | |
| 28 | + * @param tableName | |
| 29 | + * $return boolean true or false | |
| 30 | + */ | |
| 31 | 31 | public function createTable($tableName, $conn = NULL) | 
| 32 | 32 |     { | 
| 33 | 33 |     	if (is_null($conn)) { | 
| 34 | - $conn = $this->dbConn; | |
| 34 | + $conn = $this->dbConn; | |
| 35 | 35 | } | 
| 36 | 36 | |
| 37 | 37 |     	$sql = 'CREATE TABLE IF NOT EXISTS '.$tableName.'('; | 
| @@ -10,12 +10,12 @@ | ||
| 10 | 10 | |
| 11 | 11 |  interface InterfaceBaseClass { | 
| 12 | 12 | |
| 13 | - /** | |
| 14 | - * This method gets all the record from a particular table | |
| 15 | - * @params void | |
| 16 | - * @return associative array | |
| 17 | - */ | |
| 18 | - public static function getAll(); | |
| 13 | + /** | |
| 14 | + * This method gets all the record from a particular table | |
| 15 | + * @params void | |
| 16 | + * @return associative array | |
| 17 | + */ | |
| 18 | + public static function getAll(); | |
| 19 | 19 | |
| 20 | 20 | /** | 
| 21 | 21 | * This method create or update record in a database table | 
| @@ -14,73 +14,73 @@ | ||
| 14 | 14 | |
| 15 | 15 |  class DatabaseConnection extends \PDO { | 
| 16 | 16 | |
| 17 | - private $databaseName; | |
| 18 | - private $databaseHost; | |
| 19 | - private $databaseDriver; | |
| 20 | - private $databaseUsername; | |
| 21 | - private $databasePassword; | |
| 17 | + private $databaseName; | |
| 18 | + private $databaseHost; | |
| 19 | + private $databaseDriver; | |
| 20 | + private $databaseUsername; | |
| 21 | + private $databasePassword; | |
| 22 | 22 | |
| 23 | - public function __construct() | |
| 24 | -    { | |
| 25 | - $this->loadEnv(); // load the environment variables | |
| 26 | -    	$this->databaseName     =  getenv('databaseName'); | |
| 27 | -    	$this->databaseHost     =  getenv('databaseHost'); | |
| 28 | -    	$this->databaseDriver   =  getenv('databaseDriver'); | |
| 29 | -    	$this->databaseUsername =  getenv('databaseUsername'); | |
| 30 | -    	$this->databasePassword =  getenv('databasePassword'); | |
| 23 | + public function __construct() | |
| 24 | +	{ | |
| 25 | + $this->loadEnv(); // load the environment variables | |
| 26 | +		$this->databaseName     =  getenv('databaseName'); | |
| 27 | +		$this->databaseHost     =  getenv('databaseHost'); | |
| 28 | +		$this->databaseDriver   =  getenv('databaseDriver'); | |
| 29 | +		$this->databaseUsername =  getenv('databaseUsername'); | |
| 30 | +		$this->databasePassword =  getenv('databasePassword'); | |
| 31 | 31 | |
| 32 | -    	try { | |
| 33 | - $options = [ | |
| 34 | - PDO::ATTR_PERSISTENT => true, | |
| 35 | - PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION | |
| 36 | - ]; | |
| 37 | - parent::__construct($this->getDatabaseDriver(), $this->databaseUsername, $this->databasePassword, $options); | |
| 32 | +		try { | |
| 33 | + $options = [ | |
| 34 | + PDO::ATTR_PERSISTENT => true, | |
| 35 | + PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION | |
| 36 | + ]; | |
| 37 | + parent::__construct($this->getDatabaseDriver(), $this->databaseUsername, $this->databasePassword, $options); | |
| 38 | 38 | |
| 39 | -    	} catch(PDOException $e) { | |
| 40 | - return $e->getMessage(); | |
| 41 | - } | |
| 39 | +		} catch(PDOException $e) { | |
| 40 | + return $e->getMessage(); | |
| 41 | + } | |
| 42 | 42 | |
| 43 | - } | |
| 43 | + } | |
| 44 | 44 | |
| 45 | - /** | |
| 46 | - * This method determines the driver to be used for appropriate database server | |
| 47 | - * @params void | |
| 48 | - * @return string dsn | |
| 49 | - */ | |
| 50 | - public function getDatabaseDriver() | |
| 51 | -     { | |
| 52 | - $dsn = ""; | |
| 45 | + /** | |
| 46 | + * This method determines the driver to be used for appropriate database server | |
| 47 | + * @params void | |
| 48 | + * @return string dsn | |
| 49 | + */ | |
| 50 | + public function getDatabaseDriver() | |
| 51 | +	 { | |
| 52 | + $dsn = ""; | |
| 53 | 53 | |
| 54 | - switch ($this->databaseDriver) | |
| 55 | -     	{ | |
| 56 | - case 'mysql': | |
| 57 | - // Set DSN | |
| 58 | - $dsn = 'mysql:host='.$this->databaseHost.';dbname='. $this->databaseName; | |
| 59 | - break; | |
| 60 | - case 'sqlite': | |
| 61 | - // Set DSN | |
| 62 | - $dsn = 'sqlite:host='.$this->databaseHost.';dbname='. $this->databaseName; | |
| 63 | - break; | |
| 64 | - case 'pgsql': | |
| 65 | - // Set DSN | |
| 66 | - $dsn = 'pgsqlsql:host='.$this->databaseHost.';dbname='. $this->databaseName; | |
| 67 | - break; | |
| 68 | - default: | |
| 69 | - // Set DSN | |
| 70 | - $dsn = 'mysql:host='.$this->databaseHost.';dbname='. $this->databaseName; | |
| 71 | - } | |
| 72 | - return $dsn; | |
| 73 | - } | |
| 54 | + switch ($this->databaseDriver) | |
| 55 | +	 	{ | |
| 56 | + case 'mysql': | |
| 57 | + // Set DSN | |
| 58 | + $dsn = 'mysql:host='.$this->databaseHost.';dbname='. $this->databaseName; | |
| 59 | + break; | |
| 60 | + case 'sqlite': | |
| 61 | + // Set DSN | |
| 62 | + $dsn = 'sqlite:host='.$this->databaseHost.';dbname='. $this->databaseName; | |
| 63 | + break; | |
| 64 | + case 'pgsql': | |
| 65 | + // Set DSN | |
| 66 | + $dsn = 'pgsqlsql:host='.$this->databaseHost.';dbname='. $this->databaseName; | |
| 67 | + break; | |
| 68 | + default: | |
| 69 | + // Set DSN | |
| 70 | + $dsn = 'mysql:host='.$this->databaseHost.';dbname='. $this->databaseName; | |
| 71 | + } | |
| 72 | + return $dsn; | |
| 73 | + } | |
| 74 | 74 | |
| 75 | - /** | |
| 76 | - * Load Dotenv to grant getenv() access to environment variables in .env file | |
| 77 | - */ | |
| 78 | - public function loadEnv() | |
| 79 | -     { | |
| 80 | -     	if (!getenv("APP_ENV")) { | |
| 81 | - $dotenv = new Dotenv(__DIR__.'/../../'); | |
| 82 | - $dotenv->load(); | |
| 83 | - } | |
| 84 | - } | |
| 75 | + /** | |
| 76 | + * Load Dotenv to grant getenv() access to environment variables in .env file | |
| 77 | + */ | |
| 78 | + public function loadEnv() | |
| 79 | +	 { | |
| 80 | +	 	if (!getenv("APP_ENV")) { | |
| 81 | + $dotenv = new Dotenv(__DIR__.'/../../'); | |
| 82 | + $dotenv->load(); | |
| 83 | + } | |
| 84 | + } | |
| 85 | 85 | |
| 86 | 86 | } | 
| @@ -12,8 +12,8 @@ | ||
| 12 | 12 | |
| 13 | 13 | class NoRecordDeletionException extends Exception | 
| 14 | 14 |  { | 
| 15 | - public static function checkNoRecordDeleteException($message) | |
| 16 | -    { | |
| 17 | - return new static($message); | |
| 18 | - } | |
| 15 | + public static function checkNoRecordDeleteException($message) | |
| 16 | +	{ | |
| 17 | + return new static($message); | |
| 18 | + } | |
| 19 | 19 | } |