User deletion system by the user himself

Question

For some time I’ve been trying to develop a system of account deletion by the user, like what we see on facebook and twitter where in the user’s settings, the same can choose to delete your account. But my attempts were thwarted.

So I decided to come here as always. Some tutorial step by step?

This is the php code I tried (close.php):

$id = $_SESSION['id'];

if ($usuario) {
	if (isset($_POST['sim'])) {
		header("location: /configuracoes");
	}
		if (isset($_POST['nao'])) {
		$fecharconta = mysql_query("UPDATE usuario SET `fechada`='$fechada' WHERE id='$id'");
		echo "Sua conta foi fechada";
		session_destroy();
	}
}
else {
	die("Você não está logado!");
}

and this is HTML:

<div id="conteudo">
		<div class="conteudo-fundo">
			<form action="fecharconta.php" method="POST">
				Você tem certeza de que pretende fechar sua conta?<br>
				<input type="submit" name="no" value="Não, me leve de volta">
				<input type="submit" name="yes" value="Sim, eu tenho certeza">
			</form>
		</div>
	</div>

And highlighted in red is the column I created in the database to check if the user is active I inactive.

Finally, after trying so hard and with tips from the community, I managed to solve the problem.

I managed to solve the problem, I will make available here the code I used and the steps.

This is the html code that has an action pointing to deactivate.php account

<div id="conteudo">
		<div class="conteudo-fundo">
			<form action="view/desativar-conta.php" method="POST">
				Você tem certeza de que pretende fechar sua conta?<br>
				<input type="submit" name="no" value="Não, me leve de volta">
				<input type="submit" name="yes" value="Sim, eu tenho certeza">
			</form>
		</div>
	</div>

This is the file code deactivate.php account

<?php


include_once("../php/dados.php");

$id = $_SESSION['id'];

	$sql = mysqli_query("SELECT * FROM usuario WHERE email='$login_cookie'");
	$dado = mysqli_fetch_assoc($sql);
session_start();
if ($id) {
	if (isset($_POST['no'])) {
		header("location: /configuracoes");
	}
	if (isset($_POST['yes'])) {
		$desativar = mysql_query ("UPDATE usuario SET desativada='yes' WHERE id='$id'");
		echo "Sua conta foi desativada!";
		session_destroy();
	}
}
else{
	die(header("location: ./../"));
}
?>

When the User clicks on the input with value: "Yes, I’m sure", it automatically changes the value of the column deactivated in the database.

I also added the following to the php login code: deactivated = 'no', which only allows the user to login when the column deactivated is 'in the'.

The code within that login.php, within the variable that selects the database data was the following:

SELECT * FROM user WHERE email='$email' AND password='$password' AND disabled='no'

And in the photo below, highlighted in orange is the column deactivated