public function insertNewTimeBoard(TimeBoard $board) { $sql = 'INSERT INTO accountability (user_id , vak , minuten , notitie , datum) VALUES (:user_id , :course , :minutes , :note , :date )'; $params = array('user_id' => $board->getUser()->getId(), 'course' => $board->getCourse()->getId(), 'minutes' => $board->getMinutes(), 'note' => $board->getNote(), 'date' => $board->getDate()); $this->conn->executeUpdate($sql, $params); $board->setId($this->conn->lastInsertId()); }
public function insertNewTimeBoard(TimeBoard $board) { $sql = 'INSERT INTO planning (vak , notitie , datum) VALUES , :course , :note , :date )'; $params = array('course' => $board->getCourse()->getId(), 'note' => $board->getNote(), 'date' => $board->getDate()); $this->conn->executeUpdate($sql, $params); $board->setId($this->conn->lastInsertId()); }