Subversion Repositories Applications.dictionnaire

Rev

Rev 8 | Rev 14 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 8 Rev 10
Line 75... Line 75...
75
		$requete = sprintf('SELECT cle FROM definitions WHERE id NOT IN (%s) ORDER BY LENGTH(cle) DESC',
75
		$requete = sprintf('SELECT cle FROM definitions WHERE id NOT IN (%s) ORDER BY LENGTH(cle) DESC',
76
						   implode(",", self::$sous_mots));
76
						   implode(",", self::$sous_mots));
77
		$requete = sprintf('SELECT cle FROM definitions WHERE id NOT IN (%s)',
77
		$requete = sprintf('SELECT cle FROM definitions WHERE id NOT IN (%s)',
78
						   implode(",", self::$sous_mots));
78
						   implode(",", self::$sous_mots));
79
		*/
79
		*/
80
		$requete = 'SELECT cle FROM definitions';
80
		$requete = 'SELECT TRIM(cle) as cle FROM definitions';  // certaines cles ont des espaces
81
		$assoc = $this->bdd->recupererTous($requete);
81
		$assoc = $this->bdd->recupererTous($requete);
Line 82... Line 82...
82
 
82
 
83
		array_walk($assoc, function(&$item) { $item = $item['cle']; });
83
		array_walk($assoc, function(&$item) { $item = $item['cle']; });
84
		return $assoc;
84
		return $assoc;