コード例 #1
0
							        ->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>
コード例 #2
0
ファイル: library.php プロジェクト: prismhdd/victorioussecret
							     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 "&nbsp;&nbsp;&nbsp;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">';