function getCountCalendar() { $bdd = parent::getBdd(); $sql = 'SELECT count(*)'; $sql .= ' FROM `rdv`'; $datas = $bdd->query($sql); if ($resultat = $datas->fetch(PDO::FETCH_ASSOC)) { $count = $resultat; } return $count; // Accès au résultat }
function getAllCategory() { $bdd = parent::getBdd(); $sql = "SELECT * "; $sql .= "FROM `markers_icone` as MKI "; $sql .= "WHERE MKI.icone_actif = 'Oui' "; $datas = $bdd->query($sql); while ($resultat = $datas->fetch(PDO::FETCH_OBJ)) { $count[] = $resultat; } return $count; }
/** * Constructeur de la class, * Fait parti du design pattern singleton * <br>Lie la base de donnée * @since 1.0.0 */ private function __construct() { $this->bdd = BDD::getBdd(); }