@@ -66,14 +66,12 @@ discard block |
||
66 | 66 | $statement === self::QUERY_TYPE_EXPLAIN |
67 | 67 | ) { |
68 | 68 | return $this->sQuery->fetchAll( $fetchMode ); |
69 | - } |
|
70 | - elseif ( $statement === self::QUERY_TYPE_INSERT || |
|
69 | + } elseif ( $statement === self::QUERY_TYPE_INSERT || |
|
71 | 70 | $statement === self::QUERY_TYPE_UPDATE || |
72 | 71 | $statement === self::QUERY_TYPE_DELETE |
73 | 72 | ) { |
74 | 73 | return $this->sQuery->rowCount(); |
75 | - } |
|
76 | - else { |
|
74 | + } else { |
|
77 | 75 | |
78 | 76 | return NULL; |
79 | 77 | } |
@@ -91,8 +89,9 @@ discard block |
||
91 | 89 | $query = trim( str_replace( "\r", " ", $query ) ); |
92 | 90 | $statement = self::getQueryStatement( $query ); |
93 | 91 | |
94 | - if ( $statement === self::QUERY_TYPE_EXPLAIN ) |
|
95 | - return $this->sQuery->fetchAll( \PDO::FETCH_ASSOC ); |
|
92 | + if ( $statement === self::QUERY_TYPE_EXPLAIN ) { |
|
93 | + return $this->sQuery->fetchAll( \PDO::FETCH_ASSOC ); |
|
94 | + } |
|
96 | 95 | |
97 | 96 | $Columns = $this->sQuery->fetchAll( \PDO::FETCH_NUM ); |
98 | 97 | |
@@ -112,8 +111,9 @@ discard block |
||
112 | 111 | $query = trim( str_replace( "\r", " ", $query ) ); |
113 | 112 | $statement = self::getQueryStatement( $query ); |
114 | 113 | |
115 | - if ( $statement === self::QUERY_TYPE_EXPLAIN ) |
|
116 | - return $this->sQuery->fetchAll( \PDO::FETCH_ASSOC ); |
|
114 | + if ( $statement === self::QUERY_TYPE_EXPLAIN ) { |
|
115 | + return $this->sQuery->fetchAll( \PDO::FETCH_ASSOC ); |
|
116 | + } |
|
117 | 117 | |
118 | 118 | $result = $this->sQuery->fetch( $fetchmode ); |
119 | 119 | $this->sQuery->closeCursor(); // Frees up the connection to the server so that other SQL statements may be issued, |
@@ -150,24 +150,22 @@ discard block |
||
150 | 150 | /** |
151 | 151 | * Add parameters to the parameter array |
152 | 152 | */ |
153 | - if ( self::isArrayAssoc( $parameters ) ) |
|
154 | - $this->bindMore( $parameters ); |
|
155 | - else |
|
156 | - foreach ( $parameters as $key => $val ) |
|
153 | + if ( self::isArrayAssoc( $parameters ) ) { |
|
154 | + $this->bindMore( $parameters ); |
|
155 | + } else { |
|
156 | + foreach ( $parameters as $key => $val ) |
|
157 | 157 | $this->parameters[] = array( $key + 1, $val ); |
158 | + } |
|
158 | 159 | |
159 | 160 | if ( count( $this->parameters ) ) { |
160 | 161 | foreach ( $this->parameters as $param => $value ) { |
161 | 162 | if ( is_int( $value[1] ) ) { |
162 | 163 | $type = \PDO::PARAM_INT; |
163 | - } |
|
164 | - elseif ( is_bool( $value[1] ) ) { |
|
164 | + } elseif ( is_bool( $value[1] ) ) { |
|
165 | 165 | $type = \PDO::PARAM_BOOL; |
166 | - } |
|
167 | - elseif ( is_null( $value[1] ) ) { |
|
166 | + } elseif ( is_null( $value[1] ) ) { |
|
168 | 167 | $type = \PDO::PARAM_NULL; |
169 | - } |
|
170 | - else { |
|
168 | + } else { |
|
171 | 169 | $type = \PDO::PARAM_STR; |
172 | 170 | } |
173 | 171 | $this->sQuery->bindValue( $value[0], $value[1], $type ); |
@@ -246,8 +244,7 @@ discard block |
||
246 | 244 | default: |
247 | 245 | return self::QUERY_TYPE_OTHER; |
248 | 246 | } |
249 | - } |
|
250 | - else { |
|
247 | + } else { |
|
251 | 248 | return self::QUERY_TYPE_OTHER; |
252 | 249 | } |
253 | 250 | } |
@@ -258,7 +255,9 @@ discard block |
||
258 | 255 | */ |
259 | 256 | public static function isArrayAssoc( array $arr ) |
260 | 257 | { |
261 | - if ( array() === $arr ) return false; |
|
258 | + if ( array() === $arr ) { |
|
259 | + return false; |
|
260 | + } |
|
262 | 261 | |
263 | 262 | return array_keys( $arr ) !== range( 0, count( $arr ) - 1 ); |
264 | 263 | } |