usersListar.php
<?php
// http://localhost:8080/aula-17-18/usersListar.php
require_once("ligacao.php");
$sql="SELECT * FROM v1_users ORDER BY nome, apelido ";
$query=mysqli_query($ligarECD, $sql) or die ("Erro 2");
$total=mysqli_num_rows($query);
if($total>0){
$fetch=mysqli_fetch_assoc($query);
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Document</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
</head>
<body>
<div class="container">
<?php if($total==0){?>
<div>
<p>Não há registos para apresentar.</p>
</div>
<?php } elseif($total>0){?>
<div id="tabelaUsers">
<!-- A minha tabela -->
<table class="table">
<thead>
<tr>
<th></th>
<th>#</th>
<th>Nome</th>
<th>Apelido</th>
<th>Username</th>
<th>Privilégio</th>
<th>Estado</th>
</tr>
</thead>
<tbody>
<?php $i=0; do { $i++;?>
<tr>
<td><a href="usersAlterar.php?idUser=<?php echo $fetch['idUser'];?>">Alterar</a></td>
<td><?php echo $i;?></td>
<td><?php echo $fetch['nome'];?></td>
<td><?php echo $fetch['apelido'];?></td>
<td><?php echo $fetch['username'];?></td>
<td><?php echo $fetch['privilegio'];?></td>
<td><?php if($fetch['estadoUser']==1){
echo "Ativo";}
else {
echo "Inativo";}?>
</td>
</tr>
<?php } while($fetch=mysqli_fetch_assoc($query));?>
</tbody>
</table>
</div>
<?php }?>
</div>
</body>
</html>
usersAlterar.php
<?php
// /usersAlterar.php?idUser
require_once("restricao.php");
if(isset($_GET['alterar'])){
$idUser=$_GET['idUser'];
$nome=addslashes($_GET['nome']);
$apelido=addslashes($_GET['apelido']);
$idPrivilegio=$_GET['idPrivilegio'];
$idPessoa=$_GET['idPessoa'];
$estadoUser=$_GET['estadoUser'];
$sql="UPDATE pessoas SET nome = '$nome', apelido = '$apelido' WHERE id = $idPessoa";
require_once("ligacao.php");
mysqli_query($ligarECD, $sql);
$sql="UPDATE users SET estado = $estadoUser, idPrivilegio = $idPrivilegio WHERE id = $idUser";
mysqli_query($ligarECD, $sql);
header("Location:usersListar.php?sucesso");
}
if(!isset($_GET['alterar'])){
if(isset($_GET['idUser'])){
$idUser=$_GET['idUser'];
$sql="SELECT * FROM v1_users WHERE idUser=$idUser";
require_once("ligacao.php");
$query=mysqli_query($ligarECD, $sql);
$total=mysqli_num_rows($query);
if($total==1){
$fetch=mysqli_fetch_assoc($query);
}
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Document</title>
</head>
<body>
<div>
<form>
<!-- // `idUser`, `idPessoa`, , `idPrivilegio` -->
<div>
<input type="text" name="nome" required value="<?php echo $fetch['nome'];?>">
</div>
<div>
<input type="text" name="apelido" required value="<?php echo $fetch['apelido'];?>">
</div>
<div>
<input readonly value="<?php echo $fetch['username'];?>">
</div>
<div>
<select name="estadoUser">
<?php if($fetch['estadoUser']==0){?>
<option value="0">Inativo</option>
<option value="1">Ativo</option>
<?php }?>
<?php if($fetch['estadoUser']==1){?>
<option value="1">Ativo</option>
<option value="0">Inativo</option>
<?php }?>
</select>
</div>
<div>
<select name="idPrivilegio">
<option value="<?php echo $fetch['idPrivilegio']?>">
<?php echo $fetch['privilegio']?>
</option>
<?php
require_once("privilegios.php");
do {?>
<?php if($fetch['idPrivilegio']!=$fetchPriv['id']){?>
<option value="<?php echo $fetchPriv['id'];?>">
<?php echo $fetchPriv['privilegio'];?>
</option>
<?php }?>
<?php } while($fetchPriv=mysqli_fetch_assoc($queryPriv));?>
</select>
</div>
<div>
<input type="submit" name="alterar" value="Alterar dados">
</div>
<input type="hidden" name="idUser" value="<?php echo $fetch['idUser'];?>">
<input type="hidden" name="idPessoa" value="<?php echo $fetch['idPessoa'];?>">
</form>
</div>
</body>
</html>
privilegios.php
<?php
require_once("restricao.php");
require_once("ligacao.php");
//
$sql="SELECT * FROM privilegios ORDER BY privilegio";
$queryPriv=mysqli_query($ligarECD, $sql);
$fetchPriv=mysqli_fetch_assoc($queryPriv);
?>
grausCriar.php
<?php
require_once("restricao.php");
if(isset($_GET['registar'])){
$grau=addslashes($_GET['grau']);
$obs=addslashes($_GET['obs']);
$sql="SELECT id FROM graus WHERE grau LIKE '$grau'";
require_once("ligacao.php");
$query=mysqli_query($ligarECD, $sql);
$total=mysqli_num_rows($query);
if($total==0){
$sql="INSERT INTO graus (grau, obs) VALUES( '$grau', '$obs')";
mysqli_query($ligarECD, $sql);
// regista
$caminho="grausListar.php?sucesso";
} elseif($total==1){
// não regista
$caminho="?fracasso";
}
header("Location:$caminho");
}
?>
<!DOCTYPE html>
<html lang="pt">
<head>
<meta charset="UTF-8">
<title>Criar GRAUS</title>
</head>
<body><!-- interface -->
<div>
<form>
<input type="text" name="grau" required placeholder="Grau:"><input type="text" name="obs" placeholder="Observações:"><input type="submit" name="registar">
</form>
</div>
</body>
</html>
Sem comentários:
Enviar um comentário