Delete_Normal_Posts.php

<?php

session_start();

include('config.php');

if(isset($_POST['drop']))
{
    $post_id = $_POST['post_id'];

    Drop_Post($post_id);
}
else
{
    $send = "single-post.php?post_id=$post_id&error_message=Unrecognized Request";

    header("location: $send");

    exit;
}

function Drop_Post($post_id)
{
    include 'config.php';

    $SQL = "DELETE FROM posts WHERE Post_ID = $post_id";

    $stmt = $conn->prepare($SQL);

    if ($stmt->execute())
    {
        Drop_Likes($post_id);

        Drop_Comments($post_id);

        Drop_Count();

        header("location: home.php");

        exit;

    } else {

        $send = "single-post.php?post_id=$post_id&error_message=Problem With Drop Your Post";

        header("location: $send");

        exit;
    }
}

function Drop_Likes($post_id): void
{
    include 'config.php';

    $SQL = "DELETE FROM likes WHERE Post_ID = $post_id";

    $stmt = $conn->prepare($SQL);

    $stmt->execute();
}

function Drop_Comments($post_id): void
{
    include 'config.php';

    $SQL = "DELETE FROM comments WHERE POST_ID = $post_id";

    $stmt = $conn->prepare($SQL);

    $stmt->execute();
}

function Drop_Count(): void
{
    include 'config.php';

    $user_id = $_SESSION['id'];

    $SQL = "UPDATE users SET POSTS = POSTS-1 WHERE User_ID = $user_id;";

    $stmt = $conn->prepare($SQL);

    $stmt->execute();

    $_SESSION['postcount'] = $_SESSION['postcount']-1;
}