protected function modify(ProfilePro $profilePro) { $q = $this->dao->prepare('UPDATE ' . $this->table() . ' SET COMPANY_NAME = :companyName, LASTNAME = :lastname, FIRSTNAME = :firstname, DESCRIPTION = :description, PHONE = :phone, MOBILE_PHONE = :mobilePhone, OFFICE_PHONE = :officePhone, WEBSITE = :website, AVATAR = :avatar, USER_ID = :userId, MAIN_ADDRESS_ID = :mainAddressId WHERE ID = :id'); $q->bindValue(':companyName', $profilePro->getCompanyName()); $q->bindValue(':lastname', $profilePro->getLastname()); $q->bindValue(':firstname', $profilePro->getFirstname()); $q->bindValue(':description', $profilePro->getDescription()); $q->bindValue(':phone', $profilePro->getPhone()); $q->bindValue(':mobilePhone', $profilePro->getMobilePhone()); $q->bindValue(':officePhone', $profilePro->getOfficePhone()); $q->bindValue(':website', $profilePro->getWebsite()); $q->bindValue(':avatar', $profilePro->getAvatar()); $q->bindValue(':userId', $profilePro->getUserId(), PDO::PARAM_INT); $q->bindValue(':mainAddressId', $profilePro->getMainAddressId(), PDO::PARAM_INT); $q->bindValue(':id', $profilePro->id(), PDO::PARAM_INT); $q->execute(); }