/**
  * @param Event $event
  */
 public function save(Event $event)
 {
     $sql = "INSERT INTO {$this->table} (meetup_id, meetup_venue_id, joindin_talk_id, joindin_url, speaker_id, supporter_id) VALUES (" . ":meetup_id, :meetup_venue_id, :joindin_talk_id, :joindin_url, :speaker_id, :supporter_id" . ")";
     $stmt = $this->db->prepare($sql);
     $stmt->bindParam(":meetup_id", $event->getMeetupID(), \PDO::PARAM_INT);
     $stmt->bindParam(":meetup_venue_id", $event->getMeetupVenueID(), \PDO::PARAM_INT);
     $stmt->bindParam(":joindin_talk_id", $event->getJoindinTalkID(), \PDO::PARAM_INT);
     $stmt->bindParam(":joindin_url", $event->getJoindinURL(), \PDO::PARAM_STR);
     $stmt->bindParam(":speaker_id", $event->getSpeakerID(), \PDO::PARAM_INT);
     $stmt->bindParam(":supporter_id", $event->getSupporterID(), \PDO::PARAM_INT);
     $stmt->execute();
     $event->id = $this->db->lastInsertId();
 }
Example #2
0
 /**
  * Event constructor.
  *
  * @param \Kdyby\Doctrine\EntityManager $em
  */
 public function __construct(EntityManager $em)
 {
     $this->em = $em;
     $this->eventRepository = $em->getRepository(Entity\Event::getClassName());
 }