215,7 → 215,7 |
|
$requeteLiaisons = 'SELECT SQL_CALC_FOUND_ROWS * '. |
'FROM '.$this->gestionBdd->formaterTable('del_observation', 'dob'). |
'INNER JOIN '.$this->gestionBdd->formaterTable('del_obs_images', 'doi'). |
'INNER JOIN '.$this->gestionBdd->formaterTable('del_obs_image', 'doi'). |
'ON doi.id_observation = dob.id_observation '. |
'INNER JOIN del_utilisateur du '. |
'ON du.id_utilisateur = doi.id_utilisateur '; |
233,7 → 233,7 |
private function compterObservations() { |
$requete = 'SELECT FOUND_ROWS() AS nbre '; |
$resultats = $this->bdd->recuperer($requete); |
return $resultats['nbre']; |
return (int) $resultats['nbre']; |
} |
|
/** |
260,7 → 260,7 |
|
foreach ($observations as $id => $observation) { |
|
$requeteImages = 'SELECT * FROM '. $this->gestionBdd->formaterTable('del_obs_images', 'doi'). |
$requeteImages = 'SELECT * FROM '. $this->gestionBdd->formaterTable('del_obs_image', 'doi'). |
'INNER JOIN '.$this->gestionBdd->formaterTable('del_image', 'di'). |
'ON doi.id_image = di.id_image '. |
'WHERE doi.id_observation = '.$observation['id_observation']; |