Piou-piou /
ribs-framework
| @@ 103-121 (lines=19) @@ | ||
| 100 | * @param $value |
|
| 101 | * @return boolean|null |
|
| 102 | */ |
|
| 103 | public function rechercherEgalite($table, $champ, $value, $id_table = null, $id = null) {
|
|
| 104 | if ($id == null) {
|
|
| 105 | $query = $this->getPdo()->query("SELECT COUNT($champ) as nb FROM $table WHERE $champ LIKE '$value'");
|
|
| 106 | } |
|
| 107 | else {
|
|
| 108 | $query = $this->getPdo()->query("SELECT COUNT($champ) as nb FROM $table WHERE $champ LIKE '$value' AND $id_table != $id");
|
|
| 109 | } |
|
| 110 | ||
| 111 | if (count($query) > 0) {
|
|
| 112 | foreach ($query as $obj) {
|
|
| 113 | $nb = $obj["nb"]; |
|
| 114 | } |
|
| 115 | ||
| 116 | if ((isset($nb)) && ($nb != 0)) return true; |
|
| 117 | } |
|
| 118 | else {
|
|
| 119 | return false; |
|
| 120 | } |
|
| 121 | } |
|
| 122 | //-------------------------- FIN FUNCTION QUI FONT DES REQUETES SUR LA BDD --------------------------------------------// |
|
| 123 | ||
| 124 | ||
| @@ 96-114 (lines=19) @@ | ||
| 93 | * @param $value |
|
| 94 | * @return boolean|null |
|
| 95 | */ |
|
| 96 | public function rechercherEgalite($table, $champ, $value, $id_table = null, $id = null) {
|
|
| 97 | if ($id == null) {
|
|
| 98 | $query = $this->getPdo()->query("SELECT COUNT($champ) as nb FROM $table WHERE $champ LIKE '$value'");
|
|
| 99 | } |
|
| 100 | else {
|
|
| 101 | $query = $this->getPdo()->query("SELECT COUNT($champ) as nb FROM $table WHERE $champ LIKE '$value' AND $id_table != $id");
|
|
| 102 | } |
|
| 103 | ||
| 104 | if (count($query) > 0) {
|
|
| 105 | foreach ($query as $obj) {
|
|
| 106 | $nb = $obj["nb"]; |
|
| 107 | } |
|
| 108 | ||
| 109 | if ((isset($nb)) && ($nb != 0)) return true; |
|
| 110 | } |
|
| 111 | else {
|
|
| 112 | return false; |
|
| 113 | } |
|
| 114 | } |
|
| 115 | //-------------------------- FIN FUNCTION QUI FONT DES REQUETES SUR LA BDD --------------------------------------------// |
|
| 116 | ||
| 117 | ||
