Carregar resultado das consultas para editar e excluir dados através do Hidden
Ola galera do php tenho dois botões na viewConsultaUsuarios onde depois que eu carrego a consulta eu posso editar ou excluir meus dados que vem dos métodos ctlEditarsetor() e ctlExcluirSetor() por sua vez passo ele pelo GET que carrega numa URL mas só que não quero passar ele Pela Url e sim via Hidden tem como fazer isso.
ControleUsuarios.php
<?php
require_once '../modelo/usuario.php';
require_once '../dao/daoUsuario.php';
class controleUsuario {
protected $ObjUsuario;
protected $ObjDaoUsuario;
protected $ctl;
public function __construct() {
$this->ObjUsuario = new usuario();
$this->ObjDaoUsuario = new daoUsuario();
}
public function ctlExcluirUsuario() {
if (isset($_POST['btnExcluir'])) {
$this->ObjUsuario->setId_Usuario($_GET['id_usuario']);
echo '<div class="alert-danger">Usuário Excluido com Sucesso!!</div>';
echo "<meta HTTP-EQUIV='refresh' CONTENT='8;URL=../visaoAdministrador/VisaoConsultarUsuario.php'>";
return $this->ObjDaoUsuario->excluirUsuario($this->ObjUsuario);
}
}
public function ctlEditarUsuario() {
if (isset($_POST['btnEditar'])) {
$this->ObjUsuario->setId_usuario($_GET['id_usuario']);
$this->ObjUsuario->setNome($_POST['txtnome']);
$this->ObjUsuario->setEmail($_POST['txtemail']);
$this->ObjUsuario->setPerfil($_POST['cbperfil']);
$this->ObjUsuario->setUsuario($_POST['txtusuario']);
$this->ObjUsuario->setSenha($_POST['txtsenha']);
echo '<div class="alert-info">Usuário Editado com Sucesso!!</div>';
return $this->ObjDaoUsuario->editarUsuario($this->ObjUsuario);
}
}
public function ctlListarUsuario() {
if (isset($_POST['btnpesq'])) {
$this->ObjUsuario->setNome($_POST['txtpesquisar']);
return $this->ObjDaoUsuario->listarUsuario($this->ObjUsuario);
}
}
public function ctlPassar_Usuario() {
$this->ObjUsuario->setId_Usuario($_GET['id_usuario']);
return $this->ObjDaoUsuario->passarId_Usuario($this->ObjUsuario);
}
}
VisaoConsultarUsuario.php
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Consultar Usuário:</title>
<link rel="stylesheet" type="text/css" href="../css/style.css">
<link rel="stylesheet" type="text/css" href="../css/alerta.css">
<link rel="stylesheet" type="text/css" href="../css/bootstrap.css">
<link rel="stylesheet" type="text/css" href="../css/bootstrap.min.css">
<link rel="stylesheet" type="text/css" href="../css/glyphicon.css">
<script language="javascript" type="text/javascript" src="../js/JQuery.mim.js"></script>
<script language="javascript" type="text/javascript" src="../js/bootstrap.js"></script>
<script language="javascript" type="text/javascript" src="../js/modal.js"></script>
</head>
<body>
<div id="topo">
<?php
require_once '../controle/controleUsuario.php';
$cs = new controleUsuario();
$Listar = $cs->ctlListarUsuario();
?>
</div>
<div class="cabecalho">
<div class="container-fluid">
<form method="post" class="form-inline alinharConsulta">
<table width="659" border="0">
<tr>
<td width="376" align="center" valign="middle"><input name = "txtpesquisar" placeholder="Digite Consulta:" type ="text" size = "50" class = "form-control"></td>
<td width="127" valign="middle"> <input type="submit" name="btnpesq" class="btn btn-info" value="Consultar:"></td>
<td width="142" align="right" valign="middle"> <a class = "btn btn-danger" href ="../index.php">Sair:</a></td>
</tr>
</table>
</form>
</div>
</div>
<div class="conteudo letras">
<form method="post">
<table width="200" border="0" class="table table-condensed letras">
<tr>
<td align="center" valign="middle">Nome:</td>
<td align="center" valign="middle">Email:</td>
<td align="center" valign="middle">Perfil:</td>
<td align="center" valign="middle">Usuário:</td>
<td align="center" valign="middle">Editar:</td>
<td align="center" valign="middle">Excluir:</td>
</tr>
<?php foreach ($Listar as $key => $vl) { ?>
<tr>
<td align="center" valign="middle"><?= $vl['nome'] ?></td>
<td align="center" valign="middle"><?= $vl['email'] ?></td>
<td align="center" valign="middle"><?= $vl['perfil'] ?></td>
<td align="center" valign="middle"><?= $vl['usuario'] ?></td>
<td align="center" valign="middle"><a class="btn btn-info" href="../visaoAdministrador/VisaoEditarUsuario.php?id_usuario=<?= $vl['id_usuario']; ?>">Editar:</a></td>
<td align="center" valign="middle"><a class="btn btn-danger" href="../visaoAdministrador/VisaoExcluirUsuario.php?id_usuario=<?= $vl['id_usuario']; ?>">Excluir:</a></td>
</tr>
<?php } ?>
</table>
</form>
</div>
</body>
</html>
VisaoEditarUsuario.php
<?php
require_once '../controle/controleUsuario.php';
$cs = new controleUsuario();
$array = $cs->ctlPassar_id_Usuario();
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Editar Usuário:</title>
<link rel="stylesheet" type="text/css" href="../css/style.css">
<link rel="stylesheet" type="text/css" href="../css/alerta.css">
<link rel="stylesheet" type="text/css" href="../css/bootstrap.css">
<!-- JS -->
<script language="javascript" type="application/javascript" src="../js/bootstrap.js"></script>
<script language="javascript" type="application/javascript" src="../js/JQuery.mim.js"></script>
<script language="javascript" type="application/javascript" src="../js/fechar.js"></script>
<script language="javascript" type="application/javascript" src="#"></script>
</head>
<body>
<div id="topo">
<div id="m">
<?php $cs->ctlEditarUsuario(); ?>
</div>
</div>
<div class="cabecalho">
</div>
<?php foreach ($array as $key => $vl) { ?>
<div class = "conteudo">
<div class = "container-fluid">
<form method = "post" class = "alinharFormCad letras">
<div class = "row">
<div class = "col-6">
<label>Nome:</label>
<input name = "txtnome" type = "text" value="<?= $vl['nome'] ?>" size = "50" class = "form-control">
</div>
</div>
<div class = "row">
<div class = "col-6">
<label>Email:</label>
<input name = "txtemail" type = "Email" value="<?= $vl['email'] ?>" size = "50" class = "form-control">
</div>
</div>
<div class = "row">
<div class = "col-6">
<label>Perfil:</label>
<select name = "cbperfil" class = "form-control input-group-addon">
<option value = "Administrador">ADMINISTRADOR:</option>
<option value = "Cliente">CLIENTE:</option>
<option value = "Socio">SOCIO:</option>
</select>
</div>
</div>
<div class = "row">
<div class = "col-4">
<label>Usuário:</label>
<input name = "txtusuario" type = "text" value="<?= $vl['usuario'] ?>" size = "35" maxlength = "35" class = "form-control">
</div>
</div>
<div class = "row">
<div class = "col-4">
<label>Senha:</label>
<input name = "txtsenha" type = "password" value="<?= $vl['senha'] ?>" size = "6" maxlength = "6" class = "form-control">
</div>
<?php } ?>
</div>
<div class = "row">
<div class = "col-6"></br>
<input name = "btnEditar" type ="submit" value = "Editar:" class = "btn btn-info">
<a class = "btn btn-danger" href = "../visaoAdministrador/VisaoConsultarUsuario.php">Sair:</a></div>
</div>
</form>
</div>
</div>
</body>
</html>
VisaoExcluirUsuarios.php
<?php
require_once '../controle/controleUsuario.php';
$cs = new controleUsuario();
$array = $cs->ctlPassar_id_Usuario();
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Excluir Usuário:</title>
<link rel="stylesheet" type="text/css" href="../css/style.css">
<link rel="stylesheet" type="text/css" href="../css/alerta.css">
<link rel="stylesheet" type="text/css" href="../css/bootstrap.css">
<!-- JS -->
<script language="javascript" type="application/javascript" src="../js/bootstrap.js"></script>
<script language="javascript" type="application/javascript" src="../js/JQuery.mim.js"></script>
<script language="javascript" type="application/javascript" src="../js/fechar.js"></script>
<script language="javascript" type="application/javascript" src="#"></script>
</head>
<body>
<div id="topo">
<div id="m">
<?php $cs->ctlExcluirUsuario(); ?>
</div>
</div>
<div class="cabecalho">
</div>
<?php foreach ($array as $key => $vl) { ?>
<div class = "conteudo">
<div class = "container-fluid">
<form method = "post" class = "alinharFormCad letras">
<div class = "row">
<div class = "col-6">
<label>Nome:</label>
<input name = "txtnome" disabled type = "text" value="<?= $vl['nome'] ?>" size = "50" class = "form-control">
</div>
</div>
<div class = "row">
<div class = "col-6">
<label>Email:</label>
<input name = "txtemail" disabled type = "Email" value="<?= $vl['email'] ?>" size = "50" class = "form-control">
</div>
</div>
<div class = "row">
<div class = "col-6">
<label>Perfil:</label>
<input name = "txtperfil" disabled type = "text" value="<?= $vl['perfil'] ?>" size = "50" class = "form-control">
</div>
</div>
<div class = "row">
<div class = "col-4">
<label>Usuário:</label>
<input name = "txtusuario" disabled type = "text" value="<?= $vl['usuario'] ?>" size = "35" maxlength = "35" class = "form-control">
</div>
</div>
<div class = "row">
<div class = "col-4">
<label>Senha:</label>
<input name = "txtsenha" disabled type = "password" value="<?= $vl['senha'] ?>" size = "6" maxlength = "6" class = "form-control">
</div>
</div>
<div class = "row">
<div class = "col-6"></br>
<input name = "btnExcluir" type ="submit" value = "Excluir:" class = "btn btn-info">
<a class = "btn btn-danger" href = "../visaoAdministrador/VisaoConsultarUsuario.php">Sair:</a></div>
<?php } ?>
</div>
</form>
</div>
</div>
</body>
</html>Discussão (2)
Carregando comentários...