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