php-CRUD/post_delete.php at main · armin-lambda/php-CRUD · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
<?php

session_start();
require "core/config.php";

if (!isset($_GET["id"])) {
    header("location: index.php");
    exit();
}

try {
    $post_query = $connection->query("SELECT * FROM post WHERE ID = '{$_GET['id']}'");
    $post = mysqli_fetch_all($post_query);

    if ($post) {
        $connection->query("DELETE FROM post WHERE ID = '{$_GET['id']}'");

        $_SESSION["message"] = "Post was deleted successfully";
        $_SESSION["message-type"] = "primary";

        header("location: index.php");
        exit();
    } else {
        header("location: index.php");
        exit();
    }
} catch (Exception $e) {
    $_SESSION["message"] = "Something went wrong";
    $_SESSION["message-type"] = "danger";

    header("location: index.php");
    exit();
}
?>