@@ -60,7 +60,7 @@ discard block |
||
60 | 60 | /** |
61 | 61 | * @var array |
62 | 62 | */ |
63 | - private static $usedInstanceIds = []; |
|
63 | + private static $usedInstanceIds = [ ]; |
|
64 | 64 | |
65 | 65 | /** |
66 | 66 | * @var array |
@@ -132,7 +132,7 @@ discard block |
||
132 | 132 | while ( in_array( $instance, self::$usedInstanceIds ) ) { |
133 | 133 | $instance = QueryHelper::random( 7 ); |
134 | 134 | } |
135 | - self::$usedInstanceIds[] = $instance; |
|
135 | + self::$usedInstanceIds[ ] = $instance; |
|
136 | 136 | |
137 | 137 | return $instance; |
138 | 138 | } |
@@ -179,7 +179,7 @@ discard block |
||
179 | 179 | return true; |
180 | 180 | |
181 | 181 | if ( $this->typeEL[ $name ] === self::ELEMENT_TYPE_ARRAY ) |
182 | - $this->syntaxEL[ $name ][] = $value; |
|
182 | + $this->syntaxEL[ $name ][ ] = $value; |
|
183 | 183 | else |
184 | 184 | $this->syntaxEL[ $name ] = $value; |
185 | 185 | |
@@ -241,7 +241,7 @@ discard block |
||
241 | 241 | * @param string $search |
242 | 242 | * @return string |
243 | 243 | */ |
244 | - public function bindParamsExpression( $expression, array $params = [], $search = '?' ) |
|
244 | + public function bindParamsExpression( $expression, array $params = [ ], $search = '?' ) |
|
245 | 245 | { |
246 | 246 | if ( !count( $params ) ) |
247 | 247 | return $expression; |
@@ -252,12 +252,12 @@ discard block |
||
252 | 252 | $params = array_slice( $params, 0, substr_count( $expression, $search ) ); |
253 | 253 | |
254 | 254 | $i = 0; |
255 | - $arrayReturn = []; |
|
255 | + $arrayReturn = [ ]; |
|
256 | 256 | $expressionToArray = explode( $search, $expression ); |
257 | 257 | |
258 | 258 | foreach ( $expressionToArray as $sub ) { |
259 | - $arrayReturn[] = $sub; |
|
260 | - $arrayReturn[] = array_key_exists( $i, $params ) ? $this->bindParam( 'exp', $params[ $i ] ) : ''; |
|
259 | + $arrayReturn[ ] = $sub; |
|
260 | + $arrayReturn[ ] = array_key_exists( $i, $params ) ? $this->bindParam( 'exp', $params[ $i ] ) : ''; |
|
261 | 261 | $i++; |
262 | 262 | } |
263 | 263 |
@@ -88,7 +88,7 @@ |
||
88 | 88 | foreach ( $brutArray as $value ) { |
89 | 89 | $value = trim( $value ); |
90 | 90 | if ( '' !== $value ) |
91 | - $newArray[] = $value; |
|
91 | + $newArray[ ] = $value; |
|
92 | 92 | } |
93 | 93 | |
94 | 94 | return $newArray; |
@@ -278,7 +278,7 @@ discard block |
||
278 | 278 | * @param string $glue |
279 | 279 | * @return $this |
280 | 280 | */ |
281 | - public function whereExpression( $whereString, array $bindParams = [], $glue = 'AND' ) |
|
281 | + public function whereExpression( $whereString, array $bindParams = [ ], $glue = 'AND' ) |
|
282 | 282 | { |
283 | 283 | $whereString = $this->queryStructure->bindParamsExpression( $whereString, $bindParams ); |
284 | 284 | |
@@ -290,7 +290,7 @@ discard block |
||
290 | 290 | * @param array $bindParams |
291 | 291 | * @return $this |
292 | 292 | */ |
293 | - public function orWhereExpression( $whereString, array $bindParams = [] ) |
|
293 | + public function orWhereExpression( $whereString, array $bindParams = [ ] ) |
|
294 | 294 | { |
295 | 295 | $whereString = $this->queryStructure->bindParamsExpression( $whereString, $bindParams ); |
296 | 296 |
@@ -278,7 +278,7 @@ discard block |
||
278 | 278 | * @param string $glue |
279 | 279 | * @return $this |
280 | 280 | */ |
281 | - public function havingExpression( $whereString, array $bindParams = [], $glue = 'AND' ) |
|
281 | + public function havingExpression( $whereString, array $bindParams = [ ], $glue = 'AND' ) |
|
282 | 282 | { |
283 | 283 | $whereString = $this->queryStructure->bindParamsExpression( $whereString, $bindParams ); |
284 | 284 | |
@@ -290,7 +290,7 @@ discard block |
||
290 | 290 | * @param array $bindParams |
291 | 291 | * @return $this |
292 | 292 | */ |
293 | - public function orHavingExpression( $whereString, array $bindParams = [] ) |
|
293 | + public function orHavingExpression( $whereString, array $bindParams = [ ] ) |
|
294 | 294 | { |
295 | 295 | $whereString = $this->queryStructure->bindParamsExpression( $whereString, $bindParams ); |
296 | 296 |
@@ -46,7 +46,7 @@ discard block |
||
46 | 46 | /** |
47 | 47 | * @var array |
48 | 48 | */ |
49 | - private $parameters = []; |
|
49 | + private $parameters = [ ]; |
|
50 | 50 | |
51 | 51 | /** |
52 | 52 | * @var string; |
@@ -125,7 +125,7 @@ discard block |
||
125 | 125 | $column = null; |
126 | 126 | |
127 | 127 | foreach ( $Columns as $cells ) { |
128 | - $column[] = $cells[ 0 ]; |
|
128 | + $column[ ] = $cells[ 0 ]; |
|
129 | 129 | } |
130 | 130 | |
131 | 131 | return $column; |
@@ -209,7 +209,7 @@ discard block |
||
209 | 209 | * @param array $parameters |
210 | 210 | * @throws DbException |
211 | 211 | */ |
212 | - private function queryInit( $query, $parameters = [] ) |
|
212 | + private function queryInit( $query, $parameters = [ ] ) |
|
213 | 213 | { |
214 | 214 | $this->lastStatement = self::getQueryStatement( $query ); |
215 | 215 | $this->createPdoConnection(); |
@@ -220,7 +220,7 @@ discard block |
||
220 | 220 | * Prepare query |
221 | 221 | */ |
222 | 222 | $this->sQuery = $this->pdo->prepare( $query ); |
223 | - $this->prepareParams($parameters); |
|
223 | + $this->prepareParams( $parameters ); |
|
224 | 224 | $this->pdoBindValues(); |
225 | 225 | $this->sQuery->execute(); |
226 | 226 | if ( DbConfig::getInstance()->isEnableLogQueryDuration() ) { |
@@ -246,7 +246,7 @@ discard block |
||
246 | 246 | $this->bindMore( $parameters ); |
247 | 247 | else |
248 | 248 | foreach ( $parameters as $key => $val ) |
249 | - $this->parameters[] = array( $key + 1, $val ); |
|
249 | + $this->parameters[ ] = array( $key + 1, $val ); |
|
250 | 250 | } |
251 | 251 | |
252 | 252 | private function pdoBindValues() |
@@ -288,7 +288,7 @@ discard block |
||
288 | 288 | */ |
289 | 289 | public function bind( $para, $value ) |
290 | 290 | { |
291 | - $this->parameters[] = [ ":" . $para, $value ]; |
|
291 | + $this->parameters[ ] = [ ":" . $para, $value ]; |
|
292 | 292 | } |
293 | 293 | |
294 | 294 | public function CloseConnection() |
@@ -9,7 +9,7 @@ discard block |
||
9 | 9 | use Qpdb\QueryBuilder\DB\DbService; |
10 | 10 | use Qpdb\QueryBuilder\QueryBuild; |
11 | 11 | |
12 | -include_once $_SERVER['DOCUMENT_ROOT'] . '/vendor/autoload.php'; |
|
12 | +include_once $_SERVER[ 'DOCUMENT_ROOT' ] . '/vendor/autoload.php'; |
|
13 | 13 | |
14 | 14 | |
15 | 15 | $query = QueryBuild::select( 'employees' ) |
@@ -23,8 +23,8 @@ discard block |
||
23 | 23 | $oldInst = DbService::getInstance(); |
24 | 24 | |
25 | 25 | |
26 | -var_dump($oldInst->isMasterOnly()); |
|
27 | -var_dump($newInst->isMasterOnly()); |
|
26 | +var_dump( $oldInst->isMasterOnly() ); |
|
27 | +var_dump( $newInst->isMasterOnly() ); |
|
28 | 28 | |
29 | 29 | |
30 | 30 | echo "<pre>" . print_r( $query->getSyntax(), 1 ) . "</pre>"; |
@@ -97,7 +97,7 @@ |
||
97 | 97 | * @param array $dbConfig |
98 | 98 | * @return $this |
99 | 99 | */ |
100 | - public function withConfigArray ( array $dbConfig ) |
|
100 | + public function withConfigArray( array $dbConfig ) |
|
101 | 101 | { |
102 | 102 | $this->dbConfig = $dbConfig; |
103 | 103 | $this->buildConfig(); |
@@ -24,7 +24,7 @@ |
||
24 | 24 | */ |
25 | 25 | public function setField( $fieldName, $fieldValue ) |
26 | 26 | { |
27 | - $fieldName = $this->queryStructure->prepare($fieldName); |
|
27 | + $fieldName = $this->queryStructure->prepare( $fieldName ); |
|
28 | 28 | $valuePdoString = $this->queryStructure->bindParam( $fieldName, $fieldValue ); |
29 | 29 | $this->queryStructure->setElement( QueryStructure::SET_FIELDS, "$fieldName = $valuePdoString" ); |
30 | 30 |
@@ -63,14 +63,14 @@ |
||
63 | 63 | */ |
64 | 64 | private function prepareArrayFields( $fieldsArray = array() ) |
65 | 65 | { |
66 | - $prepareArray = []; |
|
66 | + $prepareArray = [ ]; |
|
67 | 67 | |
68 | 68 | foreach ( $fieldsArray as $field ) { |
69 | 69 | if ( gettype( $field ) !== QueryStructure::ELEMENT_TYPE_STRING ) |
70 | 70 | throw new QueryException( 'Invalid select field type!', QueryException::QUERY_ERROR_SELECT_INVALID_FIELD ); |
71 | 71 | |
72 | 72 | if ( '' !== trim( $field ) ) |
73 | - $prepareArray[] = $this->queryStructure->prepare( $field ); |
|
73 | + $prepareArray[ ] = $this->queryStructure->prepare( $field ); |
|
74 | 74 | } |
75 | 75 | |
76 | 76 | return $prepareArray; |