function insert()
{
global $database_table_prefix;
if (!empty($this->artist)) {
$result = mysql_query("\n\t\t\t\tSELECT *\n\t\t\t\tFROM `" . $database_table_prefix . "artist`\n\t\t\t\tWHERE `name` = '" . addslashes($this->artist) . "'\n\t\t\t") or die(mysql_error());
if (mysql_num_rows($result) == 0) {
$artist = new artist();
$artist->name = $this->artist;
$artist->insert();
$this->artist_id = $artist->id;
} else {
while ($data = mysql_fetch_object($result)) {
$this->artist_id = $data->id;
}
}
}
if (!empty($this->album)) {
$result = mysql_query("\n\t\t\t\tSELECT *\n\t\t\t\tFROM `" . $database_table_prefix . "album`\n\t\t\t\tWHERE `name` = '" . addslashes($this->album) . "'\n\t\t\t\tAND `artist` = '" . addslashes($this->artist_id) . "'\n\t\t\t") or die(mysql_error());
if (mysql_num_rows($result) == 0) {
$album = new album();
$album->name = $this->album;
$album->artist = $this->artist_id;
$album->insert();
$this->album_id = $album->id;
} else {
while ($data = mysql_fetch_object($result)) {
$this->album_id = $data->id;
}
}
}
$result = mysql_query("\n\t\t\tINSERT \n\t\t\tINTO `" . $database_table_prefix . "song`\n\t\t\t( `name`\n\t\t\t, `rating`\n\t\t\t, `play_count`\n\t\t\t, `artist`\n\t\t\t, `album`\n\t\t\t)\n\t\t\tVALUES \n\t\t\t( '" . addslashes($this->name) . "'\n\t\t\t, '" . addslashes($this->rating) . "'\n\t\t\t, '" . addslashes($this->play_count) . "'\n\t\t\t, '" . addslashes($this->artist_id) . "'\n\t\t\t, '" . addslashes($this->album_id) . "'\n\t\t\t)\n\t\t") or die(mysql_error());
$this->id = mysql_insert_id();
}
public function saveAction($name)
{
$doctrine = $this->getDoctrine();
$em = $doctrine->getManager();
//obtention des données de l'artiste
$url = "https://api.spotify.com/v1/search?&type=artist&q=" . $name;
$data = file_get_contents($url);
$tab = json_decode($data, true);
// le true permet de convertir l'objet en tableau
$groupe = new artist();
$groupe->setNom($tab["artists"]["items"][0]["name"]);
$groupe->setSpotId($tab["artists"]["items"][0]["id"]);
$groupe->setPhoto($tab["artists"]["items"][0]["images"][2]["url"]);
$groupe->setGenre($tab["artists"]["items"][0]["genres"]);
$groupe->setPopularite($tab["artists"]["items"][0]["popularity"]);
$em->persist($groupe);
$em->flush();
$artistes = str_replace(' ', '_', $tab["name"]);
return $this->redirect($this->generateUrl('afpa_artist_name', array('name' => $artistes)));
}
