public function getplaylistAction() { $id = $_GET["id"]; $dba = Zend_Registry::get('dba'); // On récupère l'instance de la BDD $this->_helper->layout->disableLayout(true); // Permet de ne pas afficher le layout $this->_helper->viewRenderer->setNoRender(true); // Permet de ne pas redirigé vers une autre page $playlists = new Application_Model_DansPlaylist($dba); $where = $dba->quoteInto("ID_MUSIQUE = ?", $id); $playlist_results = $playlists->fetchAll($where)->toArray(); $result = array(); foreach ($playlist_results as $playlist) { $playlist_table = new Application_Model_Playlist($dba); $playlist_row = $playlist_table->find($playlist["PLAY_ID"]); $current_playlist = $playlist_row->current(); $genre_table = new Application_Model_Genre($dba); $genre_row = $genre_table->find($current_playlist["ID_GENRE"]); $genre = $genre_row->current(); $result[] = array("PLAY_ID" => $current_playlist["PLAY_ID"], "NOM_PLAYLIST" => $current_playlist["NOM_PLAY"], "NOM_GENRE" => $genre["NOM_G"]); } date_default_timezone_set("Europe/Paris"); $musique_table = new Application_Model_Musique($dba); $musique = $musique_table->fetchRow($where)->toArray(); $date = strtotime($musique["DATE_AJOUT"]); $membre_table = new Application_Model_Membre($dba); $where_membre = $dba->quoteInto("ID_MEMBRE = ?", $musique["ID_MEMBRE"]); $membre = $membre_table->fetchRow($where_membre)->toArray(); usort($result, array('PlaylistController', 'compare')); $complete_result = array("ID_MUSIQUE" => $musique["ID_MUSIQUE"], "MEMBRE" => $membre["LOGIN"], "TITRE_M" => $musique["TITRE_M"], "GENRE_M" => $musique["GENRE_M"], "ALBUM" => $musique["ALBUM"], "DATE" => date("d/m/Y", $date), "PLAYLIST" => $result); $json = json_encode($complete_result); // On renvoie le tout sous format JSON echo $json; }