-
Notifications
You must be signed in to change notification settings - Fork 0
/
Exibir_visitas.php
107 lines (82 loc) · 3.17 KB
/
Exibir_visitas.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
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
<?php
include 'protect.php';
require 'conexão.php';
?>
<html lang="pt-br">
<head>
<title>Exibição de pacientes</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=yes">
<link rel="stylesheet" type="text/css" href="estilo.css">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css" integrity="sha384-MCw98/SFnGE8fJT3GXwEOngsV7Zt27NXFoaoApmYm81iuXoPkFOJwJ8ERdknLPMO" crossorigin="anonymous">
<link rel="stylesheet" type="text/css" href="estilo.css">
<style>p
* {box-sizing: border-box;}
body {font-family: Arial, Helvetica, sans-serif;}
.header,.main,.footer{max-width:1200px;margin:auto}
.header {background-color: #f1f1f1;padding: 30px;text-align: center;font-size: 35px;}
.footer {background-color: #f1f1f1;padding: 10px;text-align: center;}
table{width:100% }
table, th, td, caption{
border:1px solid #c0c0c0;
border-collapse:collapse;padding:5px
}
table caption{
background-color:#d9d9d9;
font-weight:bold
}
tbody tr:nth-child(odd) {
background-color: #f2f2f2;
}
td:nth-child(3),tfoot td:nth-child(2) {
text-align:right;
font-weight:bold
}
td:nth-child(3){
width:30%
}
@media (max-width: 600px) { table caption{display:none; }}
</style>
</head>
<body>
<nav>
<ul>
<li><a href="painel.php">Home</a></li>
<li><a href="inscrição.php">Cadastrar novos pacientes</a></li>
<li><a href="Remover.php">Remover pacientes</a></li>
<li><a href="exibição.php">Exibição dos pacientes</a></li>
<li><a href="Exibir_visitas.php">Exibição todas as visitas</a></li>
<li><a href="Reescrever.php">Atualizar pacientes já cadastrados</a></li>
<li><a href="Logout.php">Sair</a></li>
</nav><br><br><br>
<?php
$sql = "SELECT * FROM visitas";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
echo "<table>";
echo "<tr>";
echo "<th>Lugar de atentimento</th>";
echo "<th>Data</th>";
echo "<th>Informações sobre visita</th>";
echo "<th>Link para aba do paciente</th>";
echo "</tr>";
// output data of each row
while($row = $result->fetch_assoc()) {
echo "<tr>";
echo "<td>" . $row["lugar"]. "</td> ";
echo "<td>" . $row["horario"]. "</td>";
echo "<td>" . $row["informacoes"]. "</td>";
echo "<td><a href='pacientes.php?id=" .$row["paciente_id"]. "'>Link para paciente</a></td> ";
echo "</tr>";
}
echo "</table>";
} else {
echo "Não há resultados para exibir.";
}
$conn->close();
?>
<form action="submit_form_visitas.php" method="post">
<br><label> Clique no botão abaixo para fazer dowload da tabela de visitas</label><br>
<br><input type="submit" value="Clique aqui!!">
</body>
</html>