Filtrar dados BD Mysql
Ola, tenho uma tabela onde mostro os dados da pessoa logado por session.
Funciona perfeitamente, agora como faço para filtrar apenas os registros que estiverem cadastrados, os que não tiverem os campos não aparecerem?
O Resultado 2 e Resultado 3, etc só poderá aparecer assim que forem cadastrados pelo adm do sistema.
Segue o código da página:
<?php
session_start();
include_once("seguranca.php");
seguranca_adm();
?><!doctype html>
<html lang="pt-br">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name="description" content="">
<meta name="author" content="">
<link rel="icon" href="adminweb/imagens/favicon.ico">
<title>Zona Treinamento | Sistemas Web</title>
<!-- Principal CSS do Bootstrap -->
<link href="css/bootstrap.min.css" rel="stylesheet">
<!-- Our Custom CSS -->
<link rel="stylesheet" href="css/style-sidebar.css">
<!-- Estilos customizados para esse template -->
<link href="css/offcanvas.css" rel="stylesheet">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js"></script>
<script defer src="https://use.fontawesome.com/releases/v5.0.13/js/solid.js"></script>
<script defer src="https://use.fontawesome.com/releases/v5.0.13/js/fontawesome.js"></script>
</head>
<body>
<?php require_once 'menu_sidebar_sup.php'; ?>
<div class="container">
<button type="button" class="btn btn-success btn-lg btn-block"><?php echo $_SESSION['usuarioNome']; ?></button>
</div>
<div class="container theme-showcase" role="main">
<table class="table table-bordered table-hover table-striped table-sm">
<thead class="table-primary">
<tr>
<th scope="col">DADOS</th>
<th scope="col">RESULTADO 1</th>
<th scope="col">RESULTADO 2</th>
<th scope="col">RESULTADO 3</th>
</tr>
</thead>
<tbody>
<tr>
<th scope="row">IDADE</th>
<td><?php echo $_SESSION['usuarioIdade']; ?></td>
<td><?php echo $_SESSION['usuarioIdade2']; ?></td> <!--aqui seria o espaço para o resultado 2,3,4 etc-->
</tr>
<tr>
<th scope="row">ESCOLA</th>
<td><?php echo $_SESSION['usuarioEscola']; ?></td>
</tr>
<tr>
<th scope="row">SÉRIE</th>
<td><?php echo $_SESSION['usuarioSerie']; ?></td>
</tr>
<tr>
<th scope="row">PESO</th>
<td><?php echo $_SESSION['usuarioPeso']; ?></td>
</tr>
<tr>
<th scope="row">ALTURA</th>
<td><?php echo $_SESSION['usuarioAltura']; ?></td>
</tr>
<tr>
<th scope="row">IMC</th>
<td><?php echo $_SESSION['usuarioImc']; ?></td>
</tr>
<tr>
<th scope="row">RCQ</th>
<td><?php echo $_SESSION['usuarioRcq']; ?></td>
</tr>
<tr>
<th scope="row">FC Máxima</th>
<td><?php echo $_SESSION['usuarioFcmaxima']; ?></td>
</tr>
<tr>
<th scope="row">FC Repouso</th>
<td><?php echo $_SESSION['usuarioFcrepouso']; ?></td>
</tr>
<tr>
<th scope="row">FC Exercício</th>
<td><?php echo $_SESSION['usuarioFcexerc']; ?></td>
</tr>
<tr>
<th scope="row">FC Descanso</th>
<td><?php echo $_SESSION['usuarioFcexercdesc']; ?></td>
</tr>
<tr>
<th scope="row">Metragem Quadra</th>
<td><?php echo $_SESSION['usuarioMquadra']; ?></td>
</tr>
<tr>
<th scope="row">Teste Cooper</th>
<td><?php echo $_SESSION['usuarioCooper']; ?></td>
</tr>
<tr>
<th scope="row">Metros Percorridos</th>
<td><?php echo $_SESSION['usuarioMetros_perc']; ?></td>
</tr>
<tr>
<th scope="row">Impulsão Horizontal</th>
<td><?php echo $_SESSION['usuarioImphoriz']; ?></td>
</tr>
<tr>
<th scope="row">Impulsão Vertical</th>
<td><?php echo $_SESSION['usuarioImpvert']; ?></td>
</tr>
</tbody>
</table>
</div><!-- Inicio fechamento Menu Sidebar-->
</div>
</div><!--Fim fechamento Menu Sidebar-->
<script>function getElement(el) {
return document.getElementById(el);
}
function validToCalc(fieldWeight, fieldHeight) {
return fieldWeight.value && fieldHeight.value;
}
function calcImc(fieldWeight, fieldHeight) {console.log(fieldWeight, fieldHeight)
const parsedWeigth = parseFloat(fieldWeight.replace(',', '.'));
const parsedHeight = parseFloat(fieldHeight.replace(',', '.'));
const calculatedImc = parsedWeigth/(parsedHeight * parsedHeight);
return Math.round(calculatedImc.toFixed(2));
}
function initCalc(fieldWeight, fieldHeight) {
const imcResult = calcImc(fieldWeight.value, fieldHeight.value);
setImc(imcResult);
}
function setImc(imcResult) {
getElement('imc').value = imcResult;
}
window.onload = function() {
const fieldWeight = getElement('peso');
const fieldHeight = getElement('altura');
fieldWeight.addEventListener('keyup', function() {
if(validToCalc(fieldWeight, fieldHeight)) {
initCalc(fieldWeight, fieldHeight);
}
});
fieldHeight.addEventListener('keyup', function(){
if(validToCalc(fieldWeight, fieldHeight)) {
initCalc(fieldWeight, fieldHeight);
}
});
}</script>
<!-- Principal JavaScript do Bootstrap
================================================== -->
<!-- Foi colocado no final para a página carregar mais rápido -->
<!-- Popper.JS -->
<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js"></script>
<script>window.jQuery || document.write('<script src="assets/js/vendor/jquery-slim.min.js"><\/script>')</script>
<script src="js/popper.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/holder.min.js"></script>
<script src="js/offcanvas.js"></script>
<?php require_once '../footer.php'; ?>
</body>
</html>Discussão (0)
Carregando comentários...