<?php
$page=$_SERVER['PHP_SELF'];
#usersPesquisar.php
if(isset($_GET['pesquisar'])){
require_once("restrict.php");
$table="v1_users";
$p=addslashes($_GET['p']);
$sql="SELECT * FROM $table WHERE username LIKE '%$p%' OR nome LIKE '%$p%' OR apelido LIKE '%$p%' OR privilegio LIKE '%$p%'";
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>
<div>
<form>
<input type="search" name="p" autofocus required>
<input type="submit" name="pesquisar" value="Pesquisar">
</form>
</div>
<?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&page=$page&p=$p'>Ativo</a>";}
else
{
echo "<a style='color:red' href='usersEstado.php?alterar&estado=1&idUser=$idUser&page=$page&p=$p'>Inativo</a>";}
?>
</td>
<td><a href="usersEditar.php?idUser=<?php echo $idUser;?>&page=$page">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 and isset($_GET['pesquisar'])){ ?>
<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