Sistemas e Códigos Gratuitos
A RZSISTEMAS compartilha códigos e ferramentas criadas por nossa equipe. Sinta-se à vontade para usar, testar e adaptar em seus projetos!
SAVEGNAGO SUPERMERCADOS LTA - CENTRO ADMINISTRATIVO APARECIDO SAVEGNAGO
GRÁTISCODIGO DE TESTE
Ver Código e Instruções de Uso
<?php
session_start();
include('../includes/db.php');
// Verificação de Segurança
if(!isset($_SESSION['logado'])){
header('Location: login.php');
exit;
}
// --- LÓGICA DE DELETAR E ALTERAR VISIBILIDADE ---
if(isset($_GET['action']) && isset($_GET['id']) && isset($_GET['table'])) {
$id = (int)$_GET['id'];
$table = $conn->real_escape_string($_GET['table']);
if($_GET['action'] == 'delete'){
$conn->query("DELETE FROM $table WHERE id = $id");
header("Location: index.php?page=$table&msg=Item deletado!");
exit;
}
if($_GET['action'] == 'toggle'){
$conn->query("UPDATE $table SET visivel = NOT visivel WHERE id = $id");
header("Location: index.php?page=$table&msg=Status alterado!");
exit;
}
}
// --- PROCESSAMENTO DOS FORMULÁRIOS ---
// 1. Salvar Destaque
if(isset($_POST['save_destaque'])){
$titulo = $conn->real_escape_string($_POST['titulo']);
$desc = $conn->real_escape_string($_POST['descricao']);
$status = $conn->real_escape_string($_POST['status']);
$techs = $conn->real_escape_string($_POST['techs']);
$img = $conn->real_escape_string($_POST['imagem']);
$conn->query("UPDATE destaque SET titulo='$titulo', descricao='$desc', status='$status', techs='$techs', imagem='$img' WHERE id=1");
$msg = "Destaque atualizado!";
}
// 2. Salvar Portfólio (COMPLETO)
if(isset($_POST['save_portfolio'])){
$titulo = $conn->real_escape_string($_POST['titulo']);
$cliente = $conn->real_escape_string($_POST['cliente']);
$imagem = $conn->real_escape_string($_POST['imagem']);
$link = $conn->real_escape_string($_POST['link']);
$print1 = $conn->real_escape_string($_POST['print1']);
$print2 = $conn->real_escape_string($_POST['print2']);
$sobre = $conn->real_escape_string($_POST['sobre_projeto']);
if(!empty($_POST['id_editar'])) {
$id = (int)$_POST['id_editar'];
$conn->query("UPDATE portfolio SET titulo='$titulo', cliente='$cliente', imagem='$imagem', link='$link', print1='$print1', print2='$print2', sobre_projeto='$sobre' WHERE id=$id");
$msg = "Projeto editado!";
} else {
$conn->query("INSERT INTO portfolio (titulo, cliente, imagem, link, print1, print2, sobre_projeto) VALUES ('$titulo', '$cliente', '$imagem', '$link', '$print1', '$print2', '$sobre')");
$msg = "Projeto adicionado!";
}
}
// 3. Salvar Update
if(isset($_POST['save_update'])){
$texto = $conn->real_escape_string($_POST['texto']);
$data = $_POST['data_post'];
if(!empty($_POST['id_editar'])) {
$id = (int)$_POST['id_editar'];
$conn->query("UPDATE updates SET texto='$texto', data_post='$data' WHERE id=$id");
$msg = "Update editado!";
} else {
$conn->query("INSERT INTO updates (texto, data_post) VALUES ('$texto', '$data')");
$msg = "Update publicado!";
}
}
// 4. Salvar Monitoramento
if(isset($_POST['save_monitor'])){
$site = $conn->real_escape_string($_POST['nome_site']);
$opcao = $_POST['status_opt'];
$parts = explode('|', $opcao);
$css_class = $parts[0];
$label_text = $parts[1];
if(!empty($_POST['id_editar'])) {
$id = (int)$_POST['id_editar'];
$conn->query("UPDATE monitoramento SET nome_site='$site', tipo_status='$css_class', texto_status='$label_text' WHERE id=$id");
$msg = "Monitoramento atualizado!";
} else {
$conn->query("INSERT INTO monitoramento (nome_site, tipo_status, texto_status) VALUES ('$site', '$css_class', '$label_text')");
$msg = "Site adicionado ao monitoramento!";
}
}
// 5. SALVAR SISTEMAS À VENDA
if(isset($_POST['save_sistema'])){
$nome = $conn->real_escape_string($_POST['nome']);
$desc = $conn->real_escape_string($_POST['descricao']);
$detalhes = $conn->real_escape_string($_POST['detalhes_dev']);
$preco = (float)$_POST['preco'];
$imagem = $conn->real_escape_string($_POST['imagem']);
if(!empty($_POST['id_editar'])) {
$id = (int)$_POST['id_editar'];
$conn->query("UPDATE sistemas_venda SET nome='$nome', descricao='$desc', detalhes_dev='$detalhes', preco=$preco, imagem='$imagem' WHERE id=$id");
$msg = "Sistema atualizado!";
} else {
$conn->query("INSERT INTO sistemas_venda (nome, descricao, detalhes_dev, preco, imagem) VALUES ('$nome', '$desc', '$detalhes', $preco, '$imagem')");
$msg = "Novo sistema cadastrado para venda!";
}
}
// 6. SALVAR SISTEMAS GRÁTIS
if(isset($_POST['save_gratis'])){
$nome = $conn->real_escape_string($_POST['nome']);
$desc = $conn->real_escape_string($_POST['descricao']);
$instrucoes = $conn->real_escape_string($_POST['uso_instrucoes']);
if(!empty($_POST['id_editar'])) {
$id = (int)$_POST['id_editar'];
$conn->query("UPDATE sistemas_gratis SET nome='$nome', descricao='$desc', uso_instrucoes='$instrucoes' WHERE id=$id");
$msg = "Sistema Grátis atualizado!";
} else {
$conn->query("INSERT INTO sistemas_gratis (nome, descricao, uso_instrucoes) VALUES ('$nome', '$desc', '$instrucoes')");
$msg = "Novo código grátis publicado!";
}
}
$page = isset($_GET['page']) ? $_GET['page'] : 'destaque';
?>
<!DOCTYPE html>
<html lang="pt-br">
<head>
<meta charset="UTF-8">
<title>Painel RZ Admin</title>
<link href="https://fonts.googleapis.com/css2?family=Ubuntu:wght@300;400;700&display=swap" rel="stylesheet">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
<style>
:root { --primary: #00d2d3; --dark: #222f3e; --bg: #f1f2f6; }
body { margin: 0; font-family: 'Ubuntu', sans-serif; background: var(--bg); display: flex; min-height: 100vh; }
.sidebar { width: 240px; background: var(--dark); color: white; display: flex; flex-direction: column; position: fixed; height: 100%; }
.brand { padding: 20px; font-size: 24px; font-weight: bold; border-bottom: 1px solid rgba(255,255,255,0.1); color: var(--primary); }
.menu a { display: block; padding: 15px 20px; color: #ccc; text-decoration: none; border-left: 4px solid transparent; transition: 0.3s; }
.menu a:hover, .menu a.active { background: rgba(255,255,255,0.05); color: white; border-left-color: var(--primary); }
.menu i { margin-right: 10px; width: 20px; text-align: center; }
.content { margin-left: 240px; padding: 30px; width: 100%; }
.header-page { display: flex; justify-content: space-between; align-items: center; margin-bottom: 30px; }
.card { background: white; padding: 25px; border-radius: 8px; box-shadow: 0 2px 10px rgba(0,0,0,0.05); margin-bottom: 20px; }
label { display: block; font-weight: bold; margin-bottom: 5px; font-size: 12px; color: #555; text-transform: uppercase; }
input, textarea, select { width: 100%; padding: 10px; border: 1px solid #ddd; border-radius: 4px; margin-bottom: 15px; box-sizing: border-box;}
.btn { padding: 10px 20px; border: none; border-radius: 4px; cursor: pointer; font-weight: bold; text-decoration: none; display: inline-block;}
.btn-save { background: var(--primary); color: #000; }
table { width: 100%; border-collapse: collapse; margin-top: 10px; }
th, td { padding: 12px; text-align: left; border-bottom: 1px solid #eee; font-size: 14px; }
th { background: #f8f9fa; color: #555; }
.thumb-mini { width: 40px; height: 40px; border-radius: 4px; object-fit: cover; background: #eee; }
.actions a { margin-right: 5px; color: #777; font-size: 14px; }
.badge { padding: 3px 8px; border-radius: 10px; font-size: 10px; font-weight: bold; }
.visible { background: #dff9fb; color: #130f40; }
.hidden { background: #ffdd59; color: #333; opacity: 0.6; }
.msg-box { padding: 15px; background: #badc58; color: #130f40; border-radius: 5px; margin-bottom: 20px; }
.st-ok { color: #2ecc71; font-weight: bold; }
.st-warn { color: #f1c40f; font-weight: bold; }
.st-err { color: #e74c3c; font-weight: bold; }
</style>
</head>
<body>
<div class="sidebar">
<div class="brand"><i class="fa-solid fa-layer-group"></i> RZ Admin</div>
<nav class="menu">
<a href="?page=destaque" class="<?php echo ($page=='destaque')?'active':''; ?>"><i class="fa-solid fa-star"></i> Destaque</a>
<a href="?page=portfolio" class="<?php echo ($page=='portfolio')?'active':''; ?>"><i class="fa-solid fa-briefcase"></i> Portfólio</a>
<a href="?page=monitor" class="<?php echo ($page=='monitor')?'active':''; ?>"><i class="fa-solid fa-server"></i> Monitoramento</a>
<a href="?page=sistemas" class="<?php echo ($page=='sistemas')?'active':''; ?>"><i class="fa-solid fa-cart-shopping"></i> Sistemas Venda</a>
<a href="?page=gratis" class="<?php echo ($page=='gratis')?'active':''; ?>"><i class="fa-solid fa-code"></i> Sistemas Grátis</a>
<a href="?page=updates" class="<?php echo ($page=='updates')?'active':''; ?>"><i class="fa-solid fa-bullhorn"></i> Atualizações</a>
<a href="../index.php" target="_blank"><i class="fa-solid fa-arrow-up-right-from-square"></i> Ver Site</a>
<a href="logout.php" style="color: #ff6b6b;"><i class="fa-solid fa-power-off"></i> Sair</a>
</nav>
</div>
<div class="content">
<?php if(isset($msg) || isset($_GET['msg'])) { ?>
<div class="msg-box"><i class="fa-solid fa-check-circle"></i> <?php echo isset($msg) ? $msg : $_GET['msg']; ?></div>
<?php } ?>
<?php if($page == 'destaque') {
$data = $conn->query("SELECT * FROM destaque WHERE id=1")->fetch_assoc(); ?>
<div class="header-page"><h2>Gerenciar Destaque</h2></div>
<div class="card">
<form method="post">
<label>Título</label><input type="text" name="titulo" value="<?php echo $data['titulo']; ?>" required>
<label>Descrição</label><textarea name="descricao" rows="3"><?php echo $data['descricao']; ?></textarea>
<div style="display:flex; gap:20px;">
<div style="flex:1"><label>Status</label><input type="text" name="status" value="<?php echo $data['status']; ?>"></div>
<div style="flex:1"><label>Tecnologias</label><input type="text" name="techs" value="<?php echo $data['techs']; ?>"></div>
</div>
<label>Imagem URL (Capa)</label><input type="text" name="imagem" value="<?php echo $data['imagem']; ?>">
<button type="submit" name="save_destaque" class="btn btn-save">Salvar</button>
</form>
</div>
<?php } ?>
<?php if($page == 'portfolio') {
$edit_data = null;
if(isset($_GET['edit'])) {
$id = (int)$_GET['edit'];
$edit_data = $conn->query("SELECT * FROM portfolio WHERE id=$id")->fetch_assoc();
} ?>
<div class="header-page"><h2>Gerenciar Portfólio</h2></div>
<div class="card">
<h3><?php echo $edit_data ? '✏️ Editar' : '➕ Novo'; ?></h3>
<form method="post">
<input type="hidden" name="id_editar" value="<?php echo $edit_data['id'] ?? ''; ?>">
<div style="display:flex; gap:20px;">
<div style="flex:1"><label>Projeto</label><input type="text" name="titulo" value="<?php echo $edit_data['titulo'] ?? ''; ?>" required></div>
<div style="flex:1"><label>Cliente</label><input type="text" name="cliente" value="<?php echo $edit_data['cliente'] ?? ''; ?>" required></div>
</div>
<label>Sobre o Projeto (Texto Detalhado)</label>
<textarea name="sobre_projeto" rows="5" placeholder="Escreva os detalhes técnicos aqui..."><?php echo $edit_data['sobre_projeto'] ?? ''; ?></textarea>
<label>Link do Site</label><input type="text" name="link" value="<?php echo $edit_data['link'] ?? ''; ?>" placeholder="http://...">
<label>URL da Imagem de Capa</label><input type="text" name="imagem" value="<?php echo $edit_data['imagem'] ?? ''; ?>" required>
<div style="background:#f9f9f9; padding:15px; border-radius:6px; margin-bottom:15px; border:1px solid #eee;">
<h4 style="margin:0 0 10px 0; color:#00d2d3;">Galeria (Opcional)</h4>
<div style="display:flex; gap:20px;">
<div style="flex:1"><label>URL Print 1</label><input type="text" name="print1" value="<?php echo $edit_data['print1'] ?? ''; ?>"></div>
<div style="flex:1"><label>URL Print 2</label><input type="text" name="print2" value="<?php echo $edit_data['print2'] ?? ''; ?>"></div>
</div>
</div>
<button type="submit" name="save_portfolio" class="btn btn-save">Salvar</button>
</form>
</div>
<div class="card">
<table>
<thead><tr><th>Img</th><th>Nome</th><th>Ações</th></tr></thead>
<tbody>
<?php $list = $conn->query("SELECT * FROM portfolio ORDER BY id DESC");
while($row = $list->fetch_assoc()){ $v = $row['visivel']; ?>
<tr style="opacity: <?php echo $v?'1':'0.5'; ?>">
<td><img src="<?php echo $row['imagem']; ?>" class="thumb-mini"></td>
<td><?php echo $row['titulo']; ?></td>
<td class="actions">
<a href="?page=portfolio&edit=<?php echo $row['id']; ?>"><i class="fa-solid fa-pen"></i></a>
<a href="?page=portfolio&action=toggle&table=portfolio&id=<?php echo $row['id']; ?>"><i class="fa-solid <?php echo $v?'fa-eye':'fa-eye-slash'; ?>"></i></a>
<a href="?page=portfolio&action=delete&table=portfolio&id=<?php echo $row['id']; ?>" onclick="return confirm('Apagar?')" style="color:red;"><i class="fa-solid fa-trash"></i></a>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
<?php } ?>
<?php if($page == 'monitor') {
$edit_mon = null;
if(isset($_GET['edit'])) {
$id = (int)$_GET['edit'];
$edit_mon = $conn->query("SELECT * FROM monitoramento WHERE id=$id")->fetch_assoc();
}
$current_val = ($edit_mon) ? $edit_mon['tipo_status'].'|'.$edit_mon['texto_status'] : '';
?>
<div class="header-page"><h2>Gerenciar Monitoramento</h2></div>
<div class="card">
<h3><?php echo $edit_mon ? '✏️ Editar Site' : '➕ Adicionar Site'; ?></h3>
<form method="post">
<input type="hidden" name="id_editar" value="<?php echo $edit_mon['id'] ?? ''; ?>">
<div style="display:flex; gap:20px;">
<div style="flex:1"><label>Nome do Fã-Site</label><input type="text" name="nome_site" value="<?php echo $edit_mon['nome_site'] ?? ''; ?>" required></div>
<div style="flex:1">
<label>Status Atual</label>
<select name="status_opt" required>
<option value="status-ok|ONLINE" <?php echo ($current_val == 'status-ok|ONLINE')?'selected':''; ?>>🟢 Online</option>
<option value="status-warn|LENTO" <?php echo ($current_val == 'status-warn|LENTO')?'selected':''; ?>>🟡 Lento</option>
<option value="status-err|OFF" <?php echo ($current_val == 'status-err|OFF')?'selected':''; ?>>🔴 Offline</option>
<option value="status-warn|MANUT" <?php echo ($current_val == 'status-warn|MANUT')?'selected':''; ?>>🟠 Manutenção</option>
</select>
</div>
</div>
<button type="submit" name="save_monitor" class="btn btn-save">Salvar Status</button>
</form>
</div>
<div class="card">
<table>
<thead><tr><th>Site</th><th>Status</th><th>Ações</th></tr></thead>
<tbody>
<?php $list_mon = $conn->query("SELECT * FROM monitoramento ORDER BY id DESC");
while($row = $list_mon->fetch_assoc()){ $v = $row['visivel'];
$cor = ($row['tipo_status'] == 'status-ok') ? 'st-ok' : (($row['tipo_status'] == 'status-err') ? 'st-err' : 'st-warn');
?>
<tr style="opacity: <?php echo $v?'1':'0.5'; ?>">
<td><b><?php echo $row['nome_site']; ?></b></td>
<td class="<?php echo $cor; ?>"><?php echo $row['texto_status']; ?></td>
<td class="actions">
<a href="?page=monitor&edit=<?php echo $row['id']; ?>"><i class="fa-solid fa-pen"></i></a>
<a href="?page=monitor&action=toggle&table=monitoramento&id=<?php echo $row['id']; ?>"><i class="fa-solid <?php echo $v?'fa-eye':'fa-eye-slash'; ?>"></i></a>
<a href="?page=monitor&action=delete&table=monitoramento&id=<?php echo $row['id']; ?>" onclick="return confirm('Apagar?')" style="color:red;"><i class="fa-solid fa-trash"></i></a>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
<?php } ?>
<?php if($page == 'sistemas') {
$edit_sis = null;
if(isset($_GET['edit'])) {
$id = (int)$_GET['edit'];
$edit_sis = $conn->query("SELECT * FROM sistemas_venda WHERE id=$id")->fetch_assoc();
} ?>
<div class="header-page"><h2>Gerenciar Sistemas à Venda</h2></div>
<div class="card">
<h3><?php echo $edit_sis ? '✏️ Editar Sistema' : '➕ Novo Sistema'; ?></h3>
<form method="post">
<input type="hidden" name="id_editar" value="<?php echo $edit_sis['id'] ?? ''; ?>">
<div style="display:flex; gap:20px;">
<div style="flex:1"><label>Nome</label><input type="text" name="nome" value="<?php echo $edit_sis['nome'] ?? ''; ?>" required></div>
<div style="width:150px"><label>Preço (Ex: 150.00)</label><input type="number" step="0.01" name="preco" value="<?php echo $edit_sis['preco'] ?? ''; ?>" required></div>
</div>
<label>Descrição Curta</label><textarea name="descricao" rows="2"><?php echo $edit_sis['descricao'] ?? ''; ?></textarea>
<label>Detalhes do Desenvolvimento</label><textarea name="detalhes_dev" rows="4"><?php echo $edit_sis['detalhes_dev'] ?? ''; ?></textarea>
<label>URL da Imagem</label><input type="text" name="imagem" value="<?php echo $edit_sis['imagem'] ?? ''; ?>">
<button type="submit" name="save_sistema" class="btn btn-save">Salvar Sistema</button>
<?php if($edit_sis) echo '<a href="?page=sistemas" class="btn" style="background:#ddd; color:#333; margin-left:10px;">Cancelar</a>'; ?>
</form>
</div>
<div class="card">
<table>
<thead><tr><th>ID</th><th>Nome</th><th>Preço</th><th>Ações</th></tr></thead>
<tbody>
<?php $list_sis = $conn->query("SELECT * FROM sistemas_venda ORDER BY id DESC");
while($row = $list_sis->fetch_assoc()){ $v = $row['visivel']; ?>
<tr style="opacity: <?php echo $v?'1':'0.5'; ?>">
<td><?php echo $row['id']; ?></td>
<td><?php echo $row['nome']; ?></td>
<td>R$ <?php echo number_format($row['preco'], 2, ',', '.'); ?></td>
<td class="actions">
<a href="?page=sistemas&edit=<?php echo $row['id']; ?>"><i class="fa-solid fa-pen"></i></a>
<a href="?page=sistemas&action=toggle&table=sistemas_venda&id=<?php echo $row['id']; ?>"><i class="fa-solid <?php echo $v?'fa-eye':'fa-eye-slash'; ?>"></i></a>
<a href="?page=sistemas&action=delete&table=sistemas_venda&id=<?php echo $row['id']; ?>" onclick="return confirm('Apagar?')" style="color:red;"><i class="fa-solid fa-trash"></i></a>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
<?php } ?>
<?php if($page == 'gratis') {
$edit_up = null;
if(isset($_GET['edit'])) {
$id = (int)$_GET['edit'];
$edit_up = $conn->query("SELECT * FROM sistemas_gratis WHERE id=$id")->fetch_assoc();
} ?>
<div class="header-page"><h2>Gerenciar Sistemas Grátis</h2></div>
<div class="card">
<h3><?php echo $edit_up ? '✏️ Editar Código' : '➕ Novo Código Grátis'; ?></h3>
<form method="post">
<input type="hidden" name="id_editar" value="<?php echo $edit_up['id'] ?? ''; ?>">
<label>Nome do Sistema/Código</label><input type="text" name="nome" value="<?php echo $edit_up['nome'] ?? ''; ?>" required>
<label>Descrição Curta</label><textarea name="descricao" rows="2" placeholder="O que este código faz e como usar."><?php echo $edit_up['descricao'] ?? ''; ?></textarea>
<label>Código Fonte / Instruções de Uso</label>
<textarea name="uso_instrucoes" rows="10" placeholder="Cole o código fonte ou as instruções detalhadas aqui."><?php echo $edit_up['uso_instrucoes'] ?? ''; ?></textarea>
<button type="submit" name="save_gratis" class="btn btn-save">Salvar Código</button>
<?php if($edit_up) echo '<a href="?page=gratis" class="btn" style="background:#ddd; color:#333; margin-left:10px;">Cancelar</a>'; ?>
</form>
</div>
<div class="card">
<table>
<thead><tr><th>ID</th><th>Nome</th><th>Ações</th></tr></thead>
<tbody>
<?php $list_up = $conn->query("SELECT * FROM sistemas_gratis ORDER BY id DESC");
while($row = $list_up->fetch_assoc()){ $v = $row['visivel']; ?>
<tr style="opacity: <?php echo $v?'1':'0.5'; ?>">
<td><?php echo $row['id']; ?></td>
<td><?php echo $row['nome']; ?></td>
<td class="actions">
<a href="?page=gratis&edit=<?php echo $row['id']; ?>"><i class="fa-solid fa-pen"></i></a>
<a href="?page=gratis&action=toggle&table=sistemas_gratis&id=<?php echo $row['id']; ?>"><i class="fa-solid <?php echo $v?'fa-eye':'fa-eye-slash'; ?>"></i></a>
<a href="?page=gratis&action=delete&table=sistemas_gratis&id=<?php echo $row['id']; ?>" onclick="return confirm('Apagar?')" style="color:red;"><i class="fa-solid fa-trash"></i></a>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
<?php } ?>
<?php if($page == 'updates') {
$edit_up = null;
if(isset($_GET['edit'])) {
$id = (int)$_GET['edit'];
$edit_up = $conn->query("SELECT * FROM updates WHERE id=$id")->fetch_assoc();
} ?>
<div class="header-page"><h2>Gerenciar News</h2></div>
<div class="card">
<h3><?php echo $edit_up ? '✏️ Editar' : '➕ Novo'; ?></h3>
<form method="post">
<input type="hidden" name="id_editar" value="<?php echo $edit_up['id'] ?? ''; ?>">
<div style="display:flex; gap:20px;">
<div style="width:150px"><label>Data</label><input type="text" name="data_post" value="<?php echo $edit_up['data_post'] ?? 'Hoje'; ?>" required></div>
<div style="flex:1"><label>Texto</label><input type="text" name="texto" value="<?php echo $edit_up['texto'] ?? ''; ?>" required></div>
</div>
<button type="submit" name="save_update" class="btn btn-save">Publicar</button>
</form>
</div>
<div class="card">
<table>
<thead><tr><th>Data</th><th>Texto</th><th>Ações</th></tr></thead>
<tbody>
<?php $list_up = $conn->query("SELECT * FROM updates ORDER BY id DESC");
while($row = $list_up->fetch_assoc()){ $v = $row['visivel']; ?>
<tr style="opacity: <?php echo $v?'1':'0.5'; ?>">
<td><?php echo $row['data_post']; ?></td>
<td><?php echo $row['texto']; ?></td>
<td class="actions">
<a href="?page=updates&edit=<?php echo $row['id']; ?>"><i class="fa-solid fa-pen"></i></a>
<a href="?page=updates&action=toggle&table=updates&id=<?php echo $row['id']; ?>"><i class="fa-solid <?php echo $v?'fa-eye':'fa-eye-slash'; ?>"></i></a>
<a href="?page=updates&action=delete&table=updates&id=<?php echo $row['id']; ?>" onclick="return confirm('Apagar?')" style="color:red;"><i class="fa-solid fa-trash"></i></a>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
<?php } ?>
</div>
</body>
</html>