public function action_add() { $user = $this->is_logged(); if ($user === false) { return Redirect::to_action('login'); } else { $kind = Kind::all(); $form = Session::get('form'); $band_selected = null; $id_band = null; if (isset($_POST['band'])) { $band_selected = $_POST['band']; } if (isset($form['id_group'])) { $band_selected = $form['id_group']; } if (isset($_POST['id_group'])) { $band_selected = $_POST['id_group']; } if (isset($form)) { $album_selected = $form['album']; } else { $album_selected = null; } if (isset($band_selected)) { $album = Album::get_from_id($band_selected); if (count($album) != 0) { $album_for_select = array(); foreach ($album as $value) { $album_for_select[$value->id_album] = $value->name_album; } if (isset($_POST['id_band'])) { $band_selected = $_POST['band']; } if (isset($_POST['band'])) { $band_selected = $_POST['band']; } } else { $album_for_select = null; $this->_error_msg = "Ce groupe n'a pas d'album, veuillez l'ajouter! </br>"; } } else { $album_for_select = null; } $band = Band::all(); $band_for_select = array(); foreach ($band as $value) { $band_for_select[$value->attributes['id_band']] = $value->attributes['name_band']; } return View::make('content.song.add')->with('band', $band_for_select)->with('band_selected', $band_selected)->with('album_selected', $album_selected)->with('album', $album_for_select)->with('msg', $this->_error_msg)->with('kinds', $kind); } }
public function for_genre() { $error = array(); $genres = DB::connection('clem')->query('SELECT DISTINCT(genre) FROM songs'); $genre_unique = array(); foreach ($genres as $value) { $genre_explode = explode(';', $value->genre); //var_dump($value); foreach ($value as $one) { $one_explode = explode(';', $one); foreach ($one_explode as $ftg) { if (trim($ftg) != '') { $genre_unique[] = trim($ftg); } } } } $genre_unique = array_unique($genre_unique); foreach ($genre_unique as $value) { $kind = new Kind(utf8_encode($value)); try { $kind->add(); } catch (Exception $e) { $this->_error_msg .= 'genre: ' . $e->getMessage() . '<br>'; } } }