/** * Insert a new User instance into the database. * * @param User $user */ public function insert(User $user) { $sql = 'INSERT INTO users (email, password, salt, roles, time_created) VALUES (:email, :password, :salt, :roles, :timeCreated) '; $params = array('email' => $user->getEmail(), 'password' => $user->getPassword(), 'salt' => $user->getSalt(), 'roles' => implode(',', $user->getRoles()), 'timeCreated' => $user->getTimeCreated()); $this->conn->executeUpdate($sql, $params); $user->setId($this->conn->lastInsertId()); $this->identityMap[$user->getId()] = $user; }