public function getmusiqueAction() { $dba = Zend_Registry::get('dba'); $id = $_GET["id"]; $this->_helper->layout->disableLayout(true); $this->_helper->viewRenderer->setNoRender(true); $dans_table = new Application_Model_DansPlaylist($dba); $musique_table = new Application_Model_Musique($dba); $musique_list = $musique_table->fetchAll()->toArray(); $where = $dba->quoteInto("PLAY_ID = ?", $id); $tmp = $dans_table->fetchAll($where)->toArray(); $res_tab = array(); foreach ($tmp as $pl) { foreach ($musique_list as $m) { if ($pl["ID_MUSIQUE"] == $m["ID_MUSIQUE"]) { $res_tab[] = $m; } } } array_multisort($res_tab, SORT_STRING); $json = json_encode($res_tab); echo $json; }
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; }