listar.php

<div style="padding:10px; margin: 10px;border-radius: 20px; background-color: rgba(0, 0, 0, .15);backdrop-filter: blur(7px);color: #fff">
<h1>Listar Usuário</h1>
<?php
	$sql = "SELECT * FROM user";
	$res = $conn->query($sql);
	$qtd = $res->num_rows;

	if($qtd > 0){
		print "<p>Encontrou <b>$qtd</b> resultado(s)</p>";
		print "<table style='color: #fff'class='table table-bordered'>";
		print "<tr>";
		print "<th>#</th>";
		print "<th>Nome</th>";
		print "<th>E-mail</th>";
		print "<th>Tipo</th>";
		print "<th>Status</th>";
		print "<th>Ações</th>";
		print "</tr>";		
		while($row = $res->fetch_object()){
			if($row->tipo=='1'){
				$tipo = 'Administrador';
			}else{
				$tipo = 'Usuário Comum';
			}
			if($row->status=='1'){
				$status = 'Ativo';
			}else{
				$status = 'Inativo';
			}
			print "<tr>";
			print "<td>".$row->id."</td>";
			print "<td>".$row->nome."</td>";
			print "<td>".$row->email."</td>";
			print "<td>".$tipo."</td>";
			print "<td>".$status."</td>";
			print "<td>
						<button onclick=\"location.href='?page=editar&id=".$row->id."';\" class='btn btn-dark'>Editar</button>

						<button onclick=\"if(confirm('Tem certeza que deseja excluir?')){location.href='?page=salvar&acao=excluir&id=".$row->id."';}else{false;}\" class='btn btn-danger'>Excluir</button>
				   </td>";
			print "</tr>";
		}
		print "</table>";
	}else{
		print "Não encontrou resultados";
	}