andela-tolotin / Potato-ORM

src/Database/DatabaseHandler.php

Spacing +18 added lines, -18 removed lines

@@ -40,11 +40,11 @@ 
 	 */
 	public function create($associative1DArray, $tableName, $dbConn = Null)
 	{
-		$unexpectedFields = self::checkIfMagicSetterContainsIsSameAsClassModel($this->tableFields,$associative1DArray);
+		$unexpectedFields = self::checkIfMagicSetterContainsIsSameAsClassModel($this->tableFields, $associative1DArray);
 
 		if (count($unexpectedFields) > 0)
 		{
-			throw TableFieldUndefinedException::fieldsNotDefinedException($unexpectedFields,"needs to be created as table field");
+			throw TableFieldUndefinedException::fieldsNotDefinedException($unexpectedFields, "needs to be created as table field");
 		}
 
 		unset($this->tableFields[0]);
@@ -57,7 +57,7 @@ 
 
 		$insertQuery = 'INSERT INTO '.$tableName;
 
-		$TableValues = implode(',',array_keys($associative1DArray));
+		$TableValues = implode(',', array_keys($associative1DArray));
 
 		foreach ($associative1DArray as $field => $value) {
 
@@ -65,13 +65,13 @@ 
 		}
 		$splittedTableValues = implode(',', $FormValues);
 
-		$insertQuery.= ' ('.$TableValues.')';
+		$insertQuery .= ' ('.$TableValues.')';
 
-		$insertQuery.= ' VALUES ('.$splittedTableValues.')';
+		$insertQuery .= ' VALUES ('.$splittedTableValues.')';
 
 		$executeQuery = $dbConn->exec($insertQuery);
 
-		return $executeQuery ? : false;
+		return $executeQuery ?: false;
 	}
 
 	/*
@@ -90,19 +90,19 @@ 
 
 		unset($associative1DArray['id']);
 
-		$unexpectedFields = self::checkIfMagicSetterContainsIsSameAsClassModel($this->tableFields,$associative1DArray);
+		$unexpectedFields = self::checkIfMagicSetterContainsIsSameAsClassModel($this->tableFields, $associative1DArray);
 
 		if (count($unexpectedFields) > 0) {
 
-			throw TableFieldUndefinedException::fieldsNotDefinedException($unexpectedFields,"needs to be created as table field");
+			throw TableFieldUndefinedException::fieldsNotDefinedException($unexpectedFields, "needs to be created as table field");
 		}
 
-		foreach($associative1DArray as $field => $value)
+		foreach ($associative1DArray as $field => $value)
 		{
 			$sql = "`$field` = '$value'".",";
 		}
 
-		$updateSql.= $this->prepareUpdateQuery($sql);
+		$updateSql .= $this->prepareUpdateQuery($sql);
 
 		foreach ($updateParams as $key => $val) {
 
@@ -113,7 +113,7 @@ 
 
 		$boolResponse = $stmt->execute();
 
-		return $boolResponse ?  : false;
+		return $boolResponse ?: false;
 	}
 
 	/**
@@ -132,7 +132,7 @@ 
 			$dbConn = $dhl->connect();
 		}
 
-		$sql = $id  ? 'SELECT * FROM '.$tableName.' WHERE id = '.$id : 'SELECT * FROM '.$tableName;
+		$sql = $id ? 'SELECT * FROM '.$tableName.' WHERE id = '.$id : 'SELECT * FROM '.$tableName;
 
 		try {
 			$stmt = $dbConn->prepare($sql);
@@ -146,7 +146,7 @@ 
 		}
 		$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
 
-		foreach($results as $result) {
+		foreach ($results as $result) {
 
 			array_push($tableData, $result);
 		}
@@ -173,7 +173,7 @@ 
 
 		$boolResponse = $dbConn->exec($sql);
 
-		return $boolResponse ? : false;
+		return $boolResponse ?: false;
 	}
 
 	/**
@@ -188,7 +188,7 @@ 
 
 		foreach ($userSetterArray as $key => $val)
 		{
-			if (!in_array($key,$tableColumn)) {
+			if (!in_array($key, $tableColumn)) {
 
 				$unexpectedFields[] = $key;
 			}
@@ -204,16 +204,16 @@ 
 	 */
 	private function prepareUpdateQuery($sql)
 	{
-		$splittedQuery = explode(",",$sql);
+		$splittedQuery = explode(",", $sql);
 
 		array_pop($splittedQuery);
 
-		$mergeData = implode(",",$splittedQuery);
+		$mergeData = implode(",", $splittedQuery);
 
 		return $mergeData;
 	}
 
-	public function findAndWhere(array $params,$tableName)
+	public function findAndWhere(array $params, $tableName)
 	{
 		if (is_array($params) && !empty($params)) {