delete_micropost.php

<?php
 session_start();
require("includes/init.php");
 include('filters/auth_filter.php');

if(!empty($_GET['id'])){
    $q = $db->prepare('SELECT user_id FROM microposts WHERE id = :id');
    $q->execute([
        'id' => $_GET['id']
 ]);

 $data = $q->fetch(PDO::FETCH_OBJ);
   $user_id = $data->user_id;

     if($user_id == get_session('user_id')){

             $q = $db->prepare('DELETE FROM micropost_likes WHERE micropost_id = :id');
             $q->execute([
                 'id' => $_GET['id']
            ]);

             $q = $db->prepare('DELETE FROM microposts WHERE id = :id');
             $q->execute([
                 'id' => $_GET['id']
             ]);
         set_flash("Votre publication a été supprimée avec succès!","success");
     }
 }

 redirect('profile.php?id='.get_session('user_id'));