Doubt about UPDATE (Edit.php)

0

I am developing a process registration system for the City Hall of my city and I came up with a question.

Is it possible, after registering the data, to edit the data only once? Only one, after that, is "uneditable".

Follow the edit code, if anyone has any ideas!

<?php
require 'conexao.php';

// Recebe o id do cliente do cliente via GET
$id_cliente = (isset($_GET['id'])) ? $_GET['id'] : '';

// Valida se existe um id e se ele é numérico
if (!empty($id_cliente) && is_numeric($id_cliente)):

	// Captura os dados do cliente solicitado
	$conexao = conexao::getInstance();
	$sql = 'SELECT id, numero, nome, status, setor1, setor2, data1, observ1, setor3, setor4, data2, observ2, setor5, setor6, data3, observ3 FROM processos WHERE id = :id';
	$stm = $conexao->prepare($sql);
	$stm->bindValue(':id', $id_cliente);
	$stm->execute();
	$cliente = $stm->fetch(PDO::FETCH_OBJ);

endif;

?>
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
	<title>Edição de Processo</title>
	<link rel="stylesheet" type="text/css" href="css/bootstrap.min.css">
	<link rel="stylesheet" type="text/css" href="css/custom.css">
		<style type="text/css">
	<!--
body {
	background-image: url("./img/bg.jpg");
	background-repeat: no-repeat;
	background-attachment: fixed;
    background-position: center;
    background-size: cover;
}
<!---->
</style>
</head>
<body>
	<div class='container'>
		<fieldset>
			<legend><h1>Formulário - Edição de Processo</h1></legend>
			
			<?php if(empty($cliente)):?>
				<h3 class="text-center text-danger">Processo não encontrado!</h3>
			<?php else: ?>
				<form action="all_processo.php" method="post" id='form-contato' enctype='multipart/form-data'>
					<div class="row">
					
									<p><div class='form-group'>
					<label for='numero'>Número do Processo</label>
					<input type='number' class='form-control' id='numero' name='numero' value="<?=$cliente->numero?>" placeholder='Informe o Número do Processo'>
					<span class='msg-erro msg-numero'></span>
					</div></p>

				    <p><div class="form-group">
				      <label for="nome">Nome do Processo</label>
				      <input type="text" class="form-control" id="nome" name="nome" value="<?=$cliente->nome?>" placeholder="Informe o Nome">
				      <span class='msg-erro msg-nome'></span>
				    </div></p>
				    <p><div class="form-group">
				      <label for="status">Status do Processo</label>
				      <select class="form-control" name="status" id="status">
					    <option value="<?=$cliente->status?>"><?=$cliente->status?></option>
					    <option value="Ativo">Ativo</option>
					    <option value="Inativo">Inativo</option>
					  </select>
					  <span class='msg-erro msg-status'></span>
				    </div></p>

				    <p><div class="form-group">
				      <label for="setor">Setor 1</label>
				      <input type="text" value="<?=$cliente->setor1?>" class="form-control" id="setor1" name="setor1" placeholder="Informe o Setor Inicial"> Setor 2 <input type="text" value="<?=$cliente->setor2?>" class="form-control" id="setor2" name="setor2" placeholder=" Informe o Setor Final">
				      <p><label for="data1">Data:</label>
					<input type="date" name="data1" id="data1" value="<?=$cliente->data1?>" /></p>
					<p><label><p>Observações</p></label>  
					<textarea  name="observ1" id='observ1' rows="6" cols="50" placeholder="Informe as observações sobre o processo"><?=$cliente->observ1?></textarea></P>
					 <span class='msg-erro msg-setor'></span></div>
					  
					   <p><div class="form-group">
				      <label for="setor">Setor 3</label>
				      <input type="text" value="<?=$cliente->setor3?>" class="form-control" id="setor3" name="setor3" placeholder="Informe o Setor Inicial"> Setor 4 <input type="text" value="<?=$cliente->setor4?>" class="form-control" id="setor4" name="setor4" placeholder=" Informe o Setor Final">
				       <p><label for="data2">Data:</label>
					<input type="date" name="data2" id="data2" value="<?=$cliente->data2?>" /></p>
					<p><label><p>Observações</p></label>  
					<textarea  name="observ2" id='observ2' rows="6" cols="50" placeholder="Informe as observações sobre o processo"><?=$cliente->observ2?></textarea></P>
					 <span class='msg-erro msg-setor'></span></div>
					  
					  <p><div class="form-group">
				      <label for="setor">Setor 5</label>
				      <input type="text" value="<?=$cliente->setor5?>" class="form-control" id="setor5" name="setor5" placeholder="Informe o Setor Inicial"> Setor 6 <input type="text" value="<?=$cliente->setor6?>" class="form-control" id="setor6" name="setor6" placeholder=" Informe o Setor Final">
				      <p><label for="data3">Data:</label>
					<input type="date" name="data3" id="data3" value="<?=$cliente->data3?>" /></p>
					<p><label><p>Observações</p></label>  
					<textarea  name="observ3" id='observ3' rows="6" cols="50" placeholder="Informe as observações sobre o processo"><?=$cliente->observ3?></textarea></P>
					 <span class='msg-erro msg-setor'></span></div>
					
				    <input type="hidden" name="acao" value="editar">
				    <input type="hidden" name="id" value="<?=$cliente->id?>">
				   <p> <button type="submit" class="btn btn-primary" id='botao'> 
				      Salvar
				    </button></p>
				    <a href='listarprocessos.php' class="btn btn-danger">Cancelar</a>
				</form>
			<?php endif; ?>
		</fieldset>

	</div>
	<script type="text/javascript" src="js/custom.js"></script>
</body>
</html>

Thank you in advance!

    
asked by anonymous 01.03.2018 / 17:23

1 answer

4

It is possible if you create a field in your database called edicoes NOT NULL and default 0 and there you save the number of times that record was edited.

When you edit the first time, it changes from 0 to 1.

And before any editing, validate if the number of editions of that record is 0, otherwise do not allow editing to be done on PHP itself.

    
01.03.2018 / 17:27