@@ -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->getCode(), true); |
62 | 62 | } |
63 | 63 | } |
@@ -70,20 +70,20 @@ discard block |
||
70 | 70 | public function insert(String $params, Array $values) |
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->getCode(), true); |
88 | 88 | } |
89 | 89 | } |
@@ -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 |
@@ -90,9 +90,9 @@ discard block |
||
90 | 90 | */ |
91 | 91 | public function where(Array $where, String $condition = 'AND'): ?SimplePHP |
92 | 92 | { |
93 | - foreach($where as $enclosures) { |
|
94 | - $split = isset($enclosures[3]) && !$enclosures[3] ? $enclosures[2] : "'".$enclosures[2]."'"; |
|
95 | - $this->where .= $enclosures[0]." ".$enclosures[1]." ".$split." {$condition} "; |
|
93 | + foreach ($where as $enclosures) { |
|
94 | + $split = isset($enclosures[3]) && !$enclosures[3] ? $enclosures[2] : "'" . $enclosures[2] . "'"; |
|
95 | + $this->where .= $enclosures[0] . " " . $enclosures[1] . " " . $split . " {$condition} "; |
|
96 | 96 | } |
97 | 97 | $this->where = "WHERE " . rtrim($this->where, " {$condition} "); |
98 | 98 | |
@@ -117,9 +117,9 @@ discard block |
||
117 | 117 | public function orWhere(Array $orWhere, String $condition = 'AND'): ?SimplePHP |
118 | 118 | { |
119 | 119 | $moreWhere = ''; |
120 | - foreach($orWhere as $enclosures) { |
|
121 | - $split = isset($enclosures[3]) && !$enclosures[3] ? $enclosures[2] : "'".$enclosures[2]."'"; |
|
122 | - $moreWhere .= $enclosures[0]." ".$enclosures[1]." ".$split." {$condition} "; |
|
120 | + foreach ($orWhere as $enclosures) { |
|
121 | + $split = isset($enclosures[3]) && !$enclosures[3] ? $enclosures[2] : "'" . $enclosures[2] . "'"; |
|
122 | + $moreWhere .= $enclosures[0] . " " . $enclosures[1] . " " . $split . " {$condition} "; |
|
123 | 123 | } |
124 | 124 | $this->where .= " OR " . rtrim($moreWhere, " {$condition} "); |
125 | 125 | |
@@ -163,7 +163,7 @@ discard block |
||
163 | 163 | */ |
164 | 164 | public function orderBy(String $prop, String $ordenation = 'ASC'): ?SimplePHP |
165 | 165 | { |
166 | - if(mb_strlen($this->order) < 9) { |
|
166 | + if (mb_strlen($this->order) < 9) { |
|
167 | 167 | $this->order = "ORDER BY {$prop} {$ordenation}"; |
168 | 168 | } else { |
169 | 169 | $this->order .= ", {$prop} {$ordenation}"; |
@@ -177,7 +177,7 @@ discard block |
||
177 | 177 | */ |
178 | 178 | public function groupBy(String $prop): ?SimplePHP |
179 | 179 | { |
180 | - if(mb_strlen($this->group) < 9) { |
|
180 | + if (mb_strlen($this->group) < 9) { |
|
181 | 181 | $this->group = "GROUP BY {$prop}"; |
182 | 182 | } else { |
183 | 183 | $this->group .= ", {$prop}"; |
@@ -192,10 +192,10 @@ discard block |
||
192 | 192 | */ |
193 | 193 | public function __call(String $name, $arguments) |
194 | 194 | { |
195 | - if($name === 'skip') |
|
195 | + if ($name === 'skip') |
|
196 | 196 | return $this->offset($arguments[0]); |
197 | 197 | |
198 | - if($name === 'take') |
|
198 | + if ($name === 'take') |
|
199 | 199 | return $this->limit($arguments[0]); |
200 | 200 | |
201 | 201 | return $this->writeLog("This method does not exist at the SimplePHP: \"<b>{$name}</b>\"."); |
@@ -192,11 +192,13 @@ discard block |
||
192 | 192 | */ |
193 | 193 | public function __call(String $name, $arguments) |
194 | 194 | { |
195 | - if($name === 'skip') |
|
196 | - return $this->offset($arguments[0]); |
|
195 | + if($name === 'skip') { |
|
196 | + return $this->offset($arguments[0]); |
|
197 | + } |
|
197 | 198 | |
198 | - if($name === 'take') |
|
199 | - return $this->limit($arguments[0]); |
|
199 | + if($name === 'take') { |
|
200 | + return $this->limit($arguments[0]); |
|
201 | + } |
|
200 | 202 | |
201 | 203 | return $this->writeLog("This method does not exist at the SimplePHP: \"<b>{$name}</b>\"."); |
202 | 204 | } |
@@ -218,7 +220,9 @@ discard block |
||
218 | 220 | { |
219 | 221 | if (!empty($this->excepts)) { |
220 | 222 | foreach ($this->excepts as $except) { |
221 | - if (isset($this->data[$except])) unset($this->data[$except]); |
|
223 | + if (isset($this->data[$except])) { |
|
224 | + unset($this->data[$except]); |
|
225 | + } |
|
222 | 226 | } |
223 | 227 | } |
224 | 228 | } |