@@ -34,7 +34,7 @@ discard block |
||
34 | 34 | { |
35 | 35 | date_default_timezone_set($this->config['timezone']); |
36 | 36 | |
37 | - if(empty($this->conn)) { |
|
37 | + if (empty($this->conn)) { |
|
38 | 38 | try { |
39 | 39 | $this->conn = new PDO( |
40 | 40 | $this->config['driver'] . ":host=" . |
@@ -46,7 +46,7 @@ discard block |
||
46 | 46 | $this->config['password'], |
47 | 47 | $this->config['options'] |
48 | 48 | ); |
49 | - } catch(PDOException $exception) { |
|
49 | + } catch (PDOException $exception) { |
|
50 | 50 | echo json_encode( |
51 | 51 | ['error' => |
52 | 52 | [ |
@@ -27,7 +27,7 @@ |
||
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 |
@@ -57,7 +57,7 @@ discard block |
||
57 | 57 | $sql->bindParam($data[$i], $values[$i]); |
58 | 58 | } |
59 | 59 | return $sql->execute(); |
60 | - } catch(PDOException $exception) { |
|
60 | + } catch (PDOException $exception) { |
|
61 | 61 | return $this->writeLog($exception->getMessage(), true); |
62 | 62 | } |
63 | 63 | } |
@@ -70,20 +70,20 @@ discard block |
||
70 | 70 | public function insert(String $params, Array $values): ?bool |
71 | 71 | { |
72 | 72 | try { |
73 | - $parameters = "(".$params.")"; |
|
73 | + $parameters = "(" . $params . ")"; |
|
74 | 74 | $params = explode(',', $params); |
75 | 75 | $data = []; |
76 | 76 | $countParams = count($params); |
77 | - for($i = 0; $i < $countParams; $i++) { |
|
78 | - $data[$i] = ":". $params[$i] . $i; |
|
77 | + for ($i = 0; $i < $countParams; $i++) { |
|
78 | + $data[$i] = ":" . $params[$i] . $i; |
|
79 | 79 | } |
80 | - $valueBind = "(".implode(', ', $data).")"; |
|
80 | + $valueBind = "(" . implode(', ', $data) . ")"; |
|
81 | 81 | $sql = $this->conn->prepare("INSERT INTO {$this->table} $parameters VALUES $valueBind"); |
82 | - for($i = 0; $i < $countParams; $i++) { |
|
82 | + for ($i = 0; $i < $countParams; $i++) { |
|
83 | 83 | $sql->bindParam($data[$i], $values[$i]); |
84 | 84 | } |
85 | 85 | return $sql->execute(); |
86 | - } catch(PDOException $exception) { |
|
86 | + } catch (PDOException $exception) { |
|
87 | 87 | return $this->writeLog($exception->getMessage(), true); |
88 | 88 | } |
89 | 89 | } |
@@ -92,9 +92,9 @@ discard block |
||
92 | 92 | */ |
93 | 93 | public function where(Array $where, String $condition = 'AND'): ?SimplePHP |
94 | 94 | { |
95 | - foreach($where as $enclosures) { |
|
96 | - $split = isset($enclosures[3]) && !$enclosures[3] ? $enclosures[2] : "'".$enclosures[2]."'"; |
|
97 | - $this->where .= $enclosures[0]." ".$enclosures[1]." ".$split." {$condition} "; |
|
95 | + foreach ($where as $enclosures) { |
|
96 | + $split = isset($enclosures[3]) && !$enclosures[3] ? $enclosures[2] : "'" . $enclosures[2] . "'"; |
|
97 | + $this->where .= $enclosures[0] . " " . $enclosures[1] . " " . $split . " {$condition} "; |
|
98 | 98 | } |
99 | 99 | $this->where = "WHERE " . rtrim($this->where, " {$condition} "); |
100 | 100 | |
@@ -119,9 +119,9 @@ discard block |
||
119 | 119 | public function orWhere(Array $orWhere, String $condition = 'AND'): ?SimplePHP |
120 | 120 | { |
121 | 121 | $moreWhere = ''; |
122 | - foreach($orWhere as $enclosures) { |
|
123 | - $split = isset($enclosures[3]) && !$enclosures[3] ? $enclosures[2] : "'".$enclosures[2]."'"; |
|
124 | - $moreWhere .= $enclosures[0]." ".$enclosures[1]." ".$split." {$condition} "; |
|
122 | + foreach ($orWhere as $enclosures) { |
|
123 | + $split = isset($enclosures[3]) && !$enclosures[3] ? $enclosures[2] : "'" . $enclosures[2] . "'"; |
|
124 | + $moreWhere .= $enclosures[0] . " " . $enclosures[1] . " " . $split . " {$condition} "; |
|
125 | 125 | } |
126 | 126 | $this->where .= " OR " . rtrim($moreWhere, " {$condition} "); |
127 | 127 | |
@@ -165,7 +165,7 @@ discard block |
||
165 | 165 | */ |
166 | 166 | public function orderBy(String $prop, String $ordenation = 'ASC'): ?SimplePHP |
167 | 167 | { |
168 | - if(mb_strlen($this->order) < 9) { |
|
168 | + if (mb_strlen($this->order) < 9) { |
|
169 | 169 | $this->order = "ORDER BY {$prop} {$ordenation}"; |
170 | 170 | } else { |
171 | 171 | $this->order .= ", {$prop} {$ordenation}"; |
@@ -179,7 +179,7 @@ discard block |
||
179 | 179 | */ |
180 | 180 | public function groupBy(String $prop): ?SimplePHP |
181 | 181 | { |
182 | - if(mb_strlen($this->group) < 9) { |
|
182 | + if (mb_strlen($this->group) < 9) { |
|
183 | 183 | $this->group = "GROUP BY {$prop}"; |
184 | 184 | } else { |
185 | 185 | $this->group .= ", {$prop}"; |
@@ -194,10 +194,10 @@ discard block |
||
194 | 194 | */ |
195 | 195 | public function __call(String $name, $arguments) : ?SimplePHP |
196 | 196 | { |
197 | - if($name === 'skip') |
|
197 | + if ($name === 'skip') |
|
198 | 198 | return $this->offset($arguments[0]); |
199 | 199 | |
200 | - if($name === 'take') |
|
200 | + if ($name === 'take') |
|
201 | 201 | return $this->limit($arguments[0]); |
202 | 202 | |
203 | 203 | $this->writeLog("This method does not exist at the SimplePHP: \"<b>{$name}</b>\"."); |
@@ -194,11 +194,13 @@ discard block |
||
194 | 194 | */ |
195 | 195 | public function __call(String $name, $arguments) : ?SimplePHP |
196 | 196 | { |
197 | - if($name === 'skip') |
|
198 | - return $this->offset($arguments[0]); |
|
197 | + if($name === 'skip') { |
|
198 | + return $this->offset($arguments[0]); |
|
199 | + } |
|
199 | 200 | |
200 | - if($name === 'take') |
|
201 | - return $this->limit($arguments[0]); |
|
201 | + if($name === 'take') { |
|
202 | + return $this->limit($arguments[0]); |
|
203 | + } |
|
202 | 204 | |
203 | 205 | $this->writeLog("This method does not exist at the SimplePHP: \"<b>{$name}</b>\"."); |
204 | 206 | return null; |
@@ -221,7 +223,9 @@ discard block |
||
221 | 223 | { |
222 | 224 | if (!empty($this->excepts)) { |
223 | 225 | foreach ($this->excepts as $except) { |
224 | - if (isset($this->data[$except])) unset($this->data[$except]); |
|
226 | + if (isset($this->data[$except])) { |
|
227 | + unset($this->data[$except]); |
|
228 | + } |
|
225 | 229 | } |
226 | 230 | } |
227 | 231 | } |