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