@@ -4,7 +4,7 @@ |
||
| 4 | 4 | use core\HTML\flashmessage\FlashMessage; |
| 5 | 5 | use PDO; |
| 6 | 6 | |
| 7 | - class Database extends Querybuilder{
|
|
| 7 | + class Database extends Querybuilder {
|
|
| 8 | 8 | private $db_type; |
| 9 | 9 | private $db_name; |
| 10 | 10 | private $db_user; |
@@ -53,8 +53,7 @@ discard block |
||
| 53 | 53 | if ($query) {
|
| 54 | 54 | $obj = $query->fetchAll(PDO::FETCH_OBJ); |
| 55 | 55 | return $obj; |
| 56 | - } |
|
| 57 | - else {
|
|
| 56 | + } else {
|
|
| 58 | 57 | FlashMessage::setFlash("Une erreur est survenue en executant cette requette : ".$req);
|
| 59 | 58 | } |
| 60 | 59 | } |
@@ -73,8 +72,7 @@ discard block |
||
| 73 | 72 | $err = true; |
| 74 | 73 | } |
| 75 | 74 | } |
| 76 | - } |
|
| 77 | - else {
|
|
| 75 | + } else {
|
|
| 78 | 76 | if (!$query->execute($value)) {
|
| 79 | 77 | $err = true; |
| 80 | 78 | } |
@@ -96,8 +94,7 @@ discard block |
||
| 96 | 94 | public function rechercherEgalite($table, $champ, $value, $id_table = null, $id = null) {
|
| 97 | 95 | if ($id == null) {
|
| 98 | 96 | $query = $this->getPdo()->query("SELECT COUNT($champ) as nb FROM $table WHERE $champ LIKE '$value'");
|
| 99 | - } |
|
| 100 | - else {
|
|
| 97 | + } else {
|
|
| 101 | 98 | $query = $this->getPdo()->query("SELECT COUNT($champ) as nb FROM $table WHERE $champ LIKE '$value' AND $id_table != $id");
|
| 102 | 99 | } |
| 103 | 100 | |
@@ -106,9 +103,10 @@ discard block |
||
| 106 | 103 | $nb = $obj["nb"]; |
| 107 | 104 | } |
| 108 | 105 | |
| 109 | - if ((isset($nb)) && ($nb != 0)) return true; |
|
| 110 | - } |
|
| 111 | - else {
|
|
| 106 | + if ((isset($nb)) && ($nb != 0)) { |
|
| 107 | + return true; |
|
| 108 | + } |
|
| 109 | + } else {
|
|
| 112 | 110 | return false; |
| 113 | 111 | } |
| 114 | 112 | } |
@@ -125,8 +123,7 @@ discard block |
||
| 125 | 123 | |
| 126 | 124 | if ($query->rowCount() > 0) {
|
| 127 | 125 | return true; |
| 128 | - } |
|
| 129 | - else {
|
|
| 126 | + } else {
|
|
| 130 | 127 | return false; |
| 131 | 128 | } |
| 132 | 129 | } |