@@ -80,9 +80,9 @@ discard block |
||
80 | 80 | |
81 | 81 | $this->childClass = new ChildSimplePHP(get_called_class()); |
82 | 82 | |
83 | - if($tableName) $this->table = $tableName; |
|
83 | + if ($tableName) $this->table = $tableName; |
|
84 | 84 | |
85 | - if($primaryKey) $this->primary = $primaryKey; |
|
85 | + if ($primaryKey) $this->primary = $primaryKey; |
|
86 | 86 | } |
87 | 87 | |
88 | 88 | private function setRealTable() : ?SimplePHP |
@@ -116,9 +116,9 @@ discard block |
||
116 | 116 | public function where(Array $where, String $condition = 'AND'): ?SimplePHP |
117 | 117 | { |
118 | 118 | $this->where = ''; |
119 | - foreach($where as $enclosures) { |
|
120 | - $split = isset($enclosures[3]) && !$enclosures[3] ? $enclosures[2] : "'".$enclosures[2]."'"; |
|
121 | - $this->where .= $enclosures[0]." ".$enclosures[1]." ".$split." {$condition} "; |
|
119 | + foreach ($where as $enclosures) { |
|
120 | + $split = isset($enclosures[3]) && !$enclosures[3] ? $enclosures[2] : "'" . $enclosures[2] . "'"; |
|
121 | + $this->where .= $enclosures[0] . " " . $enclosures[1] . " " . $split . " {$condition} "; |
|
122 | 122 | } |
123 | 123 | $this->where = "WHERE " . rtrim($this->where, " {$condition} "); |
124 | 124 | |
@@ -143,9 +143,9 @@ discard block |
||
143 | 143 | public function orWhere(Array $orWhere, String $condition = 'AND'): ?SimplePHP |
144 | 144 | { |
145 | 145 | $moreWhere = ''; |
146 | - foreach($orWhere as $enclosures) { |
|
147 | - $split = isset($enclosures[3]) && !$enclosures[3] ? $enclosures[2] : "'".$enclosures[2]."'"; |
|
148 | - $moreWhere .= $enclosures[0]." ".$enclosures[1]." ".$split." {$condition} "; |
|
146 | + foreach ($orWhere as $enclosures) { |
|
147 | + $split = isset($enclosures[3]) && !$enclosures[3] ? $enclosures[2] : "'" . $enclosures[2] . "'"; |
|
148 | + $moreWhere .= $enclosures[0] . " " . $enclosures[1] . " " . $split . " {$condition} "; |
|
149 | 149 | } |
150 | 150 | $this->where .= " OR " . rtrim($moreWhere, " {$condition} "); |
151 | 151 | |
@@ -189,7 +189,7 @@ discard block |
||
189 | 189 | */ |
190 | 190 | public function orderBy(String $prop, String $ordenation = 'ASC'): ?SimplePHP |
191 | 191 | { |
192 | - if(mb_strlen($this->order) < 9) { |
|
192 | + if (mb_strlen($this->order) < 9) { |
|
193 | 193 | $this->order = "ORDER BY {$prop} {$ordenation}"; |
194 | 194 | } else { |
195 | 195 | $this->order .= ", {$prop} {$ordenation}"; |
@@ -203,7 +203,7 @@ discard block |
||
203 | 203 | */ |
204 | 204 | public function groupBy(String $prop): ?SimplePHP |
205 | 205 | { |
206 | - if(mb_strlen($this->group) < 9) { |
|
206 | + if (mb_strlen($this->group) < 9) { |
|
207 | 207 | $this->group = "GROUP BY {$prop}"; |
208 | 208 | } else { |
209 | 209 | $this->group .= ", {$prop}"; |
@@ -218,16 +218,16 @@ discard block |
||
218 | 218 | */ |
219 | 219 | public function __call(String $name, $arguments) |
220 | 220 | { |
221 | - if($name === 'skip') |
|
221 | + if ($name === 'skip') |
|
222 | 222 | return $this->offset($arguments[0]); |
223 | 223 | |
224 | - if($name === 'take') |
|
224 | + if ($name === 'take') |
|
225 | 225 | return $this->limit($arguments[0]); |
226 | 226 | |
227 | - if($name === 'get') |
|
227 | + if ($name === 'get') |
|
228 | 228 | return $this->execute(); |
229 | 229 | |
230 | - if($name === 'first') |
|
230 | + if ($name === 'first') |
|
231 | 231 | return $this->execute(true); |
232 | 232 | |
233 | 233 | return $this->writeLog("This method does not exist at the SimplePHP: \"<b>{$name}</b>\"."); |
@@ -300,7 +300,7 @@ discard block |
||
300 | 300 | { |
301 | 301 | $this->type = $type; |
302 | 302 | try { |
303 | - if(!is_object(Connection::getConnection())) |
|
303 | + if (!is_object(Connection::getConnection())) |
|
304 | 304 | return $this->writeLog("Connection failed. Check your connection config and try again.", true); |
305 | 305 | |
306 | 306 | $execute = Connection::getConnection()->query("SELECT {$this->params} FROM {$this->table} {$this->where} {$this->group} {$this->order} {$this->limit} {$this->offset}"); |
@@ -381,7 +381,7 @@ discard block |
||
381 | 381 | $log = new Logger('SimplePHP'); |
382 | 382 | $log->pushHandler(new StreamHandler(self::$config["pathLog"], Logger::WARNING)); |
383 | 383 | |
384 | - if($pdo) { |
|
384 | + if ($pdo) { |
|
385 | 385 | $log->error($message); |
386 | 386 | return; |
387 | 387 | } |
@@ -80,9 +80,13 @@ discard block |
||
80 | 80 | |
81 | 81 | $this->childClass = new ChildSimplePHP(get_called_class()); |
82 | 82 | |
83 | - if($tableName) $this->table = $tableName; |
|
83 | + if($tableName) { |
|
84 | + $this->table = $tableName; |
|
85 | + } |
|
84 | 86 | |
85 | - if($primaryKey) $this->primary = $primaryKey; |
|
87 | + if($primaryKey) { |
|
88 | + $this->primary = $primaryKey; |
|
89 | + } |
|
86 | 90 | } |
87 | 91 | |
88 | 92 | private function setRealTable() : ?SimplePHP |
@@ -218,17 +222,21 @@ discard block |
||
218 | 222 | */ |
219 | 223 | public function __call(String $name, $arguments) |
220 | 224 | { |
221 | - if($name === 'skip') |
|
222 | - return $this->offset($arguments[0]); |
|
225 | + if($name === 'skip') { |
|
226 | + return $this->offset($arguments[0]); |
|
227 | + } |
|
223 | 228 | |
224 | - if($name === 'take') |
|
225 | - return $this->limit($arguments[0]); |
|
229 | + if($name === 'take') { |
|
230 | + return $this->limit($arguments[0]); |
|
231 | + } |
|
226 | 232 | |
227 | - if($name === 'get') |
|
228 | - return $this->execute(); |
|
233 | + if($name === 'get') { |
|
234 | + return $this->execute(); |
|
235 | + } |
|
229 | 236 | |
230 | - if($name === 'first') |
|
231 | - return $this->execute(true); |
|
237 | + if($name === 'first') { |
|
238 | + return $this->execute(true); |
|
239 | + } |
|
232 | 240 | |
233 | 241 | return $this->writeLog("This method does not exist at the SimplePHP: \"<b>{$name}</b>\"."); |
234 | 242 | } |
@@ -250,7 +258,9 @@ discard block |
||
250 | 258 | { |
251 | 259 | if (!empty($this->excepts)) { |
252 | 260 | foreach ($this->excepts as $except) { |
253 | - if (isset($this->data[$except])) unset($this->data[$except]); |
|
261 | + if (isset($this->data[$except])) { |
|
262 | + unset($this->data[$except]); |
|
263 | + } |
|
254 | 264 | } |
255 | 265 | } |
256 | 266 | } |
@@ -300,8 +310,9 @@ discard block |
||
300 | 310 | { |
301 | 311 | $this->type = $type; |
302 | 312 | try { |
303 | - if(!is_object(Connection::getConnection())) |
|
304 | - return $this->writeLog("Connection failed. Check your connection config and try again.", true); |
|
313 | + if(!is_object(Connection::getConnection())) { |
|
314 | + return $this->writeLog("Connection failed. Check your connection config and try again.", true); |
|
315 | + } |
|
305 | 316 | |
306 | 317 | $execute = Connection::getConnection()->query("SELECT {$this->params} FROM {$this->table} {$this->where} {$this->group} {$this->order} {$this->limit} {$this->offset}"); |
307 | 318 | $execute->rowCount() > 1 ? |
@@ -27,7 +27,7 @@ discard block |
||
27 | 27 | $text = iconv('utf-8', 'us-ascii//TRANSLIT', $text); |
28 | 28 | $text = preg_replace('~[^-\w]+~', '', trim($text, '-')); |
29 | 29 | $text = preg_replace('~-+~', '-', strtolower($text)); |
30 | - if(empty($text)) { return null; } |
|
30 | + if (empty($text)) { return null; } |
|
31 | 31 | return $text; |
32 | 32 | } |
33 | 33 | |
@@ -82,8 +82,8 @@ discard block |
||
82 | 82 | * @return string |
83 | 83 | */ |
84 | 84 | public function getAdressIP() { |
85 | - if(array_key_exists('HTTP_X_FORWARDED_FOR', $_SERVER) && !empty($_SERVER['HTTP_X_FORWARDED_FOR'])) { |
|
86 | - if(strpos($_SERVER['HTTP_X_FORWARDED_FOR'], ',') > 0) { |
|
85 | + if (array_key_exists('HTTP_X_FORWARDED_FOR', $_SERVER) && !empty($_SERVER['HTTP_X_FORWARDED_FOR'])) { |
|
86 | + if (strpos($_SERVER['HTTP_X_FORWARDED_FOR'], ',') > 0) { |
|
87 | 87 | $addr = explode(",", $_SERVER['HTTP_X_FORWARDED_FOR']); |
88 | 88 | return trim($addr[0]); |
89 | 89 | } else { |
@@ -89,8 +89,7 @@ |
||
89 | 89 | } else { |
90 | 90 | return $_SERVER['HTTP_X_FORWARDED_FOR']; |
91 | 91 | } |
92 | - } |
|
93 | - else { |
|
92 | + } else { |
|
94 | 93 | return $_SERVER['REMOTE_ADDR']; |
95 | 94 | } |
96 | 95 | } |
@@ -41,7 +41,7 @@ discard block |
||
41 | 41 | PDO::ATTR_ORACLE_NULLS => PDO::NULL_EMPTY_STRING |
42 | 42 | ] |
43 | 43 | ]; |
44 | - if(empty(self::$conn)) { |
|
44 | + if (empty(self::$conn)) { |
|
45 | 45 | self::connectPdo(); |
46 | 46 | } |
47 | 47 | |
@@ -55,7 +55,7 @@ discard block |
||
55 | 55 | { |
56 | 56 | date_default_timezone_set(self::$config['timezone']); |
57 | 57 | |
58 | - if(empty(self::$conn)) { |
|
58 | + if (empty(self::$conn)) { |
|
59 | 59 | try { |
60 | 60 | self::$conn = new PDO( |
61 | 61 | self::$config['driver'] . ":host=" . |
@@ -67,7 +67,7 @@ discard block |
||
67 | 67 | self::$config['password'], |
68 | 68 | self::$config['options'] |
69 | 69 | ); |
70 | - } catch(PDOException $exception) { |
|
70 | + } catch (PDOException $exception) { |
|
71 | 71 | return false; |
72 | 72 | } |
73 | 73 | } |
@@ -78,10 +78,10 @@ discard block |
||
78 | 78 | $realDirectory = dirname(__DIR__, 5); |
79 | 79 | $completeDirectoryToLog = $realDirectory . DIRECTORY_SEPARATOR . $_ENV['PATH_LOG']; |
80 | 80 | |
81 | - if(!file_exists($completeDirectoryToLog . 'Logs.log')) { |
|
81 | + if (!file_exists($completeDirectoryToLog . 'Logs.log')) { |
|
82 | 82 | try { |
83 | 83 | fopen($completeDirectoryToLog . 'Logs.log', 'a'); |
84 | - } catch(Exception $error) { |
|
84 | + } catch (Exception $error) { |
|
85 | 85 | return false; |
86 | 86 | } |
87 | 87 | } |