->where('a.name=? and a.artist_id=?', array(trim($album), $db_artist['artist_id'])) ->fetchOne(); if (!$db_album) { $db_album = new Album(); $db_album['name'] = trim($album); $db_album['Artist'] = $db_artist; $db_album['added_by_user_id'] = $_SESSION['user']['user_id']; $db_album->save(); } //Add the link from the album to the user $useralbum = Doctrine_Query::create() ->from('UserAlbum a') ->where('a.user_id=? and a.album_id=?', array($_SESSION['user']['user_id'], $db_album['album_id'])) ->fetchOne(); if (!$useralbum) { $useralbum = new UserAlbum(); $useralbum['user_id'] = $_SESSION['user']['user_id']; $useralbum['album_id'] = $db_album['album_id']; $useralbum->save(); } echo "Artist/Album added <a href='library.php'>Back to Library</a>"; } else { echo "Invalid artist!"; } } ?> </form> </div> </div> </div>
if (!$db_album || count($db_album) == 0) { //If we don't we have to add it to the database' $db_album = new Album(); $db_album['name'] = trim($album); $db_album['artist_id'] = $db_artist['artist_id']; $db_album['added_by_user_id'] = $_SESSION['user']['user_id']; $db_album->save(); } $useralbum = Doctrine_Query::create() ->select('count(*)') ->from('UserAlbum a') ->where('a.user_id=? and a.album_id=?', array($_SESSION['user']['user_id'], $db_album['album_id'])) ->fetchOne(array(), Doctrine::HYDRATE_ARRAY); //var_dump($useralbum); if ($useralbum['count'] == 0) { $useralbum = new UserAlbum(); $useralbum['user_id'] = $_SESSION['user']['user_id']; $useralbum['album_id'] = $db_album['album_id']; $useralbum->save(); $useralbum->free(); //we are done with it after we save } //$db_album->free(); //echo " Album: $album<br />\n"; } //$db_artist->free(); } } xml_parser_free($xml_parser); fclose($fp); echo "file uploaded.<br>"; echo '<META HTTP-EQUIV=Refresh CONTENT="0; URL=library.php">';