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