@@ -51,8 +51,7 @@ discard block |
||
| 51 | 51 | if ($query) { |
| 52 | 52 | $obj = $query->fetchAll(PDO::FETCH_OBJ); |
| 53 | 53 | return $obj; |
| 54 | - } |
|
| 55 | - else { |
|
| 54 | + } else { |
|
| 56 | 55 | FlashMessage::setFlash("Une erreur est survenue en executant cette requette : ".$req); |
| 57 | 56 | } |
| 58 | 57 | } |
@@ -71,8 +70,7 @@ discard block |
||
| 71 | 70 | $err = true; |
| 72 | 71 | } |
| 73 | 72 | } |
| 74 | - } |
|
| 75 | - else { |
|
| 73 | + } else { |
|
| 76 | 74 | if (!$query->execute($value)) { |
| 77 | 75 | $err = true; |
| 78 | 76 | } |
@@ -94,8 +92,7 @@ discard block |
||
| 94 | 92 | public function rechercherEgalite($table, $champ, $value, $id_table = null, $id = null) { |
| 95 | 93 | if ($id == null) { |
| 96 | 94 | $query = $this->getPdo()->query("SELECT COUNT($champ) as nb FROM $table WHERE $champ LIKE '$value'"); |
| 97 | - } |
|
| 98 | - else { |
|
| 95 | + } else { |
|
| 99 | 96 | $query = $this->getPdo()->query("SELECT COUNT($champ) as nb FROM $table WHERE $champ LIKE '$value' AND $id_table != $id"); |
| 100 | 97 | } |
| 101 | 98 | |
@@ -104,9 +101,10 @@ discard block |
||
| 104 | 101 | $nb = $obj["nb"]; |
| 105 | 102 | } |
| 106 | 103 | |
| 107 | - if ((isset($nb)) && ($nb != 0)) return true; |
|
| 108 | - } |
|
| 109 | - else { |
|
| 104 | + if ((isset($nb)) && ($nb != 0)) { |
|
| 105 | + return true; |
|
| 106 | + } |
|
| 107 | + } else { |
|
| 110 | 108 | return false; |
| 111 | 109 | } |
| 112 | 110 | } |
@@ -123,8 +121,7 @@ discard block |
||
| 123 | 121 | |
| 124 | 122 | if ($query->rowCount() > 0) { |
| 125 | 123 | return true; |
| 126 | - } |
|
| 127 | - else { |
|
| 124 | + } else { |
|
| 128 | 125 | return false; |
| 129 | 126 | } |
| 130 | 127 | } |
@@ -111,7 +111,7 @@ discard block |
||
| 111 | 111 | * pour intialiser la ou les clauses where d'une requete |
| 112 | 112 | */ |
| 113 | 113 | public function where($champ, $cond, $champ_test, $closure = null) { |
| 114 | - if ( $closure === null) { |
|
| 114 | + if ($closure === null) { |
|
| 115 | 115 | $this->conditions[] = $champ.$cond.$champ_test; |
| 116 | 116 | } |
| 117 | 117 | else { |
@@ -127,10 +127,10 @@ discard block |
||
| 127 | 127 | * fonction qui permet de récupérer un select fait sur une table |
| 128 | 128 | */ |
| 129 | 129 | public function get() { |
| 130 | - $requete = $this->req_beginning . implode(",", $this->champs) . " FROM " . implode(",", $this->table); |
|
| 130 | + $requete = $this->req_beginning.implode(",", $this->champs)." FROM ".implode(",", $this->table); |
|
| 131 | 131 | |
| 132 | 132 | if (!empty($this->conditions)) { |
| 133 | - $requete .= " WHERE ". implode(" ", $this->conditions); |
|
| 133 | + $requete .= " WHERE ".implode(" ", $this->conditions); |
|
| 134 | 134 | } |
| 135 | 135 | |
| 136 | 136 | $this->unsetQueryBuilder(); |
@@ -145,15 +145,15 @@ discard block |
||
| 145 | 145 | |
| 146 | 146 | $datas = []; |
| 147 | 147 | $count = count($this->champs); |
| 148 | - for ($i=0 ; $i<$count ; $i++) { |
|
| 148 | + for ($i = 0; $i < $count; $i++) { |
|
| 149 | 149 | $datas[] = $this->champs[$i]."=:".$this->champs[$i]; |
| 150 | 150 | } |
| 151 | 151 | |
| 152 | 152 | //si on a des conditions alors on sera dans un insert |
| 153 | - $requete = $this->req_beginning . implode(",", $this->table) . " SET " . implode(", ", $datas); |
|
| 153 | + $requete = $this->req_beginning.implode(",", $this->table)." SET ".implode(", ", $datas); |
|
| 154 | 154 | |
| 155 | 155 | if (!empty($this->conditions)) { |
| 156 | - $requete .= " WHERE " . implode(" ", $this->conditions); |
|
| 156 | + $requete .= " WHERE ".implode(" ", $this->conditions); |
|
| 157 | 157 | } |
| 158 | 158 | |
| 159 | 159 | $this->prepare($requete, $values); |
@@ -164,10 +164,10 @@ discard block |
||
| 164 | 164 | * fonction utilisée pour finir un delete |
| 165 | 165 | */ |
| 166 | 166 | public function del() { |
| 167 | - $requete = $this->req_beginning . implode(",", $this->table); |
|
| 167 | + $requete = $this->req_beginning.implode(",", $this->table); |
|
| 168 | 168 | |
| 169 | 169 | if (!empty($this->conditions)) { |
| 170 | - $requete .= " WHERE " . implode(" ", $this->conditions); |
|
| 170 | + $requete .= " WHERE ".implode(" ", $this->conditions); |
|
| 171 | 171 | } |
| 172 | 172 | |
| 173 | 173 | $this->query($requete); |
@@ -76,8 +76,7 @@ |
||
| 76 | 76 | |
| 77 | 77 | if ($id_page != 0) { |
| 78 | 78 | $query = $dbc->query("SELECT balise_title, meta_description, ID_page FROM page WHERE ID_page=".$id_page); |
| 79 | - } |
|
| 80 | - else { |
|
| 79 | + } else { |
|
| 81 | 80 | $query = $dbc->query("SELECT balise_title, meta_description, ID_page FROM page WHERE url LIKE '$url'"); |
| 82 | 81 | } |
| 83 | 82 | |