public function selectBandMembers($bandID, $dbConnection = null)
{
$preparedStatement = null;
$bandMembers = null;
try {
if ($bandID !== null) {
if ($dbConnection == null) {
$dbConnection = DatabaseUtilities::getDatabaseConnection();
}
$preparedStatement = $dbConnection->prepare(BandMemberDao::BAND_MEMBER_SELECT);
$preparedStatement->bindParam(BandMemberDao::BAND_ID_PARAMETER, $bandID);
$preparedStatement->execute();
while ($result = $preparedStatement->fetch()) {
$bandMember = BandMemberDao::extractBandMemberObject($result, false);
if ($bandMember != null) {
$bandMember->setVariable(Member::MEMBER_INSTRUMENTS, BandMemberInstrumentDao::selectBandMemberInstruments($bandID, $bandMember->getVariable(Member::MEMBER_ID)));
$bandMembers[] = $bandMember;
}
}
$preparedStatement = null;
}
} catch (PDOException $ex) {
echo 'Caught exception: ' . $ex->getMessage() . "\n";
$bandMembers = null;
}
return $bandMembers;
}
