DQL Symfony 2删除数据

Question

我只是Symfony2中的DQL函数的问题，我有代码：

    public function editAction(Request $request, $regkey){
    try{
        if($request->isMethod('POST')){
            $newpassword = $request->request->get('newpassword');
            $confirmpassword = $request->request->get('confirmpassword');
            $username = $request->request->get('username');
            if ($newpassword != $confirmpassword){
                return new JsonResponse(['userRegistration' => 'Confirm password is wrong, please make sure your confirm password']);
            }
            $userRegistrationId = $this->getDoctrineRepo(UserRegistration::class)->getIdbyRegisterKey($regkey);
            if ($userRegistrationId == null){
                return new JsonResponse(['userRegistration' => 'Registration key is wrong, Please make sure your registration']);
            }
            $userNameCorrect = $userRegistrationId[0]['user']['username'];
            $userid = $userRegistrationId[0]['user']['id'];
            if ($username != $userNameCorrect){
                return new JsonResponse(['userRegistration' =>  'user name is wrong, please insert user name correctly']);
            }
            $userEntity = $this->getDoctrineRepo(User::class)->find($userid);
            $userEntity->setActivate(1);
            $userEntity->setActivationDate(new DateTime());
        }
    }
    catch (Exception $ex){
        return new JsonResponse(['errMsg' => $ex], 500);
    }
    return new JsonResponse(['userRegistration' => 'Validation user success']);
}

有一个$ userregistrationId，我想删除该数据，我该如何编码此问题？

Answer 1

如果要删除获取到$ userregistrationId的userregistration，则需要获取对象而不是ID。您可以使用FindOneby（）并使用EntityManager进行删除该对象。