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; } }
<?php require_once '..\\..\\vendor\\autoload.php'; use App\Classes\Database\ConnectionDB; $connect = new ConnectionDB("mysql:host=localhost;dbname=application", "root", ""); $instance = $connect->connect(); $instance->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION); $sql = "SELECT * FROM usuarios ORDER BY id"; $stmt = $instance->query($sql); $data = $stmt->fetchAll(\PDO::FETCH_ASSOC); include '../../partials/top-admin.php'; include '../../partials/menu-admin.php'; ?> <div class="container" id="large"> <div class="row"> <div class="col-md-2"> <?php include '../../partials/menu-left-admin.php'; ?> </div> <div class="col-md-10"> <div class="pull-right"><a href="<?php echo 'http://' . $_SERVER['HTTP_HOST']; ?> /admin/users/create.php" class="btn btn-success"><i class="fa fa-user-plus"></i> Adicionar Usuário</a></div> <h1>Lista de Usuários</h1>