public function selectBandMemberInstruments($bandID, $memberID, $dbConnection = null)
{
$preparedStatement = null;
$bandMemberInstruments = null;
try {
if ($bandID !== null) {
if ($dbConnection == null) {
$dbConnection = DatabaseUtilities::getDatabaseConnection();
}
$preparedStatement = $dbConnection->prepare(BandMemberInstrumentDao::BAND_MEMBER_INSTRUMENT_SELECT);
$preparedStatement->bindParam(BandMemberInstrumentDao::BAND_ID_PARAMETER, $bandID);
$preparedStatement->bindParam(BandMemberInstrumentDao::MEMBER_ID_PARAMETER, $memberID);
$preparedStatement->execute();
while ($result = $preparedStatement->fetch()) {
$bandMemberInstruments[] = BandMemberInstrumentDao::extractBandMemberInstrumentObject($result);
}
$preparedStatement = null;
}
} catch (PDOException $ex) {
echo 'Caught exception: ' . $ex->getMessage() . "\n";
$bandMemberInstruments = null;
}
return $bandMemberInstruments;
}
public function deleteBandMemberAdmin($targetMemberID, $bandID, $dbConnection = null)
{
$processed = false;
try {
if (BandMemberInstrumentDao::deleteBandMemberInstruments($bandID, $targetMemberID, $dbConnection)) {
$processed = BandMemberDao::deleteBandMember($bandID, $targetMemberID, $dbConnection);
}
} catch (Exception $ex) {
echo "activateBandMember error: " . $ex->getMessage();
$processed = false;
}
return $processed;
}
