-
Notifications
You must be signed in to change notification settings - Fork 1
/
visualizar.php
executable file
·130 lines (110 loc) · 4.95 KB
/
visualizar.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
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
<?php
include "db_conn.php";
$id = $_GET['id'];
if (isset($_POST['submit'])) {
$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$email = $_POST['email'];
$address = $_POST['address'];
$ts = $_POST['ts'];
$sql = "SELECT `id`, `last_name` FROM `tbl_crud` WHERE id=$id";
$result = mysqli_query($conn, $sql);
if ($result) {
header("Location: data_table.php?msg=Registro atualizado com sucesso na base de dados!");
} else {
echo "Falhou! " . mysqli_error($conn);
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<!-- Required meta tags -->
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="CRUD com PHP">
<meta name="author" content="Lúcio Flávio Lemos">
<title>RESUMO</title>
<!-- CSS do Bootstrap -->
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/css/bootstrap.min.css" rel="stylesheet"
integrity="sha384-T3c6CoIi6uLrA9TneNEoa7RxnatzjcDSCmG1MXxSR1GAsXEV/Dwwykc2MPK8M2HN" crossorigin="anonymous">
<!-- Font-awesome -->
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.2.0/css/all.min.css"
integrity="sha512-xh6O/CkQoPOWDdYTDqeRdPCVd1SpvCA9XXcUnZS2FmJNp1coAFzvtCN9BmamE+4aHK8yyUHUSCcJHgXloTyT2A=="
crossorigin="anonymous" referrerpolicy="no-referrer" />
<!-- Folha de estilo própria -->
<link href="css/navbar.css" rel="stylesheet">
<link href="css/footer.css" rel="stylesheet">
<style>
.bd-placeholder-img {
font-size: 1.125rem;
text-anchor: middle;
-webkit-user-select: none;
-moz-user-select: none;
user-select: none;
}
@media (min-width: 768px) {
.bd-placeholder-img-lg {
font-size: 3.5rem;
}
}
</style>
</head>
<body>
<header>
<!-- Include do navbar da página -->
<?php include "shareds/navbar.php"; ?>
</header>
<main class="container">
<div class="text-center mb-4">
<h3>VISUALIZA (READ) DADOS DO CLIENTE</h3>
<p class="text-muted">Resumo de dados do cliente</p>
</div>
<div class="container d-flex justify-content-left">
<?php
$sql = "SELECT * FROM `tbl_crud` WHERE id = $id LIMIT 1";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($result);
echo "<br> - id: " . $row["id"] .
"<br>" . " - Name: " . $row["first_name"] .
"<br>" . " - Sobrenome: " . $row["last_name"] .
"<br>" . " - Email: " . $row["email"] ;
?>
</div>
<div class="container d-flex justify-content-left">
<form action="data_table.php" method="" style="width:50vw; min-width: 300px;" class="row g-3 needs-validation">
<div class="col-12">
<button type="submit" class="btn btn-success" name="submit"><i
class="fa-solid fa-print me-2"></i>Imprimir</button>
<a href="data_table.php" class="btn btn-danger"><i class="fa-solid fa-angles-left"></i></i>Voltar</a>
<!-- <button type="reset" class="btn btn-primary" name="submit"><i class="fa-solid fa-broom me-2"></i>Limpar</button> -->
</div>
</form>
</div>
</main>
<footer class="footer mt-auto py-3 fixed-bottom bg-body-tertiary">
<!-- Include do footer da página -->
<?php include "shareds/footer.php"; ?>
</footer>
<!--Scripts adicionais do próprio Bootstratp-->
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.min.js"
integrity="sha384-fbbOQedDUMZZ5KreZpsbe1LCZPVmfTnH7ois6mU1QK+m14rQ1l2bGBq41eYeM/fS" crossorigin="anonymous">
</script>
<script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.11.8/dist/umd/popper.min.js"
integrity="sha384-I7E8VVD/ismYTF4hNIPjVp/Zjvgyol6VFvRkX/vR+Vc4jQkC+hVqc2pM8ODewa9r" crossorigin="anonymous">
</script>
<!--Script padrão do Bootstrap JS-->
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"
integrity="sha384-geWF76RCwLtnZ8qwWowPQNguL3RmwHVBC9FhGdlKrxdiJJigb/j/68SIy3Te4Bkz" crossorigin="anonymous">
</script>
<!--Script do Jquery-->
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.7.1/jquery.min.js"
integrity="sha512-v2CJ7UaYy4JwqLDIrZUI/4hqeoQieOmAZNXBeQyjo21dadnwR+8ZaIJVT8EE2iyI61OV8e6M8PP2/4hpQINQ/g=="
crossorigin="anonymous" referrerpolicy="no-referrer"></script>
<!--Script do Jquery-mask-plugin-->
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery.mask/1.14.16/jquery.mask.min.js"
integrity="sha512-pHVGpX7F/27yZ0ISY+VVjyULApbDlD0/X0rgGbTqCE7WFW5MezNTWG/dnhtbBuICzsd0WQPgpE4REBLv+UqChw=="
crossorigin="anonymous" referrerpolicy="no-referrer"></script>
<script src="/js/mask.js"></script>
</body>
</html>