public function selectMemberInstruments($memberID, $skeleton = false, $dbConnection = null)
{
$memberInstrumentsList = null;
try {
if ($memberID != null) {
if ($dbConnection == null) {
$dbConnection = DatabaseUtilities::getDatabaseConnection();
}
$preparedStatement = $dbConnection->prepare(MemberInstrumentDao::MEMBER_INSTRUMENT_SELECT);
$preparedStatement->bindParam(MemberInstrumentDao::MEMBER_ID_PARAMETER, $memberID);
$preparedStatement->execute();
while ($result = $preparedStatement->fetch()) {
$memberID = $result[MemberInstrumentDao::MEMBER_ID_FIELD];
$instrumentID = $result[MemberInstrumentDao::INSTRUMENT_ID_FIELD];
if ($memberID != null) {
//Create new objects
$memberInstrument = new MemberInstrument();
$memberInstrument->setVariable(MemberInstrument::MEMBER_ID, $result[MemberInstrumentDao::MEMBER_ID_FIELD]);
$memberInstrument->setVariable(MemberInstrument::INSTRUMENT_ID, $result[MemberInstrumentDao::INSTRUMENT_ID_FIELD]);
$memberInstrument->setVariable(MemberInstrument::INSTRUMENT_NAME, $result[MemberInstrumentDao::INSTRUMENT_NAME_FIELD]);
if (!$skeleton) {
$memberInstrument->setVariable(MemberInstrument::EXPERIENCE_ID, $result[MemberInstrumentDao::EXPERIENCE_ID_FIELD]);
$memberInstrument->setVariable(MemberInstrument::STYLES, MemberInstrumentDao::selectMemberInstrumentsStyles($memberID, $instrumentID, $dbConnection));
}
$memberInstrumentsList[] = $memberInstrument;
}
}
$preparedStatement = null;
}
} catch (Exception $ex) {
//Do Nothing
}
return $memberInstrumentsList;
}
