/** * Retourne tous les trackers * * @return array */ public static function getTrackers() { $oMysqli = Database::getInstance(); $oResults = $oMysqli->query("SELECT t.*, (SELECT COUNT(*) FROM tks_passkey AS p WHERE t.id = p.id_tracker) AS nb_passkey \r\n FROM tks_trackers as t "); $aResults = array(); while ($aResult = $oResults->fetch_assoc()) { $oTracker = new Tracker($aResult['name'], $aResult['id']); $oTracker->setLink($aResult['link']); $oTracker->setDirectLink($aResult['directlink']); $oTracker->setNbPasskeys($aResult['nb_passkey']); $aResults[$aResult['id']] = $oTracker; } return $aResults; }