Subversion Repositories eFlore/Applications.cel

Rev

Rev 2014 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2014 Rev 2017
Line 4... Line 4...
4 
	public function obtenirNbObservationsSauvages() {
 4 
	public function obtenirNbObservationsSauvages() {
5 
		$requete = 'SELECT COUNT(*) AS nb '.
 5 
		$requete = 'SELECT COUNT(*) AS nb '.
6 
			'FROM cel_obs '.
 6 
			'FROM cel_obs '.
7 
			'WHERE mots_cles_texte LIKE "%sauvages%" '.
 7 
			'WHERE mots_cles_texte LIKE "%sauvages%" '.
8 
			'	AND mots_cles_texte LIKE "%Projets coopératifs%" '.
 8 
			'	AND mots_cles_texte LIKE "%Projets coopératifs%" '.
- 
 
 9 
			'	AND mots_cles_texte NOT LIKE "%florileges%" '.
9 
			' -- '.__FILE__.' '.__LINE__;
 10 
			' -- '.__FILE__.' '.__LINE__;
Line 10... Line 11...
10 
 
 11 
 
11 
		$resultat = $this->recuperer($requete);
 12 
		$resultat = $this->recuperer($requete);
12 
		return $resultat['nb'];
 13 
		return $resultat['nb'];
Line 15... Line 16...
15 
	public function obtenirObservationsSauvages($debut, $limite) {
 16 
	public function obtenirObservationsSauvages($debut, $limite) {
16 
		$requete = 'SELECT * '.
 17 
		$requete = 'SELECT * '.
17 
			'FROM cel_obs '.
 18 
			'FROM cel_obs '.
18 
			'WHERE mots_cles_texte LIKE "%sauvages%" '.
 19 
			'WHERE mots_cles_texte LIKE "%sauvages%" '.
19 
			'	AND mots_cles_texte LIKE "%Projets coopératifs%" '.
 20 
			'	AND mots_cles_texte LIKE "%Projets coopératifs%" '.
- 
 
 21 
			'	AND mots_cles_texte NOT LIKE "%florileges%" '.
20 
			"LIMIT $debut, $limite ".
 22 
			"LIMIT $debut, $limite ".
21 
			' -- '.__FILE__.' '.__LINE__;
 23 
			' -- '.__FILE__.' '.__LINE__;
Line 22... Line 24...
22 
 
 24 
 
23 
		$resultat = $this->recupererTous($requete);
 25 
		$resultat = $this->recupererTous($requete);