Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //** UsuariosController.php **//
- public function chkLoginAjax()
- {
- $usuariosDAO = new \Projeto\Core\DAO\UsuariosDAO();
- $usuario = $usuariosDAO->getById(2);
- $usuario->setLogin('aaaaaaaaaaaa');
- $retorno = $usuariosDAO->queryChkLogin($usuario);
- die(var_dump($retorno));
- }
- //** UsuariosDAO.php extends DAO.php **//
- public function queryChkLogin(\Projeto\Core\Model\Usuarios $usuario)
- {
- try
- {
- $dql = "SELECT u
- FROM \Projeto\Core\Model\Usuarios u
- WHERE u.login = :login AND
- u.id <> :id";
- $params = array('login' => $usuario->getLogin(),
- 'id' => $usuario->getId());
- return $this->queryDAO($dql);
- } catch (Exception $e)
- {
- return false;
- }
- }
- //** DAO.php **//
- protected function queryDAO($dql, Array $params = null)
- {
- $query = self::$entityManager->createQuery($dql);
- if ($params)
- $query->setParameters($params);
- var_dump($query);
- return $query->getResult();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement