<?php
#usersListar.php
require_once("restrict.php");
$table="v1_users";
$sql="SELECT * FROM $table";
require_once("connection.php");
$query=mysqli_query($connect,$sql) or die("Erro na query SELECT * FROM $table");
$total=mysqli_num_rows($query);
if($total>0){
$fetch=mysqli_fetch_assoc($query);
}
?>
<!DOCTYPE html>
<html lang="pt">
<head>
<meta charset="UTF-8">
<title>Listagem de utilizadores</title>
</head>
<body>
<?php if($total>0){ ?>
<h1>Foram encontrados <?php echo $total;?> registos.</h1>
<table>
<tr>
<th>#</th>
<th>Username</th>
<th>Privilegio</th>
<th>Estado</th>
<th>Editar</th>
<th>Remover</th>
</tr>
<tr>
<td colspan="6">
<hr>
</td>
</tr>
<?php $i=0; do { $i++;?>
<tr>
<td>
<?php echo $i;?>
</td>
<td>
<?php echo $fetch['username'];?>
</td>
<td>
<?php echo $fetch['privilegio'];?>
</td>
<td>
<?php
$idUser=$fetch['idUser'];
if($fetch['estado']==1){
echo "<a style='color:Green' href='usersEstado.php?alterar&estado=0&idUser=$idUser'>Ativo</a>";}
else
{
echo "<a style='color:red' href='usersEstado.php?alterar&estado=1&idUser=$idUser'>Inativo</a>";}
?>
</td>
<td><a href="usersEditar.php?idUser=<?php echo $idUser;?>">Editar</a></td>
<td>
<?php if($idUser==$_SESSION['idUser']){?>
Remover<?php }?>
<?php if($idUser!=$_SESSION['idUser']){?>
<a href="" onclick="remover(<?php echo $idUser;?>)">Remover</a>
<?php } ?>
</td>
</tr>
<?php } while($fetch=mysqli_fetch_assoc($query));?>
</table>
<?php } ?>
<?php if($total==0){ ?>
<p>Não foram encontrados registos</p>
<?php } ?>
<script>
function remover(i) {
if (confirm("Apagar o registo ?!?!")) {window.open("usersRemover.php?remover&idUser="+i); }
}
</script>
</body>
</html>
<?php
mysqli_close($connect);
mysqli_free_result($query);
?>
Sem comentários:
Enviar um comentário