Example #1
0
 public function update(Event $event)
 {
     $sql = 'UPDATE ' . $this->table . ' SET meetup_venue_id = :meetup_venue_id, joindin_event_name = :joindin_event_name,' . ' joindin_talk_id = :joindin_talk_id, joindin_url = :joindin_url, speaker_id = :speaker_id,' . ' supporter_id = :supporter_id, meetup_date = :meetup_date' . ' WHERE meetup_id = :meetup_id';
     $stmt = $this->db->prepare($sql);
     $stmt->bindValue(":meetup_id", $event->getMeetupID(), \PDO::PARAM_INT);
     $stmt->bindValue(":meetup_venue_id", $event->getMeetupVenueID(), \PDO::PARAM_INT);
     $stmt->bindValue(":joindin_event_name", $event->getJoindinEventName(), \PDO::PARAM_STR);
     $stmt->bindValue(":joindin_talk_id", $event->getJoindinTalkID(), \PDO::PARAM_INT);
     $stmt->bindValue(":joindin_url", $event->getJoindinURL(), \PDO::PARAM_STR);
     $stmt->bindValue(":speaker_id", $event->getSpeakerID(), \PDO::PARAM_INT);
     $stmt->bindValue(":supporter_id", $event->getSupporterID(), \PDO::PARAM_INT);
     $stmt->bindValue(":meetup_date", $event->getMeetupDate()->format('Y-m-d H:i:s'), \PDO::PARAM_STR);
     return $stmt->execute();
 }