Subversion Repositories eFlore/Projets.eflore-projets

Rev

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

Rev 209 Rev 211
Line 58... Line 58...
58
			"	LEFT JOIN $table AS nb ON (ns.basionyme = nb.num_nom) ".
58
			"	LEFT JOIN $table AS nb ON (ns.basionyme = nb.num_nom) ".
59
			$this->getWhere($conditions).
59
			$this->getWhere($conditions).
60
			implode(' AND ', $conditions).
60
			implode(' AND ', $conditions).
61
			'ORDER BY ns.nom_sci ASC '.
61
			'ORDER BY ns.nom_sci ASC '.
62
			"LIMIT $navigation ";
62
			"LIMIT $navigation ";
-
 
63
 
63
		$resultats = $this->bdd->recupererTous($requete);
64
		$resultats = $this->bdd->recupererTous($requete);
Line 64... Line 65...
64
 
65
 
65
		return $resultats;
66
		return $resultats;
Line 113... Line 114...
113
		$resultats = $this->bdd->recupererTous($requete);
114
		$resultats = $this->bdd->recupererTous($requete);
114
		return $resultats;
115
		return $resultats;
115
	}
116
	}
Line 116... Line 117...
116
 
117
 
117
	private function getNavigation() {
118
	private function getNavigation() {
118
		$debut = $this->parametres->get('navigation.depart');
119
		$debut = (int) $this->parametres->get('navigation.depart');
119
		$nbre = $this->parametres->get('navigation.limite');
120
		$nbre = $this->parametres->get('navigation.limite');
-
 
121
		$navigation = "$debut,$nbre";
120
		return "$debut,$nbre";
122
		return $navigation;
Line 121... Line 123...
121
	}
123
	}
122
 
124
 
123
	private function getWhere($conditions = array()) {
125
	private function getWhere($conditions = array()) {