public function deactivateBand($memberID, $bandID, $dbConnection) { $success = false; try { $bandDetails = new Band(); $bandDetails->setVariable(Band::BAND_ID, $bandID); $bandDetails->setVariable(Band::ACTIVE, 2); $success = BandDao::updateBand($memberID, $bandDetails, $dbConnection); } catch (Exception $ex) { echo 'Caught exception: ', $ex->getMessage(), "\n"; $success = false; } return $success; }
public function updateBand($memberID, $bandDetails, $dbConnection) { $preparedStatement = null; $processed = false; try { if ($memberID != null & $bandDetails->getVariable(Band::BAND_ID) !== null) { if ($dbConnection == null) { $dbConnection = DatabaseUtilities::getDatabaseConnection(); } $bandUpdateQuery = BandDao::getBandUpdateQuery($bandDetails); $preparedStatement = BandDao::getBandUpdatePreparedStatement($bandUpdateQuery, $memberID, $bandDetails, $dbConnection); if ($preparedStatement->execute()) { } $processed = true; $preparedStatement = null; } } catch (Exception $ex) { echo 'Caught exception: ' . $ex->getMessage() . "\n"; } return $processed; }