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>
