| 1,6 → 1,10 |
|---|
| <?php |
| class Dictionnaire extends RestService { |
| |
| // SELECT a.id, a.cle, b.id, b.cle FROM definitions a, definitions b WHERE a.id != b.id AND INSTR(b.cle, a.cle) != 0 order by a.cle; |
| // SELECT group_concat( distinct a.id) FROM definitions a, definitions b WHERE a.id != b.id AND INSTR(b.cle, a.cle) != 0 |
| static $sous_mots = array(20,22,33,37,65,103,106,151,160,164,177,202,220,222,230,249,250,257,262,276,284,307,334,352,359,394,397,401,422,437,438,449,452,453,463,469,475,498,517,527,547,549,550,585,603,604,606,607,638,641,660); |
| |
| //+----------------------------------------------------------------------------------------------------------------+ |
| // Consulter |
| public function consulter($ressources, $parametres) { |
| 47,8 → 51,7 |
|---|
| } |
| |
| private function getDefinition($mot) { |
| |
| $requete_selection_definition = 'SELECT valeur FROM definitions WHERE cle = "'.$this->simplifier($mot).'"'; |
| $requete_selection_definition = 'SELECT valeur FROM definitions WHERE cle = "'. self::simplifier($mot).'"'; |
| $definition = $this->bdd->recuperer($requete_selection_definition); |
| |
| return $definition; |
| 55,32 → 58,26 |
|---|
| } |
| |
| private function getToutesDefinitions() { |
| |
| $requete_selection_toutes_definitions = 'SELECT valeur FROM definitions'; |
| $definitions = $this->bdd->recupererTous($requete_selection_toutes_definitions); |
| |
| return $definitions; |
| return $this->bdd->recupererTous('SELECT valeur FROM definitions'); |
| } |
| |
| private function getMots() { |
| |
| $requete_selection_mots = 'SELECT cle FROM definitions'; |
| $mots = $this->bdd->recupererTous($requete_selection_mots); |
| |
| foreach($mots as &$mot) { |
| $mot['cle'] = $mot['cle']; |
| } |
| return $mots; |
| |
| private function getMots() { |
| /* |
| $requete = sprintf('SELECT cle FROM definitions WHERE id NOT IN (%s) ORDER BY LENGTH(cle) DESC', |
| implode(",", self::$sous_mots)); |
| $requete = sprintf('SELECT cle FROM definitions WHERE id NOT IN (%s)', |
| implode(",", self::$sous_mots)); |
| */ |
| $requete = 'SELECT cle FROM definitions'; |
| |
| $assoc = $this->bdd->recupererTous($requete); |
| array_walk($assoc, function(&$item) { $item = $item['cle']; }); |
| return $assoc; |
| } |
| |
| function simplifier($chaine){ |
| |
| $sans_accent = strtr($chaine,'àáâãäçèéêëìíîïñòóôõöùúûüýÿÀÁÂÃÄÇÈÉÊËÌÍÎÏÑÒÓÔÕÖÙÚÛÜÝ', |
| 'aaaaaceeeeiiiinooooouuuuyyAAAAACEEEEIIIINOOOOOUUUUY'); |
| |
| $en_minuscule = strtolower($sans_accent); |
| |
| return $en_minuscule; |
| static function simplifier($chaine){ |
| return strtolower(iconv('UTF-8', 'ASCII//TRANSLIT', $chaine)); |
| } |
| } |
| ?> |