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;
}
