All pastes #199938 Raw Edit

Unnamed

public text v1 · immutable
#199938 ·published 2006-10-12 21:03 UTC
rendered paste body
<?php

class Artist {
	public $Artist;
	public $ArtistID;
	
	function _getArtistByName($Artist) {
		$query = "SELECT * FROM mdb_artist WHERE Artist = '$Artist'";
		$result = mysql_query($query);
		// No need for a loop, we will never get more then 1 entry.
		$row = mysql_fetch_object($result);
		$ArtistData['Artist']	= $row->Artist;
		$ArtistData['ArtistID']	= $row->ArtistID;
		return $ArtistData;
	}
	
	function _getArtistByID($ArtistID) {
		$query = "SELECT * FROM mdb_artist WHERE ArtistID = '$ArtistID'";
		$result = mysql_query($query);
		// No need for a loop, we will never get more then 1 entry.
		$row = mysql_fetch_object($result);
		$ArtistData['Artist']	= $row->Artist;
		$ArtistData['ArtistID']	= $row->ArtistID;
		return $ArtistData;
	}
}

class Albums {
	public $AlbumName;
	public $AlbumID;
	
	function _getAlbumByName($AlbumName) {
		$query = "SELECT * FROM mdb_albums WHERE AlbumName = '$AlbumName'";
		$result = mysql_query($query);
		// No need for a loop, we will never get more then 1 entry.
		$row = mysql_fetch_object($result);
		$AlbumData['Name']		= $row->AlbumName;
		$AlbumData['Date']		= $row->AlbumDate;
		$AlbumData['Type']		= $row->AlbumType;
		$AlbumData['NumSongs']	= $row->AlbumNumSongs;
		$AlbumData['ArtistID']	= $row->AlbumArtistID;
		$AlbumData['ID']		= $row->AlbumID;
		return $AlbumData;
	}
	
}

?>