public function edit(HumanPopItInfoModel $humanPopItInfoModel) { global $DB; try { $DB->beginTransaction(); $stat = $DB->prepare("UPDATE human_popit_information SET " . " name=:name, mapit_id=:mapit_id , gender_female=:gender_female, gender_male=:gender_male, email=:email, " . " party=:party, birth_date=:birth_date,facebook=:facebook, twitter=:twitter, image_url=:image_url, image_proxy_url=:image_proxy_url " . "WHERE id=:id"); $stat->execute(array('id' => $humanPopItInfoModel->getId(), 'mapit_id' => $humanPopItInfoModel->getMapitId(), 'name' => $humanPopItInfoModel->getName(), 'gender_female' => $humanPopItInfoModel->getGenderFemale() ? 1 : 0, 'gender_male' => $humanPopItInfoModel->getGenderMale() ? 1 : 0, 'email' => $humanPopItInfoModel->getEmail(), 'party' => $humanPopItInfoModel->getParty(), 'birth_date' => $humanPopItInfoModel->getBirthDate(), 'facebook' => $humanPopItInfoModel->getFacebook(), 'twitter' => $humanPopItInfoModel->getTwitter(), 'image_url' => $humanPopItInfoModel->getImageUrl(), 'image_proxy_url' => $humanPopItInfoModel->getImageProxyUrl())); $DB->commit(); } catch (Exception $e) { $DB->rollBack(); } }