</head>
<body>
<?php
require_once 'interface/Entidade.interface.php';
require_once 'classes/Usuario.class.php';
require_once 'classes/ServiceDb.class.php';
require_once "conexao.php";
$pdo = Conectar();
$usuario = new Usuario();
$processo = new ServiceDb($pdo, $usuario);
$id = filter_input(INPUT_GET, "id") ? filter_input(INPUT_GET, "id") : NULL;
$acao = filter_input(INPUT_GET, "acao") ? filter_input(INPUT_GET, "acao") : NULL;
switch ($acao) {
case "editar_usuario":
$ident = "&id=" . $id;
$login = $processo->Find("id=:id", $id)["login"];
$senha = $processo->Find("id=:id", $id)["senha"];
$bt = "EDITAR USUÁRIO";
$acao = "Editar";
break;
case "excluir_usuario":
$ident = "&id=" . $id;
$login = $processo->Find("id=:id", $id)["login"];
$senha = $processo->Find("id=:id", $id)["senha"];
$bt = "DESEJA MESMO EXCLUIR ESTE USUÁRIO?";
$acao = "Excluir";
break;
case "inserir_usuario":
$ident = "";
$login = "";
$senha = "";
break;
case 4:
$ident = "";
$campo1 = "value = \"\" name = 'login' id = 'login'";
$campo2 = "value = \"\" name = 'senha' id = 'senha'";
$lb1 = "login";
$lb2 = "senha";
$bt = "CADASTRAR USUÁRIO ";
$acao = "cad_user";
break;
case 7:
$usuario = new Usuario();
$processo = new ServiceDb($pdo, $usuario);
$id = filter_input(INPUT_GET, "id") ? filter_input(INPUT_GET, "id") : NULL;
$ident = "&id=" . $id;
$campo1 = "value = '" . $processo->Find($id)["login"] . "' name = 'login' id = 'login'";
$campo2 = "value = '" . $processo->Find($id)["senha"] . "' name = 'senha' id = 'senha'";
$lb1 = "login";
$lb2 = "senha";
$bt = "EDITAR USUÁRIO";
$acao = "editar";
break;
}
?>
<form method="post" action="executar.php?acao=<?php
echo $acao . $ident;
?>
">
<fieldset>
<legend><?php
echo $bt;
<h1>LISTA DE ALUNOS</h1>
<?php
$busca = filter_input(INPUT_GET, "busca_aluno") ? filter_input(INPUT_GET, "busca_aluno") : NULL;
$id = filter_input(INPUT_GET, "id") ? filter_input(INPUT_GET, "id") : NULL;
$acao = filter_input(INPUT_GET, "acao") ? filter_input(INPUT_GET, "acao") : NULL;
require_once 'interface/Entidade.interface.php';
require_once 'classes/ServiceDb.class.php';
require_once 'classes/Aluno.class.php';
require_once 'classes/Update.class.php';
require_once "conexao.php";
$pdo = Conectar();
$aluno = new Aluno();
$exec = new ServiceDb($pdo, $aluno);
if (!isset($busca)) {
foreach ($exec->Listar("id ASC") as $listar) {
echo $listar->nome . ", nota: " . $listar->nota . " - <a href='index.php?id=" . $listar->id . "&sessao=3&acao=editar_aluno'> Editar</a> | <a href='index.php?id=" . $listar->id . "&acao=excluir_aluno&sessao=3'> Excluir </a> <br />";
}
} else {
$atributos = $exec->Find("nome=:nome", $busca);
echo $atributos["nome"] . ", nota: " . $atributos["nota"] . " - <a href='index.php?id=" . $atributos["id"] . "&sessao=3&acao=editar_aluno'> Editar</a> | <a href='index.php?id=" . $atributos["id"] . "&acao=excluir_aluno&sessao=3'> Excluir </a> <br />";
}
?>
<br /><br />
<form method="get" action="#">
<label for="busca_aluno">Busca Aluno</label>
<input type="text" name="busca_aluno" id="busca_aluno"/>
<input type="submit" value="buscar" />
</form>
<br /><br />
<body>
<?php
require_once 'interface/Entidade.interface.php';
require_once 'classes/Aluno.class.php';
require_once 'classes/ServiceDb.class.php';
require_once 'classes/ServiceDb.class.php';
require_once "conexao.php";
$pdo = Conectar();
$aluno = new Aluno();
$processo = new ServiceDb($pdo, $aluno);
$acao = filter_input(INPUT_GET, "acao") ? filter_input(INPUT_GET, "acao") : NULL;
switch ($acao) {
case "editar":
$id = filter_input(INPUT_GET, "id") ? filter_input(INPUT_GET, "id") : NULL;
$ident = "&id=" . $id;
$nome = $processo->Find($id)["nome"];
$nota = $processo->Find($id)["nota"];
$bt = "EDITAR";
break;
case NULL:
$bt = "CADASTRAR";
$ident = "";
$nome = "";
$nota = "";
$acao = "cadastrar";
break;
}
?>
<form method="post" action="executar.php?acao=<?php
echo $acao . $ident;
?>
<body>
<?php
require_once 'interface/Entidade.interface.php';
require_once 'classes/Aluno.class.php';
require_once 'classes/ServiceDb.class.php';
require_once 'classes/ServiceDb.class.php';
require_once "conexao.php";
$pdo = Conectar();
$aluno = new Aluno();
$processo = new ServiceDb($pdo, $aluno);
$id = filter_input(INPUT_GET, "id") ? filter_input(INPUT_GET, "id") : NULL;
$acao = filter_input(INPUT_GET, "acao") ? filter_input(INPUT_GET, "acao") : NULL;
switch ($acao) {
case "editar_aluno":
$ident = "&id=" . $id;
$nome = $processo->Find("id=:id", $id)["nome"];
$nota = $processo->Find("id=:id", $id)["nota"];
$bt = "EDITAR ALUNO";
$acao = "Editar";
break;
case "excluir_aluno":
$ident = "&id=" . $id;
$nome = $processo->Find("id=:id", $id)["nome"];
$nota = $processo->Find("id=:id", $id)["nota"];
$bt = "DESEJA MESMO EXCLUIR ESTE ALUNO?";
$acao = "Excluir";
break;
case "inserir_aluno":
$ident = "";
$nome = "";
$nota = "";
