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