public function for_song() { $error = array(); $song_clem = DB::connection('clem')->query('SELECT title, album, artist, albumartist, year, genre, filename,track FROM songs'); foreach ($song_clem as $value) { /* AJOUT D'ARTISTES */ if (trim($value->artist) != '') { $band = new Band(null, 1, utf8_encode($value->artist), null, null); try { $band->add(); } catch (Exception $e) { $this->_error_msg .= 'artiste :' . $e->getMessage() . '<br>'; break; } } /* AJOUT D'ALBUM */ if (trim($value->album) != '') { $name_band = Band::from_name_band(utf8_encode($value->artist)); $album = new Album(null, $name_band[0]->id_band, 1, utf8_encode($value->album), $value->year); try { $album->add(); } catch (Exception $e) { $this->_error_msg .= 'album: ' . $e->getMessage() . '<br>'; break; } } if (trim($value->title) != '') { $album = Album::from_name_album(utf8_encode($value->album)); $song = new song(null, 1, utf8_encode($value->title), $value->year, null, $value->filename, $value->track); $song->set_id_kind(explode(';', $value->genre)); $song->id_album = $album[0]->id_album; try { $song->add(); } catch (Exception $e) { $this->_error_msg .= 'chanson: ' . $e->getMessage() . '<br>'; break; } } } // var_dump($song_clem); }