del usr.php

SUBMITTED BY: Lucas312

DATE: Dec. 13, 2016, 12:01 a.m.

FORMAT: PHP

SIZE: 502 Bytes

Raw Download

HITS: 408

Report

<?php
 
require_once 'init.php';
 
// pega o ID da URL
$id = isset($_GET['id']) ? $_GET['id'] : null;
 
// valida o ID
if (empty($id))
{
    echo "ID não informado";
    exit;
}
 
// remove do banco
$PDO = db_connect();
$sql = "DELETE FROM users WHERE id = :id";
$stmt = $PDO->prepare($sql);
$stmt->bindParam(':id', $id, PDO::PARAM_INT);
 
if ($stmt->execute())
{
    header('Location: index.php');
}
else
{
    echo "Erro ao remover";
    print_r($stmt->errorInfo());
}
?>