public function logar($email, $senha) { $sess = Sessao::instanciar(); $connect = new ConnectionDB("mysql:host=localhost;dbname=application", "root", ""); $instance = $connect->connect(); $instance->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION); $sql = "SELECT * FROM usuarios WHERE email = ? AND senha = ?"; $stmt = $instance->prepare($sql); $stmt->execute([$email, $senha]); $data = $stmt->fetch(\PDO::FETCH_ASSOC); if ($data) { $usuario = new Usuario(); $usuario->setEmail($email); $usuario->setId($data['id']); $usuario->setNome($data['nome']); $usuario->setSenha($senha); $usuario->setAdmin($data['admin']); $usuario->setAtivo($data['ativo']); $usuario->setCreatedAt($data['created_at']); $usuario->setUpdatedAt($data['updated_at']); $sess->set('usuario', $usuario); return true; } else { return false; } }
require_once '..\\..\\vendor\\autoload.php'; use App\Classes\Database\ConnectionDB; use App\Classes\Entities\Usuario; use App\Classes\Configurations; use App\Classes\LoginController; use App\Classes\Session\Sessao; if (!empty($_REQUEST)) { $config = new Configurations(); $dataConf = $config->dataBaseConfiguration(); $connect = new ConnectionDB($dataConf['DSN'], $dataConf['user'], $dataConf['pwd']); $instance = $connect->connect(); $instance->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); switch ($_REQUEST['acao']) { case 'register': $user = new Usuario(); $user->setNome($_REQUEST['nome']); $user->setEmail($_REQUEST['email']); $user->setSenha($_REQUEST['senha']); $sql = 'INSERT INTO usuarios(nome, email, senha) VALUES (?, ?, ?)'; $stmt = $instance->prepare($sql); $newUser = $stmt->execute($user->register()); if ($newUser) { $login = new LoginController(); $login->logar($user->getEmail(), $user->getSenha()); header('location:/../../pagamento.php'); } else { die($newUser); } break; case 'profile': $session = Sessao::instanciar();