-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathsituacao.php
82 lines (74 loc) · 3.64 KB
/
situacao.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
<?php
session_start();
include_once "conexao.php";
?>
<!DOCTYPE html>
<html lang="pt-br">
<head>
<meta charset="UTF-8" />
<title>Situação</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="shortcut icon" href="images/favicon.ico" />
<link rel="stylesheet" type="text/css" href="./css/style.css">
<link rel="stylesheet" type="text/css" href="./css/bootstrap.min.css">
<!-- Incluir os icones do font-awesome da CDN -->
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.1.1/css/all.min.css">
</head>
<body class="container-fluid">
<?php include "nav.php" ?>
<div class="container text-center">
<div class="row justify-content-md-center">
<!--conteudoEsquerda
<div class="col col-lg-2">
1 of 3
</div>-->
<!--conteudoCentral-->
<div class="col-md-auto">
<h2 class="text-titulo mt-3 mb-3">Situações<a class="nav-link" href="cadsit.php"><i class="fa-solid fa-charging-station"></i></a></h2>
<table class='table table-dark table-striped"'>
<thead class='list-head'>
<tr>
<th class='list-head-content'>ID</th>
<th class='list-head-content'>Nome</th>
<th class='list-head-content'>Ordem</th>
<th class='list-head-content'>Data</th>
<th class='list-head-content table-lg-none'>Açôes</th>
</tr>
</thead>
<?php
if(isset($_SESSION['msg'])){
echo $_SESSION['msg'];
unset($_SESSION['msg']);
}
$query_tarefas = "SELECT id, nome, ordem, created FROM sists_tarefas ORDER BY nome ASC LIMIT 40";
$result_tarefas = $conn->prepare($query_tarefas);
$result_tarefas->execute();
while($row_tarefa = $result_tarefas->fetch(PDO::FETCH_ASSOC)){
//var_dump($row_tarefa);
extract($row_tarefa);
echo "<tbody class='list-tarefa'>";
echo "<tr>";
echo "<td name='id_usuario' style='text-align: center'>$id</td>";
echo "<td Nome do usuário: >$nome </td>";
echo "<td E-mail do usuário: >$ordem </td>";
echo "<td class='table-sm-none'>". date('d/m/Y', strtotime($created)) . "</td>";
echo "<td class='list-body-content'>";
echo "<a href='editsit.php?id_usuario=$id'><button type='button' class='btn-warning'><i class='fa-solid fa-pen-to-square'></i></button></a>";
echo "<a href='apagarsit.php?id_usuario=$id'><button type='button' class='btn-danger'><i class='fa-solid fa-trash-can'></i></button></a>";
//echo "<a href='pesquisa-completa.php?id_usuario=$id_tar'><button type='button' class='btn-danger'><i class='fa-solid fa-magnifying-glass'></i></button></a>";
echo "</td>";
echo "</tr>";
echo "</tbody>";
}
?>
</table>
</div>
<!--conteudoEsquerda
<div class="col col-lg-2">
3 of 3
</div>-->
</div>
</div>
<script type="text/javascript" src="js/bootstrap.bundle.min.js"></script>
</body>
</html>