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