<?php
require_once("ligacao.php");
require_once("restricao.php");
$sql="SELECT * FROM graus";
$query=mysqli_query($ligar, $sql);
$total=mysqli_num_rows($query);
// se houver registos é que faço o fetch
if($total>0){
// faço o fetch
$fetch=mysqli_fetch_assoc($query);
}
?>
<!DOCTYPE html>
<html lang="pt">
<head>
<meta charset="UTF-8">
<title>Listar Graus</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
</head>
<body>
<div class="container">
<?php require_once("navBar.php");?>
<div class="jumbotron jumbotron-fluid">
<div class="container">
<h1 class="display-4">Lista de graus</h1>
<table class="table">
<thead class="thead-dark">
<tr>
<th scope="col">#</th>
<th scope="col">Grau</th>
<th scope="col">Observações</th>
<th scope="col">Estado</th>
<th scope="col">Alterar</th>
</tr>
</thead>
<tbody>
<!--(inicio tabela) esta tr depende do fetch -->
<?php $i=0; do { $i++; ?>
<tr>
<th scope="row">
<?php echo $i ;?>
</th>
<td>
<?php echo $fetch['grau'];?>
</td>
<td>
<?php echo $fetch['obs'];?>
</td>
<td>
<?php
if($fetch['estado']==1){ echo "Ativo";}elseif($fetch['estado']==0){ echo "Inativo";}
?>
</td>
<td><a href="grausAlterar.php?idGrau=<?PHP echo $fetch['id'];?>">Editar</a></td>
</tr>
<?php } while($fetch=mysqli_fetch_assoc($query));?>
<!-- (fim da tabela)-->
</tbody>
</table>
</div>
</div>
</div>
<?php require_once("scripts.php"); ?>
</body>
</html>
--------------------------------------------------
grausAlterar.php
<?php
// parte 1 --> Pesquisa pelo filtro
require_once("ligacao.php");
require_once("restricao.php");
$id=$_GET['idGrau'];
if(!isset($_GET['alterar'])){
$sql="SELECT * FROM graus WHERE id=$id";
$query=mysqli_query($ligar, $sql);
$total=mysqli_num_rows($query);
$fetch=mysqli_fetch_assoc($query);
}
elseif(isset($_GET['alterar'])){
// vou alterar
$grau=$_GET['grau'];
$obs=$_GET['obs'];
$estado=$_GET['estado'];
$id=$_GET['id'];
// testar se o grau existe
$sql="SELECT id FROM graus WHERE grau LIKE '$grau'";
$query=mysqli_query($ligar, $sql);
$total=mysqli_num_rows($query);
$fetch=mysqli_fetch_assoc($query);
if($total==0 or $id==$fetch['id']){
$sql="UPDATE graus SET grau = '$grau', obs = '$obs', estado = $estado, idUser = $idUser WHERE id = $id ";
mysqli_query($ligar, $sql);
$caminho="grausListar.php?alterado";
} elseif($total>0 and $id!=$fetch['id']){
$caminho="?naoAlterado&idGrau=$id";
}
header("Location:$caminho");
}
// parte 2 --> Altera o registos através dos dados que vêm do form
?>
<!DOCTYPE html>
<html lang="pt">
<head>
<meta charset="UTF-8">
<title>Alterar graus</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
</head>
<body>
<div class="container">
<?php require_once("navBar.php");?>
<div class="jumbotron">
<?php require_once("mensagensURL.php"); ?>
<h1 class="display-4">Alteração de um Grau</h1>
<p class="lead">Esta página serve para alterar registos dos graus que serão usados no momento de criar cursos.</p>
<hr class="my-4">
<p>Note que não pode haver 2 graus repetidos.</p>
<?php if($total>0){?>
<form>
<div class="form-group">
<label for="grau">Grau: *</label>
<input class="form-control" type="text" name="grau" required value="<?php echo $fetch['grau'];?>">
</div>
<div class="form-group">
<label for="grau">Observações:</label>
<textarea class="form-control" name="obs"><?php echo $fetch['obs'];?></textarea>
</div>
<div class="form-group">
<label for="estado">Estado:</label>
<select class="form-control" name="estado">
<?php if($fetch['estado']==1){?>
<option value="1">Ativo</option>
<option value="0">Inativo</option>
<?php }?>
<?php if($fetch['estado']==0){?>
<option value="0">Inativo</option>
<option value="1">Ativo</option>
<?php }?>
</select>
</div>
<div class="form-group">
<input class="btn btn-warning" type="submit" name="alterar" value="Alterar dados do Grau">
</div>
<p class="lead">* obrigatório</p>
<input type="hidden" name="id" value="<?php echo $id;?>">
</form>
<?php }?>
<?php if($total==0){?>
<h3 class="btn-warning">Não há dados para a pesquisa</h3>
<?php }?>
</div>
</div>
<?php require_once("scripts.php"); ?>
</body>
</html>
<?php
?>
Sem comentários:
Enviar um comentário