adumitru68 / QueryBuilder

sample/select.php

Spacing +1 added lines, -1 removed lines

@@ -22,7 +22,7 @@
 	->whereIn( 'officeCode', [ 2, 3, 4 ] )
 	->count();
 
-$desc = QueryBuild::query('show tables');
+$desc = QueryBuild::query( 'show tables' );
 
 echo "<pre>" . print_r( $count->execute(), 1 ) . "</pre>";
 echo "<pre>" . print_r( $desc->execute(), 1 ) . "</pre>";

src/DB/DbService.php

Spacing +5 added lines, -5 removed lines

@@ -46,7 +46,7 @@ 
 	/**
 	 * @var array
 	 */
-	private $parameters = [];
+	private $parameters = [ ];
 
 	/**
 	 * @var string;
@@ -125,7 +125,7 @@ 
 		$column = null;
 
 		foreach ( $Columns as $cells ) {
-			$column[] = $cells[ 0 ];
+			$column[ ] = $cells[ 0 ];
 		}
 
 		return $column;
@@ -209,7 +209,7 @@ 
 	 * @param array $parameters
 	 * @throws DbException
 	 */
-	private function queryInit( $query, $parameters = [] )
+	private function queryInit( $query, $parameters = [ ] )
 	{
 		$this->lastStatement = self::getQueryStatement( $query );
 		$this->createPdoConnection();
@@ -220,7 +220,7 @@ 
 			 * Prepare query
 			 */
 			$this->sQuery = $this->pdo->prepare( $query );
-			$this->prepareParams($parameters);
+			$this->prepareParams( $parameters );
 			$this->pdoBindValues();
 			$this->sQuery->execute();
 			if ( DbConfig::getInstance()->isEnableLogQueryDuration() ) {
@@ -246,7 +246,7 @@ 
 			$this->bindMore( $parameters );
 		else
 			foreach ( $parameters as $key => $val )
-				$this->parameters[] = array( $key + 1, $val );
+				$this->parameters[ ] = array( $key + 1, $val );
 	}
 
 	private function pdoBindValues()

Braces +25 added lines, -22 removed lines

@@ -117,8 +117,9 @@ 
 	{
 		$this->queryInit( $query, $params );
 
-		if ( $this->lastStatement === self::QUERY_TYPE_EXPLAIN )
-			return $this->sQuery->fetchAll( \PDO::FETCH_ASSOC );
+		if ( $this->lastStatement === self::QUERY_TYPE_EXPLAIN ) {
+					return $this->sQuery->fetchAll( \PDO::FETCH_ASSOC );
+		}
 
 		$Columns = $this->sQuery->fetchAll( \PDO::FETCH_NUM );
 
@@ -141,8 +142,9 @@ 
 	{
 		$this->queryInit( $query, $params );
 
-		if ( $this->lastStatement === self::QUERY_TYPE_EXPLAIN )
-			return $this->sQuery->fetchAll( \PDO::FETCH_ASSOC );
+		if ( $this->lastStatement === self::QUERY_TYPE_EXPLAIN ) {
+					return $this->sQuery->fetchAll( \PDO::FETCH_ASSOC );
+		}
 
 		$result = $this->sQuery->fetch( $fetchmode );
 		$this->sQuery->closeCursor(); // Frees up the connection to the server so that other SQL statements may be issued,
@@ -159,8 +161,9 @@ 
 	{
 		$this->queryInit( $query, $params );
 
-		if ( $this->lastStatement === self::QUERY_TYPE_EXPLAIN )
-			return $this->sQuery->fetchAll( \PDO::FETCH_ASSOC );
+		if ( $this->lastStatement === self::QUERY_TYPE_EXPLAIN ) {
+					return $this->sQuery->fetchAll( \PDO::FETCH_ASSOC );
+		}
 
 		$result = $this->sQuery->fetchColumn();
 		$this->sQuery->closeCursor(); // Frees up the connection to the server so that other SQL statements may be issued
@@ -242,11 +245,12 @@ 
 
 	private function prepareParams( array $parameters )
 	{
-		if ( self::isArrayAssoc( $parameters ) )
-			$this->bindMore( $parameters );
-		else
-			foreach ( $parameters as $key => $val )
+		if ( self::isArrayAssoc( $parameters ) ) {
+					$this->bindMore( $parameters );
+		} else {
+					foreach ( $parameters as $key => $val )
 				$this->parameters[] = array( $key + 1, $val );
+		}
 	}
 
 	private function pdoBindValues()
@@ -254,14 +258,11 @@ 
 		foreach ( $this->parameters as $param => $value ) {
 			if ( is_int( $value[ 1 ] ) ) {
 				$type = \PDO::PARAM_INT;
-			}
-			elseif ( is_bool( $value[ 1 ] ) ) {
+			} elseif ( is_bool( $value[ 1 ] ) ) {
 				$type = \PDO::PARAM_BOOL;
-			}
-			elseif ( is_null( $value[ 1 ] ) ) {
+			} elseif ( is_null( $value[ 1 ] ) ) {
 				$type = \PDO::PARAM_NULL;
-			}
-			else {
+			} else {
 				$type = \PDO::PARAM_STR;
 			}
 			$this->sQuery->bindValue( $value[ 0 ], $value[ 1 ], $type );
@@ -305,10 +306,11 @@ 
 	{
 		$queryString = trim( $queryString );
 
-		if ( preg_match( '/^(select|insert|update|delete|replace|show|desc|explain)[\s]+/i', $queryString, $matches ) )
-			return strtoupper( $matches[ 1 ] );
-		else
-			return self::QUERY_TYPE_OTHER;
+		if ( preg_match( '/^(select|insert|update|delete|replace|show|desc|explain)[\s]+/i', $queryString, $matches ) ) {
+					return strtoupper( $matches[ 1 ] );
+		} else {
+					return self::QUERY_TYPE_OTHER;
+		}
 	}
 
 	/**
@@ -317,8 +319,9 @@ 
 	 */
 	public static function isArrayAssoc( array $arr )
 	{
-		if ( array() === $arr )
-			return false;
+		if ( array() === $arr ) {
+					return false;
+		}
 
 		return array_keys( $arr ) !== range( 0, count( $arr ) - 1 );
 	}