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 searchbuttonAction() { $value = $_GET["value"]; $column = $_GET["column"]; $order = $_GET["order"]; $dba = Zend_Registry::get('dba'); $this->_helper->layout->disableLayout(true); $this->_helper->viewRenderer->setNoRender(true); $musique_table = new Application_Model_Musique($dba); $select = $musique_table->select()->where("TITRE_M LIKE ?", '%' . $value . '%')->orWhere("ARTISTE LIKE ?", '%' . $value . '%')->orWhere("ALBUM LIKE ?", '%' . $value . '%')->orWhere("GENRE_M LIKE ?", '%' . $value . '%')->orWhere("ANNEE LIKE ?", '%' . $value . '%')->order("{$column} {$order}")->limit($this->item_per_page); $select2 = $musique_table->select()->where("TITRE_M LIKE ?", '%' . $value . '%')->orWhere("ARTISTE LIKE ?", '%' . $value . '%')->orWhere("ALBUM LIKE ?", '%' . $value . '%')->orWhere("GENRE_M LIKE ?", '%' . $value . '%')->orWhere("ANNEE LIKE ?", '%' . $value . '%'); $musiques = $musique_table->fetchAll($select)->toArray(); $indexes = ceil(count($musique_table->fetchAll($select2)->toArray()) / $this->item_per_page); $musiques_result = array(); date_default_timezone_set("Europe/Paris"); foreach ($musiques as $musique) { $date = strtotime($musique["DATE_AJOUT"]); $musiques_result[] = array("TITRE_M" => $musique["TITRE_M"], "ARTISTE" => $musique["ARTISTE"], "ALBUM" => $musique["ALBUM"], "ID_MUSIQUE" => $musique["ID_MUSIQUE"], "DATE_AJOUT" => date("d/m/Y", $date)); } $result = array("INDEXES" => $indexes, "MUSIQUES" => $musiques_result); $json = json_encode($result); echo $json; }